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@[EMAIL PROTECTED]
mardi 1 avril 2008 20:50
To: Olivier Bessi=E8re
Cc: pgsql-bugs@[EMAIL PROTECTED]
Re: [BUGS] Postgre cant start=20
=3D?iso-8859-1?Q?Olivier_Bessi=3DE8re?=3D <obessiere@[EMAIL PROTECTED]
>
w=
rites:
> 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=3D8192 count=3D1 seek=3D1802 if=3D/dev/zero
of=3D$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
=20
__________ Information from ESET NOD32 Antivirus, version of virus
signature
database 2994 (20080402) __________
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
=20
--=20
Sent via pgsql-bugs mailing list (pgsql-bugs@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
|
