[GENERAL] Recover PostgreSQL database folder data

2017-04-21 Thread Edson Lidorio
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

Re: [GENERAL] Recover PostgreSQL database folder data

2017-04-21 Thread Edson Lidorio
On 21-04-2017 13:48, Adrian Klaver wrote: On 04/21/2017 09:40 AM, Edson Lidorio 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

Re: [GENERAL] Recover PostgreSQL database folder data

2017-04-22 Thread Edson Lidorio
On 22-04-2017 06:40, Magnus Hagander wrote: On Sat, Apr 22, 2017 at 3:05 AM, Cat <c...@zip.com.au <mailto:c...@zip.com.au>> wrote: On Fri, Apr 21, 2017 at 08:20:38PM -0300, Edson Lidorio wrote: > Ls -la /var/lib/pgsql/9.6/data > > drwx--. 20 postgr

Re: [GENERAL] Recover PostgreSQL database folder data

2017-04-21 Thread Edson Lidorio
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

Re: [GENERAL] Recover PostgreSQL database folder data

2017-04-21 Thread Edson Lidorio
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 Erros: Unit postgresql-9.6.service entered failed state. Abr 21 07:50:11 localhost.localdomain systemd[1]:

Re: [GENERAL] Recover PostgreSQL database folder data

2017-04-21 Thread Edson Lidorio
On 21-04-2017 16:00, Adrian Klaver wrote: Is that really the case? Yes, I have already given permission on this folder and it does not initialize. I'll try to make another copy in another vm. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] Recover PostgreSQL database folder data

2017-04-21 Thread Edson Lidorio
On 21-04-2017 18:02, Adrian Klaver wrote: Chown -R postgres: postgres /var/lib/pgsql/9.6/data After the command, I have the errors: Apr 21 18:11:41 localhost postgresql96-check-db-dir: "/var/lib/pgsql/9.6/data/" is missing or empty. Apr 21 18:11:41 localhost postgresql96-check-db-dir: Use

Re: [GENERAL] Recover PostgreSQL database folder data

2017-04-21 Thread Edson Lidorio
On 21-04-2017 20:55, Adrian Klaver wrote: On 04/21/2017 04:20 PM, Edson Lidorio wrote: On 21-04-2017 18:13, Edson Lidorio wrote: What does the directory listing for /var/lib/pgsql/9.6/data show? [root@localhost data]# pwd /var/lib/pgsql/9.6/data Ls -la /var/lib/pgsql/9.6/data drwx

Re: [GENERAL] Recover PostgreSQL database folder data

2017-04-21 Thread Edson Lidorio
On 21-04-2017 18:13, Edson Lidorio wrote: On 21-04-2017 18:02, Adrian Klaver wrote: Chown -R postgres: postgres /var/lib/pgsql/9.6/data After the command, I have the errors: Apr 21 18:11:41 localhost postgresql96-check-db-dir: "/var/lib/pgsql/9.6/data/" is missing or empty. Ap