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

2019-02-07 Thread Ashesh Vashi
On Fri, Feb 8, 2019 at 1:58 AM Tom Lane wrote: > I wrote: > >> This looks like a pgadmin bug ... > > > Looking at it, I'm betting somebody thought this was a cute way to > > set bytea_output if it exists, without getting a failure on servers > > too old to have it. We added that in 9.0, so maybe

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

2019-02-07 Thread Tom Lane
I wrote: >> This looks like a pgadmin bug ... > Looking at it, I'm betting somebody thought this was a cute way to > set bytea_output if it exists, without getting a failure on servers > too old to have it. We added that in 9.0, so maybe it's not quite > old enough to make it a moot point; but fa

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

2019-02-07 Thread Tom Lane
Alvaro Herrera writes: > On 2019-Feb-07, Bawol, Brian wrote: >> It looks like this is the query that occurs at the same time: >> STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice;UPDATE >> pg_settings SET setting = 'escape'WHERE name = 'bytea_output';SET >> client_encoding='UNICODE

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

2019-02-07 Thread Alvaro Herrera
On 2019-Feb-07, Bawol, Brian wrote: > It looks like this is the query that occurs at the same time: > > STATEMENT: SET DateStyle=ISO; SET client_min_messages=notice;UPDATE > pg_settings SET setting = 'escape'WHERE name = 'bytea_output';SET > client_encoding='UNICODE'; > > Does this help? A