Обсуждение: Replication pull instead of push
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
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.
> 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
Regards,
--
Fabrízio de Royes Mello Timbira - http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento
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