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

Re: postgresSQL data directory

From: Richard Huxton <dev(at)archonet(dot)com>
To: Thanh Q Lam <thanh(dot)q(dot)lam(at)alcatel(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: postgresSQL data directory
Date: 2005-07-08 15:21:28
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
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 

> 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

In response to


pgsql-bugs by date

Next:From: Tom LaneDate: 2005-07-08 15:23:11
Subject: Re: pg_autovacuum: short, wide tables
Previous:From: Thanh Q LamDate: 2005-07-08 14:24:31
Subject: postgresSQL data directory

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