Clarification

Started by ElayaRaja Salmost 21 years ago2 messagesgeneral
Jump to latest
#1ElayaRaja S
elayaraja.s@gmail.com

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: ElayaRaja S (#1)
Re: Clarification

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