Thanks guys.
I didn't know about this command.
It worked like a charm.
Like I said, I had done a clean shutdown.
Thanks again.
On Jul 6, 2005, at 11:51 AM, Joshua D. Drake wrote:
Richard Doust wrote:
Hi.
Can anyone please tell me what I can do? I've lost the contents of
my pg_xlog directory and postmaster is failing to start because
it can't find a valid checkpoint record. It had done a clean
shutdown, so I know that the dbms should be okay if I could just
restart it.
I'm in a desparate situation. It's a production database.
Well the exact error would be good just in case but you may be able
to use pg_resetxlog to get the machine back up. However you will
have no
idea what state the database itself is in.
You need to restore from backup.
Sincerely,
Joshua D. Drake
Thanks in advance.
---------------------------(end of
broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to
majordomo@xxxxxxxxxxxxxx
--
Your PostgreSQL solutions company - Command Prompt, Inc.
1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/
