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
