BUG #15643: Problem using PGAdmin 4.2 to connect to postrgres hot standby

Поиск
Список
Период
Сортировка
От PG Bug reporting form
Тема BUG #15643: Problem using PGAdmin 4.2 to connect to postrgres hot standby
Дата
Msg-id 15643-944c1ac9f8108278@postgresql.org
обсуждение исходный текст
Ответы Re: BUG #15643: Problem using PGAdmin 4.2 to connect to postrgres hot standby  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      15643
Logged by:          Eric Katchan
Email address:      eric.katchan+postgres@concordia.ca
PostgreSQL version: 9.6.9
Operating system:   Linux
Description:

I have pgAdmin 4.2 installed on my windows machine.  I am trying to connect
to our hot standby server with pgAdmin and I get the following Error:
ERROR: cannot execute SELECT in a read-only transaction

My DBA has indicated that when I attempt to connect to the server I am
attempting the following SQL:

< 2019-02-19 14:14:04.578 EST > STATEMENT:  SET DateStyle=ISO; SET
client_min_messages=notice;UPDATE pg_settings SET setting = 'escape'
WHERE name = 'bytea_output';SET client_encoding='UNICODE';

Any ideas?


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

Предыдущее
От: Julien Rouhaud
Дата:
Сообщение: Re: BUG #15572: Misleading message reported by "Drop functionoperation" on DB with functions having same name
Следующее
От: David Rowley
Дата:
Сообщение: Re: BUG #15572: Misleading message reported by "Drop functionoperation" on DB with functions having same name