Обсуждение: Multi client in subscription?
Hi everyone,
I have 2 virtual machines, one that i use at home and the other one that i use at work, so, in the server i have one publication and for each client i have the same subscription, but every time i go out from home to work, i have to stop postgresql service in order to use subscription at work, and viceversa, is it possible to use both at the same time ?
Thanks a lot!
xOCh
--
PAranoids Group
218
On 07/29/2018 11:53 PM, xOChilpili wrote: > Hi everyone, > > I have 2 virtual machines, one that i use at home and the other one that > i use at work, so, in the server i have one publication and for each > client i have the same subscription, but every time i go out from home > to work, i have to stop postgresql service in order to use subscription > at work, and viceversa, is it possible to use both at the same time ? This is going to need more information: 1) Not clear to me whether the server is one of the virtual machines or some other machine? 2) What is the publication definition? 3) How are the subscriptions set up? 4) Are the virtual machines on continuously? > > Thanks a lot! > > > -- > xOCh > > > -- > PAranoids Group > > 218 -- Adrian Klaver adrian.klaver@aklaver.com
On 30 July 2018 15:29:27 CEST, Adrian Klaver <adrian.klaver@aklaver.com> wrote: >On 07/29/2018 11:53 PM, xOChilpili wrote: >> Hi everyone, >> >> I have 2 virtual machines, one that i use at home and the other one >that >> i use at work, so, in the server i have one publication and for each >> client i have the same subscription, but every time i go out from >home >> to work, i have to stop postgresql service in order to use >subscription >> at work, and viceversa, is it possible to use both at the same time ? > Sounds like you are searching a multi-master solution. If yes, BDR. Regards, Andreas -- 2ndQuadrant - The PostgreSQL Support Company