| 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: | Whole Thread | Raw Message | 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
| 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 |