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@xxxxxxxxx>
To: "postgresql-general" <pgsql-general@xxxxxxxxxxxxxx>
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
