Search Postgresql Archives

Re: Recover PostgreSQL database folder data

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 04/21/2017 01:53 PM, Edson Lidorio wrote:


On 21-04-2017 17:43, Adrian Klaver wrote:
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.




In the new

So why not try:

chown -R postgres:postgres /var/lib/pgsql/9.6/data

on the previous system. Not sure if is was a transcribing error, but in your previous post you had:

Chown -R postgres: postgres /var/lib/pgsql/9.6/data

which would not work.


Is it empty, because before it was not?
It's strange the date folder, old is there with the data!

Just to be clear we are talking about the data/ directory.

Could we see the listings for data/ data_old?




--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux