Re: BUG #15785: create slave through archive log replication

Em qui, 2 de mai de 2019 às 06:33, ram pratap maurya
<rampratap0000@gmail.com> escreveu:
>
> Master and 1slave is smae host and location and 2slave (i am createg 2nd slave for DR purpose) is another location.
> when we replicating 2nd slave it replicate via streeming replication (pg_wal) . i want 2nd salve replicate through
pg_log_archive.
> please suggest.
>
Why don't you want to use streaming for 2nd slave?

If you want to replicate to 2nd slave applying WAL files, remove
primary_conninfo and add restore_command such as:

restore_command = 'scp
postgres@myhost:/var/lib/pgsql/11/data/pg_log_archive/%f %p'

or modify archive_command in the master to archive in the 2nd slave as
well. In this case, restore command will be a simple cp:

restore_command = 'cp /path/to/archives/%f %p'

> in your reply myhost is a master ip?.
>
Yes.


--
   Euler Taveira                                   Timbira -
http://www.timbira.com.br/
   PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento