Lost pg_xlog pgclog

From: "Philip Geer" <philg(at)gearcc(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Lost pg_xlog pgclog
Date: 2003-03-25 14:34:23
Message-ID: 007701c2f2db$a2297220$9e51210a@administrator
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I had move my pgxlog and pgclog files to a drive of their own and that drive 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 that the server had on it but ever time I start postmaster I get the following error.

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) failed: No such file or directory
DEBUG: invalid primary checkpoint record
DEBUG: open of /pgdata/pg_xlog/0000000000000017 (log file 0, segment 23) failed: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2003-03-25 14:42:18 Re: Can't connect to my postgresql
Previous Message Brickley Jeff-RA9607 2003-03-25 14:11:07 unsubscribe