Re: bdr admin role

From: Ray Stell <stellr(at)vt(dot)edu>
To: Craig Ringer <craig(at)2ndquadrant(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: bdr admin role
Date: 2015-09-07 12:34:11
Message-ID: 55ED8443.8080700@vt.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 9/6/15 10:55 PM, Craig Ringer wrote:
> On 4 September 2015 at 21:46, Ray Stell <stellr(at)vt(dot)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?
Yes.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jayadevan M 2015-09-07 12:55:32 Partitioning and constraint exclusion
Previous Message James Harper 2015-09-07 11:07:49 Re: SPI_execute error handling