Thread: Crashed DB and "base" folder files

Crashed DB and "base" folder files

From
"Franck Roubieu - AXCENTEO"
Date:

Hello,

My DB crashed without any recent backup.

I have old DB files.

Can i use “base” folder files to restore ?

Thanks
 

Franck R.

 

 

 

Re: Crashed DB and "base" folder files

From
Richard Huxton
Date:
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