Richard Doust wrote:
Thanks guys.
I didn't know about this command.
It worked like a charm.
Like I said, I had done a clean shutdown.
If you did a clean shutdown and you lost those files you quite likely
have a very serious problem. You should investigate your hardware. Files
don't just "disappear".
Sincerely,
Joshua D. Drake
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/
--
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/
