Recover data from postgres files
Posted: Sat Aug 03, 2013 10:34 am
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
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