Re: [GENERAL] Recover PostgreSQL database folder data

Поиск
Список
Период
Сортировка
От Cat
Тема Re: [GENERAL] Recover PostgreSQL database folder data
Дата
Msg-id 20170422010546.lbnnet2vwbboqjvg@zip.com.au
обсуждение исходный текст
Ответ на Re: [GENERAL] Recover PostgreSQL database folder data  (Edson Lidorio <edson@openmailbox.org>)
Ответы Re: [GENERAL] Recover PostgreSQL database folder data
Список 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 по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: [GENERAL] Recover PostgreSQL database folder data
Следующее
От: Ian Harding
Дата:
Сообщение: Re: [GENERAL] pg_basebackup ----xlog-method=stream