Re: 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