Re: pg_basebackup Error could not open directory

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
>
>

In response to

Responses

Browse pgsql-admin by date

  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