Postgres Pro
Downloads
Home   >   mailing lists

Re: Crashed DB and "base" folder files - Mailing list pgsql-general

From Richard Huxton
Subject Re: Crashed DB and "base" folder files
Date
Msg-id 46D3CCEF.4040309@archonet.com
Whole thread Raw
In response to Crashed DB and "base" folder files  ("Franck Roubieu - AXCENTEO" <froubieu@axcenteo.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: delete vs insert vs update due to primary key dups -> which is better
Next
From: Richard Huxton
Date:
Subject: Re: Windows Download