Re: [GENERAL] Recover PostgreSQL database folder data - Mailing list pgsql-general

From Cat
Subject Re: [GENERAL] Recover PostgreSQL database folder data
Date
Msg-id 20170422010546.lbnnet2vwbboqjvg@zip.com.au
Whole thread Raw
In response to Re: [GENERAL] Recover PostgreSQL database folder data  (Edson Lidorio <edson@openmailbox.org>)
Responses Re: [GENERAL] Recover PostgreSQL database folder data  (Magnus Hagander <magnus@hagander.net>)
List pgsql-general
On Fri, Apr 21, 2017 at 08:20:38PM -0300, Edson Lidorio wrote:
> Ls -la /var/lib/pgsql/9.6/data
>
> drwx------. 20 postgres postgres  4096 Abr 21 17:52 .
> drwx------.  4 root     root        51 Abr 21 06:33 ..

Ensure that the user 'postgres' has permissions to get to
this dir from / up. This may either mean changing permissions
on some directories or changing ownership.

More than likely / /var /lib are a permissions thing (likely
need to be u+rwx,g+rx,o+rx) and /var/lib/pgsql/ and up is an
ownership thing (postgres:postgres) but this is not guaranteed
so take care.

--
  "A search of his car uncovered pornography, a homemade sex aid, women's
  stockings and a Jack Russell terrier."
    - http://www.dailytelegraph.com.au/news/wacky/indeed/story-e6frev20-1111118083480


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: [GENERAL] Recover PostgreSQL database folder data
Next
From: Ian Harding
Date:
Subject: Re: [GENERAL] pg_basebackup ----xlog-method=stream