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

Поиск
Список
Период
Сортировка
От Bawol, Brian
Тема PgAdmin 4.2 unable to connect to AWS Postgres read-replica instances
Дата
Msg-id CAF56UXJbZqmpt4Cgcqz=yyEt_X9kfQTfN9ug_KNLEBDX+9z9hw@mail.gmail.com
обсуждение исходный текст
Ответы Re: PgAdmin 4.2 unable to connect to AWS Postgres read-replica instances  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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@pgadmin.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@pgadmin.org

Thanks,
Brian


В списке pgsql-admin по дате отправления:

Предыдущее
От: Pepe TD Vo
Дата:
Сообщение: Re: insert aborted commands ignored
Следующее
От: Tom Lane
Дата:
Сообщение: Re: PgAdmin 4.2 unable to connect to AWS Postgres read-replica instances