From: | Ankur Kaushik <ankurkaushik(at)gmail(dot)com> |
---|---|
To: | John Scalia <jayknowsunix(at)gmail(dot)com> |
Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: pg_basebackup Error could not open directory |
Date: | 2015-10-24 04:57:05 |
Message-ID: | CALXoLqwYkvR=dkpezGn4Rq_su+MgOf2JtDfnKpOqYPhRwbPQgg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)gmail(dot)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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Magnus Hagander | 2015-10-24 11:51:45 | Re: pg_basebackup Error could not open directory |
Previous Message | John Scalia | 2015-10-24 03:04:02 | Re: pg_basebackup Error could not open directory |