how to restart on OS X

Started by Victor Spång Arthurssonover 22 years ago3 messagesgeneral
Jump to latest

Have an installation which comes from Marks site entropy.cz.

But I can't restart the server.

Error message:

[indigo:~] victor% sudo /usr/local/bin/pg_ctl reload
pg_ctl: no database directory or environment variable $PGDATA is
specified
Try 'pg_ctl --help' for more information.
[indigo:~] victor%

Please help! ;)

Sincerely

Victor

#2Adam Witney
awitney@sghms.ac.uk
In reply to: Victor Spång Arthursson (#1)
Re: how to restart on OS X

You need to specify where the installations data directory is

sudo /usr/local/bin/pg_ctl -D /path/to/data reload

For example, on my machine:

sudo -u pgsql /usr/local/bin/pg_ctl -D /usr/local/pgsql/data reload

Although you may have to do this as the postgres/pgsql user rather than root
(not sure about this part though)

Show quoted text

Have an installation which comes from Marks site entropy.cz.

But I can't restart the server.

Error message:

[indigo:~] victor% sudo /usr/local/bin/pg_ctl reload
pg_ctl: no database directory or environment variable $PGDATA is
specified
Try 'pg_ctl --help' for more information.
[indigo:~] victor%

Please help! ;)

Sincerely

Victor

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

In reply to: Victor Spång Arthursson (#1)
Re: how to restart on OS X [solved]

Have an installation which comes from Marks site entropy.cz.

But I can't restart the server.

Error message:

[indigo:~] victor% sudo /usr/local/bin/pg_ctl reload
pg_ctl: no database directory or environment variable $PGDATA is
specified
Try 'pg_ctl --help' for more information.
[indigo:~] victor%

Please help! ;)

Sincerely

Victor

The following solved it:

sudo /usr/local/bin/pg_ctl reload -m immediate -D /usr/local/pgsql/data/

Sincerely

Victor