PgAdmin 4.2 unable to connect to AWS Postgres read-replica instances

From: "Bawol, Brian" <brian(dot)bawol(at)freightverify(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: PgAdmin 4.2 unable to connect to AWS Postgres read-replica instances
Date: 2019-02-07 17:54:00
Message-ID: CAF56UXJbZqmpt4Cgcqz=yyEt_X9kfQTfN9ug_KNLEBDX+9z9hw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support pgsql-admin

My co-worker and I are both receiving the following error message when
attempting to connect to AWS Postgres 10.4 (and 10.6) database instances
using PgAdmin 4.2:

"ERROR: cannot execute SELECT in a read-only transaction"

I was previously able to connect to these instances until this morning when
I installed PgAdmin 4.2 (upgraded from 4.1.)

I uninstalled PgAdmin 4.2 and re-installed PgAdmin 4.1 and I'm now able to
connect to the read replica database instances again. The same goes for my
co-worker.

Steps to reproduce:

1. Open PgAdmin 4.2 from the Windows Program Menu
2. Select an existing server connection to a read-replica database
instance
3. Receive error "ERROR: cannot execute SELECT in a read-only
transaction"
4. Prompted to enter password with message "Please enter the password
for the user 'xxxxxx' to connect the server - "xxxxxx"
5. Enter the password and I still receive the error "ERROR: cannot
execute SELECT in a read-only transaction"

I've also tried re-creating the connection to the instance from scratch and
receive the same error. I've tried using our admin account as well as a
read-only account and both result in the same error message.

Info for version 4.1 (can connect):
Version 4.1
Python Version: 3.6.5 (v3.6.5:f59c0932b4, Mar 28 2018, 16:07:46) [MSC
v.1900 32 bit (Intel)]
Flask Version: 0.12.4
Application Mode: Desktop
Current User: pgadmin4(at)pgadmin(dot)org

Info for version 4.2 (can not connect):
Version 4.2
Python Version: 3.6.5 (v3.6.5:f59c0932b4, Mar 28 2018, 16:07:46) [MSC
v.1900 32 bit (Intel)]
Flask Version: 0.12.4
Application Mode: Desktop
Current User: pgadmin4(at)pgadmin(dot)org

Thanks,
Brian

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Tom Lane 2019-02-07 18:47:48 Re: PgAdmin 4.2 unable to connect to AWS Postgres read-replica instances
Previous Message Robert J. Rotter 2019-02-07 15:54:19 Cannot connect to Replication Slave with the new Version 4.2 of PGAdmin4

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2019-02-07 18:47:48 Re: PgAdmin 4.2 unable to connect to AWS Postgres read-replica instances
Previous Message Pepe TD Vo 2019-02-06 19:59:07 Re: insert aborted commands ignored