Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M41496=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1V7qRB-0008Ia-FN
 for pgsql-admin@arkaria.postgresql.org; Fri, 09 Aug 2013 17:25:17 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M41496=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1V7qRA-0005Ym-Rc
 for pgsql-admin@arkaria.postgresql.org; Fri, 09 Aug 2013 17:25:16 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <lbenoit@gmx.com>) id 1V7qR8-0005VG-O6
 for pgsql-admin@postgresql.org; Fri, 09 Aug 2013 17:25:14 +0000
Received: from mout.gmx.net ([212.227.15.15])
 by magus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <lbenoit@gmx.com>) id 1V7qR6-0007M9-97
 for pgsql-admin@postgresql.org; Fri, 09 Aug 2013 17:25:14 +0000
Received: from mailout-eu.gmx.com ([10.1.101.215]) by mrigmx.server.lan
 (mrigmx001) with ESMTP (Nemesis) id 0LyPqS-1WBTbF2tLK-015n3l for
 <pgsql-admin@postgresql.org>; Fri, 09 Aug 2013 19:25:11 +0200
Received: (qmail 16206 invoked by uid 0); 9 Aug 2013 17:25:11 -0000
Received: from 83.206.36.129 by rms-eu002 with HTTP
Content-Type: multipart/alternative;
 boundary="========GMXBoundary51511376069109486535"
Date: Fri, 09 Aug 2013 19:25:09 +0200
From: "Lilian BENOIT" <lbenoit@gmx.com>
Message-ID: <20130809172509.51510@gmx.com>
MIME-Version: 1.0
Subject: PostgreSQL don't start
To: pgsql-admin@postgresql.org
X-Flags: 0001
X-Mailer: GMX.com Web Mailer
x-registered: 0
X-GMX-UID: okB3cnt1eSEqK2PrE34hXE1+IGRvbwDs
X-Pg-Spam-Score: -1.9 (-)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

--========GMXBoundary51511376069109486535
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: 8bit

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 ?

--========GMXBoundary51511376069109486535
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: quoted-printable

<span style=3D'font-family:Verdana'><span style=3D'font-size:12px'>Hi,<br /=
><br />I have a problem with my postgresql instance. I don't start service.=
<br />My server had stopped abrupt because a fs was full . It have a only p=
artition.<br />I think that a postgresql clog file is corrupt.<br /><br />I=
 used RPMs for install PostgreSQL with default repository<br />postgresql-8=
.4.13-1.el6_3.i686<br />postgresql-devel-8.4.13-1.el6_3.i686<br />postgresq=
l-libs-8.4.13-1.el6_3.i686<br />postgresql-server-8.4.13-1.el6_3.i686<br />=
postgresql-contrib-8.4.13-1.el6_3.i686<br /><br />My linux distro is CentOS=
 6.3<br /># uname -a<br />Linux servername 2.6.32-279.5.2.el6.i686<br /><br=
 />I don't modify postgresql.conf and pg_hba.conf<br /><br />I don't launch=
 PostgreSQL service.<br /># service postgresql start<br />Starting postgres=
ql service:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [FAILED]<br /><br />No error in p=
gstartup.log<br />but i have a fatal error in log ($PG_DATA/log/postgresql-=
Thu.log)<br />LOG:&nbsp; database system was interrupted; last known up at =
2013-08-08 23:50:36 BST<br />LOG:&nbsp; database system was not properly sh=
ut down; automatic recovery in progress<br />LOG:&nbsp; record with zero le=
ngth at 0/1C000174<br />LOG:&nbsp; redo is not required<br />FATAL:&nbsp; c=
ould not access status of transaction 188140<br />DETAIL:&nbsp; Could not r=
ead from file "pg_clog/0000" at offset 40960: Success.<br />LOG:&nbsp; star=
tup process (PID 2284) exited with exit code 1<br />LOG:&nbsp; aborting sta=
rtup due to startup process failure<br /><br />I try to create a new file c=
log without successfully<br />I try too to use pg_resetxlog without success=
fully too<br />how do i do for back the last transaction or checkpoint ?<br=
 />=C2=A0</span></span>

--========GMXBoundary51511376069109486535--