Mac Postgres

기록 2015. 10. 5. 16:24

brew install postgres


==> Installing dependencies for postgresql: readline

==> Installing postgresql dependency: readline

==> Downloading https://homebrew.bintray.com/bottles/readline-6.3.8.yosemite.bottle.tar.

######################################################################## 100.0%

==> Pouring readline-6.3.8.yosemite.bottle.tar.gz

==> Caveats

This formula is keg-only, which means it was not symlinked into /usr/local.


OS X provides the BSD libedit library, which shadows libreadline.

In order to prevent conflicts when programs look for libreadline we are

defaulting this GNU Readline installation to keg-only.



Generally there are no consequences of this for you. If you build your

own software and it requires this formula, you'll need to add to your

build variables:


    LDFLAGS:  -L/usr/local/opt/readline/lib

    CPPFLAGS: -I/usr/local/opt/readline/include


==> Summary

🍺  /usr/local/Cellar/readline/6.3.8: 40 files, 2.1M

==> Installing postgresql

==> Downloading https://homebrew.bintray.com/bottles/postgresql-9.4.4.yosemite.bottle.ta

######################################################################## 100.0%

==> Pouring postgresql-9.4.4.yosemite.bottle.tar.gz

==> /usr/local/Cellar/postgresql/9.4.4/bin/initdb /usr/local/var/postgres

==> 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/2510


To migrate existing data from a previous major version (pre-9.4) of PostgreSQL, see:

  https://www.postgresql.org/docs/9.4/static/upgrading.html


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

==> Summary

🍺  /usr/local/Cellar/postgresql/9.4.4: 3014 files, 40M



createdb 'whoami'

psql 'whoami'


#접속

\c DatabaseName


#

'기록' 카테고리의 다른 글

Raspberry2 Postgress  (0) 2015.11.23
Node.js Forever 사용법  (0) 2015.10.22
맥북에서 윈도우 키보드 맥 키보드처럼 사용하기  (0) 2015.09.04
AWS Ubuntu Setting  (0) 2015.09.04
Mac Server Setting  (0) 2015.09.04
Posted by bbd531
,