Re: Recover PostgreSQL database folder data

From: Cat <cat(at)zip(dot)com(dot)au>
To: Edson Lidorio <edson(at)openmailbox(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Recover PostgreSQL database folder data
Date: 2017-04-22 01:05:46
Message-ID: 20170422010546.lbnnet2vwbboqjvg@zip.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ian Harding 2017-04-22 01:11:28 Re: pg_basebackup ----xlog-method=stream
Previous Message Adrian Klaver 2017-04-22 00:23:39 Re: Recover PostgreSQL database folder data