Postgres Pro
Downloads
Home   >   mailing lists

Thread: Replication pull instead of push

Replication pull instead of push

From
PegoraroF10
Date:
We have several servers, our masters, installed on several cities. Then we
need have a centralized database (our standby) where we can do our reports.
So, usual way of doing postgres replication is creating a
replication/subscription process.
But then that master server should be reachable and sometimes it´s not, just
because their IP changed or because we need to configure its router to get
Postgres server properly.

Finally my question, there is a way to pull data which needs to be
replicated from master to slave.



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

Re: Replication pull instead of push

From
Fabrízio de Royes Mello
Date:

2018-03-07 16:01 GMT-03:00 PegoraroF10 <marcos@f10.com.br>:
>
> We have several servers, our masters, installed on several cities. Then we
> need have a centralized database (our standby) where we can do our reports.
> So, usual way of doing postgres replication is creating a
> replication/subscription process.

Ok.


> But then that master server should be reachable and sometimes it´s not, just
> because their IP changed or because we need to configure its router to get
> Postgres server properly.
>
> Finally my question, there is a way to pull data which needs to be
> replicated from master to slave.
>

The way is fix your network connection and if necessary change your subscription side do connect again in your server and continue pulling data.

If you don't drop your publication it will retain the WAL until the subscription connect again and pull data.

Regards,

--
   Fabrízio de Royes Mello         Timbira - http://www.timbira.com.br/
   PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento

Re: Replication pull instead of push

From
PegoraroF10
Date:
My question was ... how to pull data from Master into Slave. 
Postgres has a Publication/Subscription model that Slave connects to Master
and gets the data.
I want something that Master server gets its data which needs to be
replicated and send that data to Slave.

Is that way possible ?
If there is no extension or statement which does that, how can I do it
myself ?



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html