From: Tom Lane <tgl@sss.pgh.pa.us>
To: Bawol, Brian <brian.bawol@freightverify.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: PgAdmin 4.2 unable to connect to AWS Postgres read-replica instances
Date: Thu, 07 Feb 2019 13:47:48 -0500
Message-ID: <13859.1549565268@sss.pgh.pa.us> (raw)
In-Reply-To: <CAF56UXJbZqmpt4Cgcqz=yyEt_X9kfQTfN9ug_KNLEBDX+9z9hw@mail.gmail.com>
References: <CAF56UXJbZqmpt4Cgcqz=yyEt_X9kfQTfN9ug_KNLEBDX+9z9hw@mail.gmail.com>
"Bawol, Brian" <brian.bawol@freightverify.com> writes:
> 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"
That seems pretty strange. What's the actual underlying query that's
failing? (The server log should show that, as a appendage to the
occurrence of this error, even if PgAdmin won't tell you.)
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, brian.bawol@freightverify.com, pgsql-admin@lists.postgresql.org
Subject: Re: PgAdmin 4.2 unable to connect to AWS Postgres read-replica instances
In-Reply-To: <13859.1549565268@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox