osx - psql -h localhost won't connect on Mac OS X -
per postgresapp.com
psql postgresql command-line interface database. mac os 10.7 ships older version of postgresql, can started following command:
$ psql -h localhost
so run psql -h localhost
, get
dans-macbook-pro:~ djechlin$ psql -h localhost psql: not connect server: connection refused server running on host "localhost" (127.0.0.1) , accepting tcp/ip connections on port 5432?
as far can tell psql
client side, , postgresapp.com's documentation talking smack. still have no idea how start postgres server locally , haven't been able find documentation on that.
version:
dans-macbook-pro:~ djechlin$ psql --version psql (postgresql) 9.1.5 contains support command-line editing
i'm on mac 10.8.4.
this admittedly more confusing should have been, but...
pg_ctl
command responsible starting postgres server. os x not come bundled it. how run explained in pre-postgres.app answer.- when install postgres.app , run it, starts server, don't have manage it. that's added value of postgres.app if have client-side tools installed.
Comments
Post a Comment