Skip site navigation (1) Skip section navigation (2)

postgresSQL data directory

From: Thanh Q Lam <thanh(dot)q(dot)lam(at)alcatel(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: postgresSQL data directory
Date: 2005-07-08 14:24:31
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs

We have a problems with postgresSQL 7.1.3 that suddenly all databases 
don't work, and it logged the following message,

pq_recvbuf: unexpected EOF on client connection
pq_recvbuf: unexpected EOF on client connection
Smart Shutdown request at Fri Jul  8 09:19:47 2005
DEBUG:  shutting down
DEBUG:  database system is shut down

I ran pg_ctl restart/start/stop, nothing works and the error log showed 
this message,

simba[postgres][44]% more postmaster.log.994
/rms2/pgsql/bin/postmaster does not find the database system.
    Expected to find it in the PGDATA directory "/nsm/pgsql/data",
    but unable to open file "/nsm/pgsql/data/global/pg_control": No such 
file or directory

I tried setenv PGDATA to /nsm/pgsql/data, but it still doesn't work.  
Then I moved the current data directory to data.bak and ran initdb 
--pgdata /nsm/pgsql/data to initialized the data cluster and replaced 
the data.bak with data, but no luck the postgres server still failed 
starting up.
Since I don't have the dumpall up-to-date file, so I can't run a restore 
of the database.  So, is there any ways to startup the postgres server 
to use my current data cluster?

Thanks in advance,



pgsql-bugs by date

Next:From: Richard HuxtonDate: 2005-07-08 15:21:28
Subject: Re: postgresSQL data directory
Previous:From: JackDate: 2005-07-08 12:39:46
Subject: BUG #1761: missing files

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group