From: Sébastien Beausoleil <sebastien@nubilogic.com>
To: pgsql-admin@postgresql.org
Subject: Database corrupted - PSQL 9.3 Ubuntu Server 14.04
Date: Thu, 15 Dec 2016 10:07:14 -0500
Message-ID: <b8f0d049-75b7-ef10-dfff-eebd17bc6ad1@nubilogic.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Hi,
I have a big problem with one of my Postgresql server.
I started a standard package update and during the Postgresql update,
something happen that it make it fails. Since when, postgresql isn't
able to start.
In the log, here is what it is showed:
2016-12-15 08:40:03 EST FATAL: "/var/lib/postgresql/9.3/main" is not a
valid data directory
2016-12-15 08:40:03 EST DETAIL: File
"/var/lib/postgresql/9.3/main/PG_VERSION" is missing.
And if I go further, there is a reccuring message:
2016-12-14 22:01:14 EST FATAL: could not open relation mapping file
"global/pg_filenode.map": No such file or directory
2016-12-14 22:01:15 EST ERROR: could not open file "base/305852/11848":
No such file or directory
2016-12-14 22:01:15 EST CONTEXT: writing block 0 of relation
base/305852/11848
2016-12-14 22:01:15 EST WARNING: could not write block 0 of
base/305852/11848
2016-12-14 22:01:15 EST DETAIL: Multiple failures --- write error might
be permanent.
I notice, when comparing with a similare server, that 3 db data in the
main/base folder are empty, I suppose it's the postgres, template0 et
template1 database.
I try pg_resetxlog on a copy of the data dir, the server came up but the
"postgres" user isn't a valide role...
I had a cron which make dump backup each day but there was un bug in the
script that make it right, so I know we should not rely on recovery, but
by now, It s really my only hope.
Could someone help me?
Sebastien
OS: Ubuntu Server 14.04 64bit
Postgresql: 9.3
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: sebastien@nubilogic.com
Subject: Re: Database corrupted - PSQL 9.3 Ubuntu Server 14.04
In-Reply-To: <b8f0d049-75b7-ef10-dfff-eebd17bc6ad1@nubilogic.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox