Re: Trouble setting up replication

On 09/04/2015 04:07 PM, clmartin@theombudsman.com wrote:
> I have been trying to set up "hot standby" replication, but have run
> into problems, and hope someone here can help.
>
> I have configured an ssh tunnel from a computer that is not on a public
> IP, and was unable to figure out how to run pg_basebackup from that
> server to backup the data from the main server, so I decided to run
> pb_basebackup on the main server and copy it later. So I did this:
>
> pg_basebackup -D /var/lib/pgsql/9.3/backups/rep/init -P -v -X s
>
> (after a number of other attempts), and got errors. First I got a
> permissions error, and found that the directory was owned by root
> instead of postgres. I changed that, but eventually I got this error:
>
> pg_basebackup: directory "/var/lib/pgsql/9.3/backups/rep" exists but is
> not empty

So what is in it?

>
> So my question is whether I can safely delete the directory and run
> pb_basebackup again?

Was that directory present before you ran pg_basebackup or did
pg_basebackup create it?

>
> I appreciate any help you can give. Let me know what additional
> information is needed to answer the question.
>
> Chuck
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com