From: Lilian BENOIT <lbenoit@gmx.com>
To: pgsql-admin@postgresql.org
Subject: PostgreSQL don't start
Date: Fri, 09 Aug 2013 19:25:09 +0200
Message-ID: <20130809172509.51510@gmx.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Hi,
I have a problem with my postgresql instance. I don't start service.
My server had stopped abrupt because a fs was full . It have a only partition.
I think that a postgresql clog file is corrupt.
I used RPMs for install PostgreSQL with default repository
postgresql-8.4.13-1.el6_3.i686
postgresql-devel-8.4.13-1.el6_3.i686
postgresql-libs-8.4.13-1.el6_3.i686
postgresql-server-8.4.13-1.el6_3.i686
postgresql-contrib-8.4.13-1.el6_3.i686
My linux distro is CentOS 6.3
# uname -a
Linux servername 2.6.32-279.5.2.el6.i686
I don't modify postgresql.conf and pg_hba.conf
I don't launch PostgreSQL service.
# service postgresql start
Starting postgresql service: [FAILED]
No error in pgstartup.log
but i have a fatal error in log ($PG_DATA/log/postgresql-Thu.log)
LOG: database system was interrupted; last known up at 2013-08-08 23:50:36 BST
LOG: database system was not properly shut down; automatic recovery in progress
LOG: record with zero length at 0/1C000174
LOG: redo is not required
FATAL: could not access status of transaction 188140
DETAIL: Could not read from file "pg_clog/0000" at offset 40960: Success.
LOG: startup process (PID 2284) exited with exit code 1
LOG: aborting startup due to startup process failure
I try to create a new file clog without successfully
I try too to use pg_resetxlog without successfully too
how do i do for back the last transaction or checkpoint ?
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: lbenoit@gmx.com
Subject: Re: PostgreSQL don't start
In-Reply-To: <20130809172509.51510@gmx.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