Shawn Thomas <thomassd@xxxxxxxxxxxxxxxx> writes: > I’m thinking that at this point I need to approach this problem as more of a disaster recovery. There was a full pg_dumpall file that was deleted and cannot be recovered so I need to recover the data from the /var/lib/postgresql/9.4/main directory. I believe this is called a file level recovery. I assume I need to use a fully functional, same version PG (on another machine?) to create a full dump of the data directory. Once I have this I can re-install Postgres on the initial server and read the databases back into it. Seems like the hard way. Rename the data directory out of the way, delete and reinstall the Postgres packages, and once you've confirmed it works again, rename the data directory back into place (while the server is stopped!) If renaming the old data directory back into place makes it start failing again, then you've narrowed down the problem to something about the permissions or contents of the data directory itself or the configuration files therein. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
