On 6 March 2019 06:26:45 CET, Julie Nishimura <juliezain@xxxxxxxxxxx> wrote: >Thank you. Are you going to have any presentations on Postgresql >conference in NYC soon? > >________________________________ >From: Andreas Kretschmer <andreas@xxxxxxxxxxxxxxx> >Sent: Tuesday, March 5, 2019 9:16 PM >To: pgsql-general@xxxxxxxxxxxxxxxxxxxx >Subject: Re: write on standby > > > >Am 06.03.19 um 00:34 schrieb Julie Nishimura: >> Hello there, >> Is it possible for a test app to connect to the standby dB of an >> active-Standby dB pair? > >that's possible, but ... > > >> While both continue to be connected and replicating? What if it’s >> needed to write tmp tables that are later dropped? > >... that's not. Not with streaming replication, but ... > > >> Can it be done in hot standby scenario on standby? Version is 9.6.2 >> > >... it would be possible with logical replication (trigger based >solutions like slony or lindiste or logical replication using pglogical >from us, 2ndQ). > >https://www.2ndquadrant.com/en/resources/pglogical/ > > >You can also use BDR2 with PG9.6, but this is only available for our >customers. > > >Regards, Andreas > >-- >2ndQuadrant - The PostgreSQL Support Company. >www.2ndQuadrant.com<http://www.2ndQuadrant.com> Hi, I think so, if you want i can organize a contact with someone from our company. Andreas (from germany) -- 2ndQuadrant - The PostgreSQL Support Company
