[備忘録] postgresql [工事中]

postgresql - mac

インストールとか

とりあえずこの流れでインストールまで行く。

$ brew list
$ brew update
$ brew search postgresql
$ brew install postgresql

インストール後のターミナルの結果（格納先）

〜〜〜略
🍺  /usr/local/Cellar/postgresql/10.1: 3,372 files, 38.8MB

install後の色々な確認

$ psql --version
psql (PostgreSQL) 10.1

$ which postgres  
/usr/local/bin/postgres

文字コードにUTF-8を指定してDBを初期化(エラーに見えるけど問題なし)

CMD

$ initdb /usr/local/var/postgres -E utf8

OUTPUT

The files belonging to this database system will be owned by user "｛ユーザー名｝". 
This user must also own the server process.

The 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: 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".

起動

CMD

$ brew services start postgresql

OUTPUT

==> Tapping homebrew/services
Cloning into '/usr/local/Homebrew/Library/Taps/homebrew/homebrew-services'...
remote: Counting objects: 14, done.
remote: Compressing objects: 100% (10/10), done.
remote: Total 14 (delta 0), reused 9 (delta 0), pack-reused 0
Unpacking objects: 100% (14/14), done.
Checking connectivity... done.
Tapped 0 formulae (42 files, 55.2KB)
==> Successfully started `postgresql` (label: homebrew.mxcl.postgresql)

DB一覧の取得(初期化後のDBクラスタには３つのDBが存在）

CMD

$ psql -l

OUTPUT

                                        List of databases
   Name    |    Owner     | Encoding |   Collate   |    Ctype    |       Access privileges       
-----------+--------------+----------+-------------+-------------+-------------------------------
 postgres  |  {user name} | UTF8     | ja_JP.UTF-8 | ja_JP.UTF-8 | 
 template0 |  {user name} | UTF8     | ja_JP.UTF-8 | ja_JP.UTF-8 | =c/{user name}              +
           |              |          |             |             | {user name}=CTc/{user name}
 template1 |  {user name} | UTF8     | ja_JP.UTF-8 | ja_JP.UTF-8 | =c/{user name}              +
           |              |          |             |             | {user name}=CTc/{user name}
(3 rows)

DB作成

$ createdb test

DB接続

psql test

DBへの接続

$ psql test
psql (10.1)
Type "help" for help.

test=#