Re: DB & Log Files removed...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Lynn(dot)Tilby(at)asu(dot)edu
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>, ltilby(at)asu(dot)edu
Subject: Re: DB & Log Files removed...
Date: 2003-12-19 20:36:33
Message-ID: 11638.1071866193@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Lynn(dot)Tilby(at)asu(dot)edu writes:
> Where is the postmaster getting the 'logfile 6 seg 134' from?

Those are your missing pg_xlog files. I'd suggest running pg_resetxlog
(not standard in 7.1, but I believe it exists as a contrib item). Won't
get you out of the one lost database, but at least you'll be able to
start the postmaster.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-12-19 20:42:18 Re: Tables referencing each other
Previous Message Michael Meskes 2003-12-19 20:18:29 Re: 7.1.3 ecpg answered BUT...