Re: [GENERAL] Configuring phpPgAdmin and pg_ctl reload

2007-03-22 Thread John Meyer
Douglas McNaught wrote: John Meyer <[EMAIL PROTECTED]> writes: Maybe it was just understood, but I was typing in word for word the entry from pg_hba.conf, but I'll keep that for reference later on. pg_ctl needs either the data directory supplied on the command line, or PGDATA set in the envir

Re: [GENERAL] Configuring phpPgAdmin and pg_ctl reload

2007-03-22 Thread Douglas McNaught
John Meyer <[EMAIL PROTECTED]> writes: > Maybe it was just understood, but I was typing in word for word the > entry from pg_hba.conf, but I'll keep that for reference later on. pg_ctl needs either the data directory supplied on the command line, or PGDATA set in the environment, which reading th

Re: [GENERAL] Configuring phpPgAdmin and pg_ctl reload

2007-03-22 Thread John Meyer
Ashish Karalkar wrote: 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" <[EMAIL PROTECTED]> To: "postgresql-general" Sent: Thursday, March 22, 2007 8:31 AM Subject: [GENER

Re: [GENERAL] Configuring phpPgAdmin and pg_ctl reload

2007-03-21 Thread Ashish Karalkar
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" <[EMAIL PROTECTED]> To: "postgresql-general" Sent: Thursday, March 22, 2007 8:31 AM Subject: [GENERAL] Configuring ph

Re: [GENERAL] Configuring phpPgAdmin and pg_ctl reload

2007-03-21 Thread Devrim GÜNDÜZ
Hi, On Wed, 2007-03-21 at 21:01 -0600, John Meyer wrote: > > pg_ctl reload > pg_ctl: no database directory specified and environment variable > PGDATA unset You should use pg_ctl -D /path/to/your/data/dir reload See man page for details. Regards, -- Devrim GÜNDÜZ PostgreSQL Replication, Co

[GENERAL] Configuring phpPgAdmin and pg_ctl reload

2007-03-21 Thread John Meyer
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 en