Search Postgresql Archives

Trouble setting up replication

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux