Re: [GENERAL] Can't restart Postgres

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/maindirectory.  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-installPostgres 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.