469,148 Members | 1,286 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,148 developers. It's quick & easy.

how to restart on OS X

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
2 3532


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

Similar topics

1 post views Thread by Piotr Trawiñski | last post: by
1 post views Thread by localhost | last post: by
18 posts views Thread by amdishigh | last post: by
3 posts views Thread by John A Grandy | last post: by
6 posts views Thread by Leonardo Curros | last post: by
8 posts views Thread by kenneth fleckenstein nielsen | last post: by
4 posts views Thread by shorti | last post: by
1 post views Thread by Brian Simmons | last post: by
1 post views Thread by CARIGAR | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.