On 09/04/2015 04:07 PM, clmartin@xxxxxxxxxxxxxxxx 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@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
