From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | Shawn Thomas <thomassd(at)u(dot)washington(dot)edu>, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
Cc: | Magnus Hagander <magnus(at)hagander(dot)net>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Can't restart Postgres |
Date: | 2017-02-15 16:49:48 |
Message-ID: | 2d1eef24-5ae2-aa09-17b1-88849d611168@commandprompt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2017-02-15 17:01:36 | Re: Can't restart Postgres |
Previous Message | Shawn Thomas | 2017-02-15 16:35:10 | Re: Can't restart Postgres |