Re: bdr admin role - Mailing list pgsql-general

From Craig Ringer
Subject Re: bdr admin role
Date
Msg-id CAMsr+YH_C=6kMM_FNewNikOG3gnXGK_5+7X1-4iwk_xyTvyoWw@mail.gmail.com
Whole thread Raw
In response to Re: bdr admin role  (Ray Stell <stellr@vt.edu>)
Responses Re: bdr admin role
List pgsql-general
On 4 September 2015 at 21:46, Ray Stell <stellr@vt.edu> wrote:
>>>> FATAL:  role "postgresql" does not exist
>>>
>>> It works if I init with "-U postgresql"
>
> The demo works fine if
> I use the string "postgresql" as the admin role.  It looks like you might
> want to build -U support into bdr at some point.

It's not at all clear to me how this is happening. The string
"postgresql" isn't hardcoded by BDR anywhere that it could conceivably
be passed as a username for a connection string, so I'm not sure
what's going on.

I've never used "postgresql" as the default superuser name. Typically
I use "postgres".

I don't see anything particularly informative in the main PostgreSQL
sources that could explain it either. We pass "postgresql" as the
PGSQL_PAM_SERVICE and use it as the default RADIUS identifier, but I
fail to see how those could get passed as the login role identifier.

Are you running it under a unix user named "postgresql", by any chance?

--
 Craig Ringer                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services


pgsql-general by date:

Previous
From: "FarjadFarid\(ChkNet\)"
Date:
Subject: table dependencies
Next
From: Craig Ringer
Date:
Subject: Re: BDR global sequences in two machine failover