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
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 |