Re: [PERFORM] Sort-of replication for reporting purposes

2017-01-13 Thread Phillip Couto
Why not utilize the pglogical plugin from 2ndQuadrant? They demonstrate your use case on the webpage for it and it is free. Phill

Re: [PERFORM] Sort-of replication for reporting purposes

2017-01-13 Thread Stuart Bishop
On 13 January 2017 at 18:17, Ivan Voras wrote: > On 13 January 2017 at 12:00, Stuart Bishop > wrote: > >> >> >> On 7 January 2017 at 02:33, Ivan Voras wrote: >> >>> >>> >>> >>> I forgot to add one more information, the databases are 50G+ each so >>> doing the base backup on demand over the netw

Re: [PERFORM] Sort-of replication for reporting purposes

2017-01-13 Thread Ivan Voras
On 13 January 2017 at 12:00, Stuart Bishop wrote: > > > On 7 January 2017 at 02:33, Ivan Voras wrote: > >> >> >> >> I forgot to add one more information, the databases are 50G+ each so >> doing the base backup on demand over the network is not a great option. >> > > If you don't want to rebuild

Re: [PERFORM] Sort-of replication for reporting purposes

2017-01-13 Thread Stuart Bishop
On 7 January 2017 at 02:33, Ivan Voras wrote: > > > On 6 Jan 2017 8:30 p.m., "Scott Marlowe" wrote: > > On Fri, Jan 6, 2017 at 12:24 PM, Ivan Voras wrote: > > Hello, > > > > I'm investigating options for an environment which has about a dozen > servers > > and several dozen databases on each, a