Setting up replication

On 03/17/2015 04:08 PM, Robert Fitzpatrick wrote:

I have a question about setting up replication between my
postgresql-9.3.6 servers. If I'm using pg_basebackup on my FreeBSD 10.1
slave server, the postgresql.conf file is in the data directory, which
pg_basebackup insists must be empty. I can't find any info about how to
relocate the postgresql.conf file and tell the init script its new
location. If I setup PITR prior to replication setup and share the same
postgresql.conf file transferred by pg_basebackup, how can both servers
see the archive directory? It is local for the slave, nfs mount for the
master.

Obviously there is something I'm missing or not understanding, can
anyone help? Thanks!

A step by step on what you are doing would help.

In the meantime:

1) You should not have to initdb the standby, that is handled by
pg_basebackup copying over the binary files.

2) The archive directory in the standby is pointed to in recovery.conf:
http://www.postgresql.org/docs/9.3/static/recovery-config.html

A simple one can be set by pg_basebackup:

http://www.postgresql.org/docs/9.3/interactive/app-pgbasebackup.html

-R
--write-recovery-conf

Write a minimal recovery.conf in the output directory (or into the
base archive file when using tar format) to ease setting up a standby
server.

--
Adrian Klaver
adrian.klaver@aklaver.com

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