「Postgres」を編集中

[[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''

 psql -d tepnote_development

 tepnote_development=# \d

 pg_restore -c -d tepnote_development shrieking_dump/latest.dump