Re: Configuring phpPgAdmin and pg_ctl reload

Try

pg_ctl  -D /path to pg data home

e.g.

pg_ctl -D /usr/local/pgsql/data

Hope this will help


----- Original Message -----
From: "John Meyer" <john.l.meyer@gmail.com>
To: "postgresql-general" <pgsql-general@postgresql.org>
Sent: Thursday, March 22, 2007 8:31 AM
Subject: [GENERAL] Configuring phpPgAdmin and pg_ctl reload


> I'm setting up phpPgAdmin and I finally get to the point where you
> reconfigure pg_hba.conf  One of the lines says to reload the values,
> type the command pg_ctl reload.  I try it as super user, no go, I su
> into postgres, it complains:
>
> pg_ctl reload
> pg_ctl: no database directory specified and environment variable PGDATA
> unset
> Try "pg_ctl --help" for more information.
>
>
> Keeping in mind that I typed just what pga_hba.conf said, was there a
> step I was missing (I ended up restarting the server and that worked).
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>       choose an index scan if your joining column's datatypes do not
>       match