Re: pg_basebackup Error could not open directory

Поиск
Список
Период
Сортировка
От Ankur Kaushik
Тема Re: pg_basebackup Error could not open directory
Дата
Msg-id CALXoLqwYkvR=dkpezGn4Rq_su+MgOf2JtDfnKpOqYPhRwbPQgg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pg_basebackup Error could not open directory  (John Scalia <jayknowsunix@gmail.com>)
Ответы Re: pg_basebackup Error could not open directory  (Magnus Hagander <magnus@hagander.net>)
Список pgsql-admin

I was looking the actual cause of this error as already given the permission to /tmp/backup

permission to /tmp/backup

drwx------  4 postgres postgres 4.0K Oct 24 10:10 backup

still giving error

As given below error
==================

pg_basebackup -P -v -D /tmp/backup/new1 -x -Ft -z -U base_backup_user -h 127.0.0.1
Password:
transaction log start point: 0/DF000060 on timeline 1
pg_basebackup: could not get backup header: ERROR:  could not open directory "./backup": Permission denied

===============

In the next step I found one more backup directory in location "/var/lib/pgsql/9.4/data" check its permission

drwx------  2 root     root     4.0K Oct 24 05:01 backup

 changed the permission as in location /va/lib/pgsql/9.4/data

chown -R postgres:postgres backup/

pg_basebackup works fine

Its strange to me   I am taking backup in location "/tmp/backup/new1"  but I have to check the permission of "/var/lib/pgsql/9.4/data/backup"

I am mysql guy and new to postgresql may be missed some basics of postgresql 

 

On Sat, Oct 24, 2015 at 8:34 AM, John Scalia <jayknowsunix@gmail.com> wrote:
Ankur,

This should be really easy to solve:

1) Who owns this backup directory
2) what is the mode of that directory, i.e., 555, 755, or what?

You could simply try "chmod 777 ./backup" and then reattempt your pg_basebackup command.
--
Jay

On 10/23/2015 8:56 PM, Ankur Kaushik wrote:
>
> User created as CREATE ROLE base_backup_user REPLICATION LOGIN PASSWORD 'backupuser';
>
>
> -bash-4.1$ pg_basebackup -h 127.0.0.1 -U base_backup_user -D "./pgbackup" -Ft -z -P
> pg_basebackup: could not get backup header: ERROR:  could not open directory "./backup": Permission denied
>
>
> Getting Below error while using pg_basebackup


В списке pgsql-admin по дате отправления:

Предыдущее
От: John Scalia
Дата:
Сообщение: Re: pg_basebackup Error could not open directory
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: pg_basebackup Error could not open directory