Thread: Clarification

Clarification

From
ElayaRaja S
Date:
Hi,
  I am using postgreSQL 7.4.5 in Redhat Linux 9. Whenever i faced
power failure ,
i am unable to stop the postgres.

bash-2.05b$ pg_ctl stop
/usr/local/pgsql/bin/pg_ctl: line 274: kill: (19859) - No such process
waiting for postmaster to shut
down................................................................
failed
pg_ctl: postmaster does not shut down


Please help me regarding this.

--
Warm Regards,

S.ElayaRaja
Mobile:  (+91) 98450 59540
E-Mail:  elayaraja.s@gmail.com
            raja_nk@hotmail.com

Re: Clarification

From
Tom Lane
Date:
ElayaRaja S <elayaraja.s@gmail.com> writes:
> bash-2.05b$ pg_ctl stop
> /usr/local/pgsql/bin/pg_ctl: line 274: kill: (19859) - No such process
> waiting for postmaster to shut
> down................................................................
> failed
> pg_ctl: postmaster does not shut down

Is there actually a postmaster running?  Is pg_ctl looking in the right
data directory?  The above could happen if you have a PGDATA environment
setting that corresponds to a data directory that's not actively in use.

            regards, tom lane