[ADMIN] Lost pg_xlog pgclog
Philip Geer
------=_NextPart_000_0074_01C2F2B1.B894AE00
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I had move my pgxlog and pgclog files to a drive of their own and that driv=
e crashed with no chance of data recovery. This is not a production server =
so its not that big of a deal but I would like to recover the databases tha=
t the server had on it but ever time I start postmaster I get the following=
error.=20
DEBUG: database system was interrupted at 2003-02-14 00:15:56 EST
DEBUG: open of /pgdata/pg_xlog/0000000000000017 (log file 0, segment 23) f=
ailed: No such file or directory
DEBUG: invalid primary checkpoint record
DEBUG: open of /pgdata/pg_xlog/0000000000000017 (log file 0, segment 23) f=
ailed: No such file or directory
DEBUG: invalid secondary checkpoint record
FATAL 2: unable to locate a valid checkpoint record
DEBUG: startup process (pid 29291) exited with exit code 2
DEBUG: aborting startup due to startup process failure
Can I recover from this error or no?
Thanks
Philip Geer
Internet Specialist
Janus Hotels and Resorts
Phone: (616) 363-9001 ext 7804
Cell: (616) 835-2723
Fax (616) 363-0670
------=_NextPart_000_0074_01C2F2B1.B894AE00
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.3502.5390" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>I had move my pgxlog and pgclog files to a=
drive of=20
their own and that drive crashed with no chance of data recovery. This is n=
ot a=20
production server so its not that big of a deal but I would like to recover=
the=20
databases that the server had on it but ever time I start postmaster I get =
the=20
following error. </FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>DEBUG: database system was interrupt=
ed at=20
2003-02-14 00:15:56 EST<BR>DEBUG: open of /pgdata/pg_xlog/00000000000=
00017=20
(log file 0, segment 23) failed: No such file or directory<BR>DEBUG: =
=20
invalid primary checkpoint record<BR>DEBUG: open of=20
/pgdata/pg_xlog/0000000000000017 (log file 0, segment 23) failed: No such f=
ile=20
or directory<BR>DEBUG: invalid secondary checkpoint record<BR>FATAL=
=20
2: unable to locate a valid checkpoint record<BR>DEBUG: startup=
=20
process (pid 29291) exited with exit code 2<BR>DEBUG: aborting startu=
p due=20
to startup process failure<BR></FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Can I recover from this error or no?</FONT=
></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Thanks</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Philip Geer<BR>Internet Specialist<BR>Janu=
s Hotels=20
and Resorts<BR>Phone: (616) 363-9001 ext 7804<BR>Cell: (616)=20
835-2723<BR>Fax (616) 363-0670<BR></FONT></DIV></BODY></HTML>
------=_NextPart_000_0074_01C2F2B1.B894AE00--
Tom Lane
> I had move my pgxlog and pgclog files to a drive of their own and that driv=
> e crashed with no chance of data recovery. This is not a production server =
> so its not that big of a deal but I would like to recover the databases tha=
> t the server had on it but ever time I start postmaster I get the following=
> error.=20
You could try running pg_resetxlog (see contrib if pre-7.3; in 7.3 it's
standard). That should let you start the database, but keep in mind
that any transactions completed shortly before the crash might be
missing or partially applied. Don't trust the data too much until
you've checked it. And definitely do a dump and reload...
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster