Обсуждение: 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
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
> >> 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