[GENERAL] How do I recover from>> pg_xlog/0000000000000000 (log file 0, segment 0) failed: No such file or directory

2004-10-19 Thread peter Willis
Hello, Is there a way to recover from the following error? I have (had) an existing database and wish not to lose the data tables. Thanks for any help, Pete [EMAIL PROTECTED] /]$ pg_ctl start postmaster successfully started [EMAIL PROTECTED] /]$ LOG: database system shutdown was interrupted at 20

Re: [GENERAL] How do I recover from>> pg_xlog/0000000000000000 (log file 0, segment 0) failed: No such file or directory

2004-10-19 Thread Tom Lane
peter Willis <[EMAIL PROTECTED]> writes: > [EMAIL PROTECTED] /]$ LOG: database system shutdown was interrupted at > 2004-10-18 11:41:55 PDT > LOG: open of /web2-disk1/grip/database/pg_xlog/ (log > file 0, segment 0) failed: No such file or directory > LOG: invalid primary check