Recover data from postgres files

[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

[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.