Обсуждение: cant' pg_ctl find pid file from PGDATA env variable?
[root@ns3 root]# echo $PGDATA /usr/local/pgsql/data [root@ns3 root]# pg_ctl reload pg_ctl: cannot find /usr/local/pgsql/data/postmaster.pid Is postmaster running? [root@ns3 root]# regds mallah. -- Rajesh Kumar Mallah, Project Manager (Development) Infocom Network Limited, New Delhi phone: +91(11)6152172 (221) (L) ,9811255597 (M) Visit http://www.trade-india.com , India's Leading B2B eMarketplace.
oops it was my fault. please ignore. PGDATA was wrongly set. On Wednesday 07 May 2003 1:11 pm, Rajesh Kumar Mallah wrote: > [root@ns3 root]# echo $PGDATA > /usr/local/pgsql/data > [root@ns3 root]# pg_ctl reload > pg_ctl: cannot find /usr/local/pgsql/data/postmaster.pid > Is postmaster running? > [root@ns3 root]# > > > regds > mallah. -- Rajesh Kumar Mallah, Project Manager (Development) Infocom Network Limited, New Delhi phone: +91(11)6152172 (221) (L) ,9811255597 (M) Visit http://www.trade-india.com , India's Leading B2B eMarketplace.
Rajesh Kumar Mallah <mallah@trade-india.com> writes:
> [root@ns3 root]# echo $PGDATA
> /usr/local/pgsql/data
> [root@ns3 root]# pg_ctl reload
> pg_ctl: cannot find /usr/local/pgsql/data/postmaster.pid
> Is postmaster running?
Is PGDATA actually an environment variable --- that is, did you
"export" it?
regards, tom lane
Dear Tom. > Rajesh Kumar Mallah <mallah@trade-india.com> writes: >> [root@ns3 root]# echo $PGDATA >> /usr/local/pgsql/data >> [root@ns3 root]# pg_ctl reload >> pg_ctl: cannot find /usr/local/pgsql/data/postmaster.pid >> Is postmaster running? > > Is PGDATA actually an environment variable --- that is, did you > "export" it? yeah i had exported it in root's env with a wrong value which was not even initdb'ed in the env od postgres user PGDATA was find so i did not realize the mistake. only on running pg_ctl by root i got this error. BTW can you pleeeeez reply to my last question in the now() and timeofday() thread ? Regds mallah. > > regards, tom lane ----------------------------------------- Get your free web based email at trade-india.com. "India's Leading B2B eMarketplace.!" http://www.trade-india.com/