pg_basebackup failed to read a file - Mailing list pgsql-general

From Mike Cardwell
Subject pg_basebackup failed to read a file
Date
Msg-id 1534256304.6834.4.camel@hardenize.com
Whole thread Raw
Responses Re: pg_basebackup failed to read a file
List pgsql-general
Hi,

I was just setting up streaming replication for the first time. I ran
pg_basebackup on the slave. It copied 1.5TB of data. Then it errored
out with:

```
1498215035/1498215035 kB (100%), 1/1 tablespace
pg_basebackup: could not get write-ahead log end position from server:
ERROR:  could not open file "./postgresql.conf~": Permission denied
pg_basebackup: removing data directory "/var/lib/pgsql/10/data"
bash-4.2$
```

Now, I know what this error means. There was a root owned file at
"/var/lib/pgsql/10/data/postgresql.conf~" which contained an old
version of our postgres config and was not readable by the postgres
user. I'll delete this file and try again. However, in the mean time: I
feel like it would be useful for pg_basebackup to check that it has
read access to all of the existing files in the source directory at the
start, before it begins it's copy. I'd like to submit this as a feature
request, but I'm struggling to find how to do that. So here I am... Can
anyone point me in the right direction?

Regards,

Mike
Attachment

pgsql-general by date:

Previous
From: Don Seiler
Date:
Subject: Re: Vacuum process waiting on BufferPin
Next
From: "David G. Johnston"
Date:
Subject: Re: Copying data from a CSV file into a table dynamically