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: | 42CE99F8.2010307@archonet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
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
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-07-08 15:23:11 | Re: pg_autovacuum: short, wide tables |
Previous Message | Thanh Q Lam | 2005-07-08 14:24:31 | postgresSQL data directory |