Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

postgresql - start on mac - `pg_ctl` not working

I want to use the pre-installed postgresql on my local machine (mac os 10.7.5), when I run which psql I find it (in /usr/bin/psql), but then running

pg_ctl -D /usr/bin/psql -l /usr/bin/psql/server.log start

results in:

-bash: pg_ctl: command not found

How can I start/use my postgresql database? do I need to install it (with say Homebrew) or can I use the pre-installed one on my mac? I also tried using the initdb command (initdb /usr/bin/psql -E utf8) and also go tthe same message: -bash: initdb: command not found.

Also, is this psql the same as postgres? (I tried which postgres and got nothing)

Update: I'm using psql commands in the command line, but am getting there the following message (for psql -l and psql -a for instance):

psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/pgsql_socket/.s.PGSQL.5432"?
like image 875
Lucy Weatherford Avatar asked Apr 20 '13 09:04

Lucy Weatherford


People also ask

How do I start PostgreSQL on Mac terminal?

`psql` on Terminal To get to the PostgreSQL terminal, open your terminal, start the database services ( brew services start postgresql) , then run psql . Thank you!

How do I start PostgreSQL in terminal?

Type psql -U postgres at the prompt, and hit Enter. Here, postgres represents the username of the database superuser.


1 Answers

OS X ships with the command line client (for interacting with postgres databases) not the server.

You need to install the server.

Check the postgres site or grab the postgres.app

like image 73
Chris Farmiloe Avatar answered Oct 17 '22 00:10

Chris Farmiloe