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"?
`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!
Type psql -U postgres at the prompt, and hit Enter. Here, postgres represents the username of the database superuser.
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
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With