Re: Postgre cant start - Mailing list pgsql-bugs

From Olivier Bessière
Subject Re: Postgre cant start
Date
Msg-id 003401c894b9$22d871d0$68895570$@com
Whole thread Raw
In response to Re: Postgre cant start  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Hello,

Actually... You're command line just fully fixed my problem. Postmaster is
starting like he never got any problem.

Thank you so much for this helpful answer.

How can I thank you ? Are you traveling to France soon ?

Regards

/Olivier

-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: mardi 1 avril 2008 20:50
To: Olivier Bessière
Cc: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] Postgre cant start

Olivier Bessière <obessiere@boomerangpharma.com> writes:
> PostgreSQL V7.1

Egad.  You really, really, really need to update forthwith.
The list of bugs that have been fixed since 7.1 would curl your toes.
http://developer.postgresql.org/pgdocs/postgres/release.html

> FATAL 2:  cannot read block 1802 of pg_log: Success

This suggests that pg_log has been truncated.  Try something like
dd bs=8192 count=1 seek=1802 if=/dev/zero of=$PGDATA/global/1269

and try to start the postmaster.  If it then complains about a higher
block number, add that one in the same way, and repeat.

I don't have a whole lot of confidence that this will get you a
self-consistent database, but maybe you will be able to extract
some data.  Dump, compare against your last backup (you do have
one I trust), see what data you believe.

For heaven's sake, update!
        regards, tom lane


__________ Information from ESET NOD32 Antivirus, version of virus signature
database 2992 (20080401) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com


__________ Information from ESET NOD32 Antivirus, version of virus signature
database 2994 (20080402) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com



pgsql-bugs by date:

Previous
From: Pedro Gimeno
Date:
Subject: Re: BUG #4083: Return type of MAX and MIN of a VARCHAR column is TEXT
Next
From: Alvaro Herrera
Date:
Subject: Re: Re: BUG #4083: Return type of MAX and MIN of a VARCHAR column is TEXT