brewでpostgresqlを確認
- postgresqlの設置情報を確認してみると、まだ設置されていないし、依存関係にあるlibraryも表示されます。
[devnote@hooni:~] % brew info postgresql
postgresql: stable 9.3.5 (bottled), devel 9.4rc1
http://www.postgresql.org/
Conflicts with: postgres-xc
Not installed
From: https://github.com/Homebrew/homebrew/blob/master/Library/Formula/postgresql.rb
==> Dependencies
Required: openssl ✔, readline ✔
Recommended: ossp-uuid ✘
==> Options
--32-bit
Build 32-bit only
--enable-dtrace
Build with DTrace support
--no-perl
Build without Perl support
--no-tcl
Build without Tcl support
--with-python
Build with python support
--without-ossp-uuid
Build without ossp-uuid support
--devel
install development version 9.4rc1
==> Caveats
If builds of PostgreSQL 9 are failing and you have version 8.x installed,
you may need to remove the previous version first. See:
https://github.com/Homebrew/homebrew/issues/issue/2510
To migrate existing data from a previous major version (pre-9.3) of PostgreSQL, see:
http://www.postgresql.org/docs/9.3/static/upgrading.html
When installing the postgres gem, including ARCHFLAGS is recommended:
ARCHFLAGS="-arch x86_64" gem install pg
To install gems without sudo, see the Homebrew documentation:
https://github.com/Homebrew/homebrew/blob/master/share/doc/homebrew/Gems,-Eggs-and-Perl-Modules.md
To have launchd start postgresql at login:
ln -sfv /usr/local/opt/postgresql/*.plist ~/Library/LaunchAgents
Then to load postgresql now:
launchctl load ~/Library/LaunchAgents/homebrew.mxcl.postgresql.plist
Or, if you don't want/need launchctl, you can just run:
postgres -D /usr/local/var/postgres
brewでpostgresqlを設置
- homebrewで設置すると依存関係にあるlibraryも一緒に設置されます。
[devnote@hooni:~] % brew install postgresql
==> Installing postgresql dependency: ossp-uuid
==> Downloading https://downloads.sf.net/project/machomebrew/Bottles/ossp-uuid-1.6.2_1.yosemite.bottle.tar.gz
######################################################################## 100.0%
==> Pouring ossp-uuid-1.6.2_1.yosemite.bottle.tar.gz
🍺 /usr/local/Cellar/ossp-uuid/1.6.2_1: 16 files, 256K
==> Installing postgresql
==> Downloading https://downloads.sf.net/project/machomebrew/Bottles/postgresql-9.3.5_1.yosemite.bottle.1.tar.gz
######################################################################## 100.0%
==> Pouring postgresql-9.3.5_1.yosemite.bottle.1.tar.gz
==> Caveats
If builds of PostgreSQL 9 are failing and you have version 8.x installed,
you may need to remove the previous version first. See:
https://github.com/Homebrew/homebrew/issues/issue/2510
To migrate existing data from a previous major version (pre-9.3) of PostgreSQL, see:
http://www.postgresql.org/docs/9.3/static/upgrading.html
When installing the postgres gem, including ARCHFLAGS is recommended:
ARCHFLAGS="-arch x86_64" gem install pg
To install gems without sudo, see the Homebrew documentation:
https://github.com/Homebrew/homebrew/blob/master/share/doc/homebrew/Gems,-Eggs-and-Perl-Modules.md
To have launchd start postgresql at login:
ln -sfv /usr/local/opt/postgresql/*.plist ~/Library/LaunchAgents
Then to load postgresql now:
launchctl load ~/Library/LaunchAgents/homebrew.mxcl.postgresql.plist
Or, if you don't want/need launchctl, you can just run:
postgres -D /usr/local/var/postgres
==> /usr/local/Cellar/postgresql/9.3.5_1/bin/initdb /usr/local/var/postgres
==> Summary
🍺 /usr/local/Cellar/postgresql/9.3.5_1: 2927 files, 38M
データベースを初期化
- initdbを実行します。実行したことがある場合はそのまま使うか、生成されたデータベースを削除してもう一度initdbを実行します。
[devnote@hooni:~] % initdb /usr/local/var/postgres -E utf8
The files belonging to this database system will be owned by user "devnote".
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".
launchdで起動してデータベースを確認
- 設置するとき書かれていた通りにsymbolic linkを生成して、launchdで起動します。
[devnote@hooni:~] % ln -sfv /usr/local/opt/postgresql/*.plist ~/Library/LaunchAgents
/Users/devnote/Library/LaunchAgents/homebrew.mxcl.postgresql.plist -> /usr/local/opt/postgresql/homebrew.mxcl.postgresql.plist
[devnote@hooni:~] % launchctl load ~/Library/LaunchAgents/homebrew.mxcl.postgresql.plist
- データベース一覧を確認します。
[devnote@hooni:~] % psql -l
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
-----------+---------+----------+-------------+-------------+---------------------
postgres | devnote | UTF8 | ja_JP.UTF-8 | ja_JP.UTF-8 |
template0 | devnote | UTF8 | ja_JP.UTF-8 | ja_JP.UTF-8 | =c/devnote +
| | | | | devnote=CTc/devnote
template1 | devnote | UTF8 | ja_JP.UTF-8 | ja_JP.UTF-8 | =c/devnote +
| | | | | devnote=CTc/devnote
(3 rows)