On 02/15/2017 08:35 AM, Shawn Thomas wrote:
Yes, that’s the correct sequence of scripts. And no there’s not anything
really helpful in the system logs.
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.
Any advice on how to best go about this? The official documentation seems a
bit thin:
https://www.postgresql.org/docs/9.4/static/backup-file.html
I’ve only worked with normal (pg_dump, pg_dumpall) backups in the past.
Shawn
As the postgres user:
/usr/lib/postgresql/9.4/bin/pg_ctl -D /var/lib/postgresql/9.4/main start
What returns?
Sincerely,
JD
--
Command Prompt, Inc. http://the.postgres.company/
+1-503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Everyone appreciates your honesty, until you are honest with them.
Unless otherwise stated, opinions are my own.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
