Thread: postgresSQL data directory
Hi, 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, /Thanh
Thanh Q Lam wrote: > Hi, > > We have a problems with postgresSQL 7.1.3 that suddenly all databases > don't work, and it logged the following message, I'm sure you know that's an old version, but I'll recommend upgrading anyway. > 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, The same message every time? > 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 Is the file there? Are the permissions/ownership right? > 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. Did the initdb work? Was the error message the same? -- Richard Huxton Archonet Ltd
Thanks Richard! I finally got it work. It was caused byethe PGDATA environment variable. I fixed it the .cshrc and reran initdd, then everything's back to normal. Yes, our current postgres is very old and I'm setting up 7.4.8 on another box. Thanks again, Thanh Richard Huxton wrote: > Thanh Q Lam wrote: > >> Hi, >> >> We have a problems with postgresSQL 7.1.3 that suddenly all databases >> don't work, and it logged the following message, > > > I'm sure you know that's an old version, but I'll recommend upgrading > anyway. > >> 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, > > > The same message every time? > >> 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 > > > Is the file there? > Are the permissions/ownership right? > >> 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. > > > Did the initdb work? > Was the error message the same? > > -- > Richard Huxton > Archonet Ltd