Sridhar
such questions shud be posted to pgsql-admin list.
generally in case of power failure pgsql is unable to remove its
pid file., if u are using RPM based installation the file shud be in
/var/lib/pgsql/ in the name of postmaster.pid
If such a file exists postmaster will refuse to start. in
I had a m/c with Postgres 7.2 and huge amount of data. on Power
failure and restart of the m/c pgsql refused connect to any of the
database. Being an invoice i took a tar of the data dir.
I tried reinstalling PGSQL and copied the data dir to the same dir
where the new data is being stored. ie
cp /b
