Page 1 of 1

Recover data from postgres files

PostPosted: Sat Aug 03, 2013 10:34 am
by agentreno
Hello all

Has anyone had experience recovering a postgres database from the data folder? Google turned up a few hits which suggest installing the same version that created the data, stepping the service, replacing the data folder with the backed up folder, and restarting the service. That didn't work out for me as the service won't restart once I've altered it's filesystem.

Would be grateful to hear from anyone who has attempted something like this, you can bet ill be using pgdump or PT db export features from now on!

Karl

Re: Recover data from postgres files

PostPosted: Sat Aug 03, 2013 12:20 pm
by WhiteRider
I believe you'll need to install PostgreSQL after you copy the data folder into place, rather than before, but as long as the whole data folder is intact that should work.