From: | Edson Lidorio <edson(at)openmailbox(dot)org> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Recover PostgreSQL database folder data |
Date: | 2017-04-21 16:40:50 |
Message-ID: | 565e390c-60b5-3156-8a37-941db6a0cc59@openmailbox.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2017-04-21 16:48:07 | Re: Recover PostgreSQL database folder data |
Previous Message | George Neuner | 2017-04-21 13:03:02 | Re: full text search on hstore or json with materialized view? |