Re: [GENERAL] Recover PostgreSQL database folder data - Mailing list pgsql-general

From Edson Lidorio
Subject Re: [GENERAL] Recover PostgreSQL database folder data
Date
Msg-id d0778e9f-bd65-ae45-8554-6acfa06797a1@openmailbox.org
Whole thread Raw
In response to Re: [GENERAL] Recover PostgreSQL database folder data  (Scott Mead <scottm@openscg.com>)
Responses Re: [GENERAL] Recover PostgreSQL database folder data  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general



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

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.
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.


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: [GENERAL] Recover PostgreSQL database folder data
Next
From: Andrew Staller
Date:
Subject: Re: [GENERAL] Large data and slow queries