Re: Recover PostgreSQL database folder data

On 04/21/2017 01:36 PM, Edson Lidorio wrote:
>
>
> On 21-04-2017 17:27, Scott Mead wrote:
>> chown *-R* postgres:postgres /var/lib/pgsql/9.6/data
>
> Chown -R postgres: postgres /var/lib/pgsql/9.6/data
> Sudo systemctl start postgresql-9.6

Is this on the first VM you showed previously or the new one you said
you where going to create?

>
> Erros:
>
> Unit postgresql-9.6.service entered failed state.
> Abr 21 07:50:11 localhost.localdomain systemd[1]: postgresql-9.6.service
> failed.
> Abr 21 07:50:11 localhost.localdomain polkitd[693]: Unregistered
> Authentication Agent for unix-process:30276:3843896 (system bus name
> :1.486, object p
> lines 2341-2377/2377 (END)
>
>
> /var/lib/pgsql/9.6/data/" is missing or empty.

Is it empty, because before it was not?

> Apr 21 07:50:11 localhost postgresql96-check-db-dir: Use
> "/usr/pgsql-9.6/bin/postgresql96-setup initdb" to initialize the
> database cluster.
> Apr 21 07:50:11 localhost postgresql96-check-db-dir: See
> /usr/share/doc/postgresql96/README.rpm-dist for more information.
> Apr 21 07:50:11 localhost systemd: postgresql-9.6.service: control
> process exited, code=exited status=1
> Apr 21 07:50:11 localhost systemd: Failed to start PostgreSQL 9.6
> database server.
> Apr 21 07:50:11 localhost systemd: Unit postgresql-9.6.service entered
> failed state.
> Apr 21 07:50:11 localhost systemd: postgresql-9.6.service failed.
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com