Re: Recover PostgreSQL database folder data

From: Edson Lidorio <edson(at)openmailbox(dot)org>
To: Scott Mead <scottm(at)openscg(dot)com>
Cc: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Recover PostgreSQL database folder data
Date: 2017-04-21 20:36:18
Message-ID: d0778e9f-bd65-ae45-8554-6acfa06797a1@openmailbox.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Staller 2017-04-21 20:41:25 Re: Large data and slow queries
Previous Message Adrian Klaver 2017-04-21 20:34:27 Re: Recover PostgreSQL database folder data