[GENERAL] Recover PostgreSQL database folder data
От | Edson Lidorio |
---|---|
Тема | [GENERAL] Recover PostgreSQL database folder data |
Дата | |
Msg-id | 565e390c-60b5-3156-8a37-941db6a0cc59@openmailbox.org обсуждение исходный текст |
Ответы |
Re: [GENERAL] Recover PostgreSQL database folder data
Re: [GENERAL] Recover PostgreSQL database folder data Re: [GENERAL] Recover PostgreSQL database folder data |
Список | pgsql-general |
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.
В списке pgsql-general по дате отправления: