By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,933 Members | 1,686 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,933 IT Pros & Developers. It's quick & easy.

how to restart on OS X

P: n/a
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

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a


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)
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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 12 '05 #2

P: n/a
>
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
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.