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
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 |
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 |