Search Postgresql Archives

Recover PostgreSQL database folder data

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

 



Hi,
There was a disaster in my development note. I was able to recover the data folder. PostgreSQL 9.6.2, was installed in Centos 7.

Here are the procedures I'm trying to initialize Postgresql for me to do a backup.

1- I installed PostgreSQL 9.6.2 on a VM with Centos 7.
2- I stopped the PostgreSQL service: sudo systemctl stop postgresql-9.6
3- I renamed the /var/lib/pgsql/9.6/data folder to date data_old and copied the old date folder
4- I gave permission in the folder date:
     sudo chown postgres: postgres /var/lib/pgsql/9.6/data;
     sudo chmod 700 /var/lib/pgsql/9.6/data
5 - I tried to start the service: sudo systemctl start postgresql-9.6
It is generating the following errors:

Abr 21 01:25:35 localhost.localdomain systemd[1]: Starting PostgreSQL 9.6 database server... Abr 21 01:25:36 localhost.localdomain postgresql96-check-db-dir[19996]: cat: /var/lib/pgsql/9.6/data//PG_VER…ada Abr 21 01:25:36 localhost.localdomain postgresql96-check-db-dir[19996]: cat: /var/lib/pgsql/9.6/data//PG_VER…ada Abr 21 01:25:36 localhost.localdomain systemd[1]: postgresql-9.6.service: control process exited, code=ex...us=1 Abr 21 01:25:36 localhost.localdomain systemd[1]: Failed to start PostgreSQL 9.6 database server. Abr 21 01:25:36 localhost.localdomain systemd[1]: Unit postgresql-9.6.service entered failed state. Abr 21 01:25:36 localhost.localdomain systemd[1]: postgresql-9.6.service failed.
Hint: Some lines were ellipsized, use -l to show in full.



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