Re: [GENERAL] pg_basebackup issue

Поиск
Список
Период
Сортировка
От chiru r
Тема Re: [GENERAL] pg_basebackup issue
Дата
Msg-id CA+RSxMi5uYdVNaHuFJ8GvGj_pvrbt30Td0rVP3d8X9p7kg_MXw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] pg_basebackup issue  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: [GENERAL] pg_basebackup issue
Список pgsql-general
Дерево обсуждения
Thanks you. The FATAL message is not clear. Yes, It is helpful if someone with more knowledge of the connection code.


[postgres@pgserver ~]$ /opt/PostgreSQL/9.5/bin/pg_basebackup  --format=t   --pgdata=online_backups1 -p 5432 -U backup_admin  -x -z  --verbose
pg_basebackup: could not connect to server: FATAL:  must be superuser or replication role to start walsender


On Sat, Apr 22, 2017 at 2:00 PM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 04/22/2017 10:04 AM, chiru r wrote:
Thanks for the reply,

Actually I am not setting Role for database specific,I did set Role to
user.
Since users and roles are global for all databases in PostgreSQL,I
believe it should work for replication pesudo database.

 Except for the part where the 'replication' database does not actually exist, so I am not seeing how a connection could be established to it. Now whether a replication connection is supposed to honor SET ROLE is something someone with more knowledge of the connection code will have to answer. The evidence says it does not.


Thanks,
Chiru


--
Adrian Klaver
adrian.klaver@aklaver.com

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

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: [GENERAL] Total ram size study
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: [GENERAL] pg_basebackup issue