On Fri, Apr 21, 2017 at 12:40 PM, Edson Lidorio <ed...@openmailbox.org> wrote:
> 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; > Your error is that you didn't 'chown *-R* postgres:postgres /var/lib/pgsql/9.6/data' --Scott > 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@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- -- Scott Mead Sr. Architect *OpenSCG <http://openscg.com>* http://openscg.com
