Обсуждение: [BUGS] error- how to solve-reg
sir ,
while starting postgressql 8.3 it shows an FAITAL error,can u please help to solve the error FATAL: incorrect checksum in control file.
--
Thanks & Regards
RINTO R JOHN
RINTO R JOHN
rinto r john <rintotkml@gmail.com> writes: > while starting postgressql 8.3 it shows an FAITAL error,can u please help > to solve the error > error shown as below. > FATAL: incorrect checksum in control file. This isn't a bug (or at least you've not provided any evidence that it is), so pgsql-general or pgsql-admin would be a more appropriate forum. Before anyone can offer really useful advice, we'd need to know: * how'd you get into this situation? Something bad must have happened, perhaps a power failure or O/S crash ... do you know what? * What platform is this on? And which 8.3.x PG release exactly? (I'll refrain from lecturing you about running out-of-support releases, but you are ...) * Is pg_controldata able to print anything useful from the control file? What does it show exactly? Your basic alternatives for getting out of this situation are going to be (1) re-initdb and restore from your last backup, or (2) apply pg_resetxlog and then try to pick up the pieces. Neither one of these is particularly appealing, especially if you haven't got a recent backup. Without answers to the questions above, it's hard to say what your prospects of success with (2) are. In any case I'd recommend making a physical copy (e.g. tar or zip backup) of your whole $PGDATA directory tree before you start, so you can at least get back to where you are if things go wrong. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs