| From: | Andy Hall <andyjohnhall(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | postgres disconnects on master after setting up replication |
| Date: | 2021-08-16 15:32:30 |
| Message-ID: | CAOp5WB4B_BcDxX2cm0jfGoRP6oGcg_Gv_TNA1C+wFWHvRgmr3g@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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: DBNAME/logs/20210815-200601.20966.log:SessionManagerImpl
WARN 20210816-00:01:00.252 - A session lost connection with the
database. Disabling all sessions
SERVER SIDE: 2021-08-16 01:48:27 BST FATAL: unsupported frontend
protocol 1234.5680: server supports 1.0 to 3.0
( these are different times but you get the idea )
I appreciate this seems like a JDBC driver issue but everything has
been fine and we observe the errors only once we setup replication.
could there be some issue with streaming / WAL replication that could
be causing this ? we are running 9.6 by the way thanks.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2021-08-16 16:14:37 | Re: postgres disconnects on master after setting up replication |
| Previous Message | Mladen Gogala | 2021-08-16 14:39:34 | Re: Cluster fencing tool/software for PostgreSQL cluster with streaming replication |