pg 8.3 windows, DB curruption, out of space

From: <maksim(dot)likharev(at)thomsonreuters(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: pg 8.3 windows, DB curruption, out of space
Date: 2010-04-22 05:44:02
Message-ID: 1279302B0EF43D4B8F7F548BA2A21F2602F2BE27@TSHUSMNNADMBX02.ERF.THOMSON.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

Having very difficult decision to make, data drive ran out of space,
startup recovery says:

- LOG: 58P01: could not open file
"pg_xlog/00000001000000A500000016" (log file 165, segment 22): No such
file or directory

-

last one is: 00000001000000A500000015

what is my options, pg_resetxlog?

Thanks.

Browse pgsql-general by date

  From Date Subject
Next Message Philippe Lang 2010-04-22 06:04:21 Re: Avoiding surrogate keys
Previous Message Devrim GÜNDÜZ 2010-04-22 02:05:14 Re: Error installing postgresql version higher than 8.1 on centos 5.4 linux 2.6.18-164.el5