Re: postgres disconnects on master after setting up replication

2021-08-17 Thread Andy Hall
yep we think this is exactly the issue...we have been testing a new build with a later driver in UAT this morning and no recurrence of the issue so looking most probable. thanks all for the very prompt and clear responses it's most appreciated. On Tue, 17 Aug 2021 at 13:09, Dave Cramer wrote: >

Re: postgres disconnects on master after setting up replication

2021-08-17 Thread Dave Cramer
Dave Cramer www.postgres.rocks On Mon, 16 Aug 2021 at 12:32, Andy Hall wrote: > thanks for the very clear explanation much appreciated shall take this > back to the team. > > On Mon, 16 Aug 2021 at 17:14, Tom Lane wrote: > > > > Andy Hall writes: > > > we have an odd issue where a java app

Re: postgres disconnects on master after setting up replication

2021-08-16 Thread Andy Hall
thanks for the very clear explanation much appreciated shall take this back to the team. On Mon, 16 Aug 2021 at 17:14, Tom Lane wrote: > > Andy Hall writes: > > we have an odd issue where a java app using JDBC which has been > > working fine has suddenly started disconnecting after we setup > >

Re: postgres disconnects on master after setting up replication

2021-08-16 Thread Tom Lane
Andy Hall writes: > we have an odd issue where a java app using JDBC which has been > working fine has suddenly started disconnecting after we setup > replication from the database it was connecting to ( which is now the > primary in a replicating pair ) with errors such as the following... >

postgres disconnects on master after setting up replication

2021-08-16 Thread Andy Hall
we have an odd issue where a java app using JDBC which has been working fine has suddenly started disconnecting after we setup replication from the database it was connecting to ( which is now the primary in a replicating pair ) with errors such as the following... CLIENT SIDE: