Re: Crashed DB and "base" folder files

From: Richard Huxton <dev(at)archonet(dot)com>
To: froubieu(at)axcenteo(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Crashed DB and "base" folder files
Date: 2007-08-28 07:21:19
Message-ID: 46D3CCEF.4040309@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Franck Roubieu - AXCENTEO wrote:
> Hello,
>
> My DB crashed without any recent backup.

What happened to cause it to crash?

> I have old DB files.
>
> Can i use "base" folder files to restore ?

Yes, but it's only reliable if the file-backup was taken while the
database wasn't running.

I'm assuming PG won't restart with the current files? What do the logs show?

--
Richard Huxton
Archonet Ltd

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2007-08-28 07:26:11 Re: Windows Download
Previous Message Richard Huxton 2007-08-28 07:19:17 Re: delete vs insert vs update due to primary key dups -> which is better