Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] pg_basebackup issue - Mailing list pgsql-general

From chiru r
Subject Re: [GENERAL] pg_basebackup issue
Date
Msg-id CA+RSxMi5uYdVNaHuFJ8GvGj_pvrbt30Td0rVP3d8X9p7kg_MXw@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] pg_basebackup issue  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: [GENERAL] pg_basebackup issue  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view
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 by date:

Previous
From: John R Pierce
Date:
Subject: Re: [GENERAL] Total ram size study
Next
From: Adrian Klaver
Date:
Subject: Re: [GENERAL] pg_basebackup issue