Fwd: pg_ctl problem - Mailing list pgsql-bugs

Madhu... Please.... please... please.... use the 'REPLY TO ALL' option in
your mail client.

Forwarding again to the bugs list, in the hopes of pooling in others.

---------- Forwarded message ----------
From: <madhu.harchandani@wipro.com>
Date: Tue, Mar 4, 2008 at 7:02 PM
Subject: RE: [BUGS] pg_ctl problem
To: singh.gurjeet@gmail.com



 Hi again


   pg_ctl start is running

   pg_ctl start -l logfile -D /var/lib/pgsql/data
   could not change directory to "/root"
   server starting
*********************************************************************
  Sir there is no any problem if we start rather than reload it.

******************************************************************
  but if i write
  pg_ctl reload -l logfile -D /var/lib/pgsql/data
  could not change directory to "/root"
  pg_ctl: PID file "/var/lib/pgsql/data/postmaster.pid" does not exist
  Is server running?

  Here i am writing in /var/lib/pgsql/data
  the output of the command which u told me is
  [root@mkd2ts2s-167471 ~]# ps aux | grep postmaster
 postgres  6219  0.0  0.3  35872  3048 ?        S    15:16   0:00
/usr/local/pgsql/bin/postmaster -D   /usr/local/pgsql/data
 root      7270  0.0  0.0   4044   680 pts/1    S+   17:56   0:00 grep
postmaster


[root@mkd2ts2s-167471 ~]# ps aux | grep postgres
postgres  6219  0.0  0.3  35872  3048 ?        S    15:16   0:00
/usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data
postgres  6221  0.0  0.1  35872   976 ?        Ss   15:16   0:00 postgres:
writer process
postgres  6222  0.0  0.0   7320   656 ?        Ss   15:16   0:00 postgres:
stats collector process
root      6223  0.0  0.1   4700  1204 pts/2    S    15:16   0:00 su postgres
postgres  6224  0.0  0.1   4704  1376 pts/2    S+   15:16   0:00 bash
root      7300  0.0  0.0   4044   684 pts/1    S+   17:56   0:00 grep
postgres
************************************************888




One more problem sir
bash-3.2$ psql -d xnat -f sql/xnat.sql -U xnat
could not change directory to "/root"
psql: FATAL:  Ident authentication failed for user "xnat"

I will be very obliged if u would solve my problem actually i have to start
my project

thanks
Regards
Madhu Harchandani

The information contained in this electronic message and any attachments to
this message are intended for the exclusive use of the addressee(s) and may
contain proprietary, confidential or privileged information. If you are not
the intended recipient, you should not disseminate, distribute or copy this
e-mail. Please notify the sender immediately and destroy all copies of this
message and any attachments.

WARNING: Computer viruses can be transmitted via email. The recipient should
check this email and any attachments for the presence of viruses. The
company accepts no liability for any damage caused by any virus transmitted
by this email.

www.wipro.com



--=20
gurjeet[.singh]@EnterpriseDB.com
singh.gurjeet@{ gmail | hotmail | indiatimes | yahoo }.com

EnterpriseDB      http://www.enterprisedb.com

17=B0 29' 34.37"N,  78=B0 30' 59.76"E - Hyderabad
18=B0 32' 57.25"N,  73=B0 56' 25.42"E - Pune *
37=B0 47' 19.72"N, 122=B0 24' 1.69" W - San Francisco

http://gurjeet.frihost.net

Mail sent from my BlackLaptop device