Postgres
提供: wikipokpok
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