Re: Desparate: Lost WAL files

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.
> Thanks in advance.

Have you tried pg_resetxlog to get it started?

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@xxxxxxxxxxxxxxxx               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux