Trouble setting up replication

From: clmartin(at)theombudsman(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: Trouble setting up replication
Date: 2015-09-04 23:07:02
Message-ID: 5674749ff36511f41b93482fb24d6d1f@theombudsman.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 my question is whether I can safely delete the directory and run
pb_basebackup again?

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

Chuck

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Steele 2015-09-05 12:32:10 Re: error on online backup using pg_basebackup tool
Previous Message Ben Chobot 2015-09-04 22:37:47 in defensive of zone_reclaim_mode on linux