差分

移動先: 案内検索

Postgres

897 バイト追加, 2020年6月6日 (土) 18:01
ページの作成:「{{PAGENAME}} mac 10.15.4 brew update brew install postgresql psql --version psql (PostgreSQL) 12.3 initdb /usr/local/var/postgres -E utf8...」
[[category:memo|{{PAGENAME}}]]
mac 10.15.4
brew update

brew install postgresql

psql --version
psql (PostgreSQL) 12.3

initdb /usr/local/var/postgres -E utf8
The files belonging to this database system will be owned by user "**".
This user must also own the server process.
he database cluster will be initialized with locale "ja_JP.UTF-8".
initdb: could not find suitable text search configuration for locale "ja_JP.UTF-8"
The default text search configuration will be set to "simple".
Data page checksums are disabled.
initdb: error: directory "/usr/local/var/postgres" exists but is not empty
If you want to create a new database system, either remove or empty
the directory "/usr/local/var/postgres" or run initdb
with an argument other than "/usr/local/var/postgres".

brew services start postgresql

psql -l

createuser -d -r ''username''

案内メニュー