Re: Windows xp initdb POSTGRES_SUPERUSERNAME - Mailing list pgsql-admin

From Tom Lane
Subject Re: Windows xp initdb POSTGRES_SUPERUSERNAME
Date
Msg-id 28415.1214838279@sss.pgh.pa.us
Whole thread Raw
In response to Windows xp initdb POSTGRES_SUPERUSERNAME  ("Jan-Peter Seifert" <Jan-Peter.Seifert@gmx.de>)
List pgsql-admin
"Jan-Peter Seifert" <Jan-Peter.Seifert@gmx.de> writes:
> I wonder what this variable in initdb is about: POSTGRES_SUPERUSERNAME
> Apparently the default should be 'postgres'. However, the value changes with the user that is logged in whenever I
use'initdb --show'. If I login as 'xy' the value is 'xy'. Shouldn't this be a fixed value in the cluster? 

No, that's exactly the expected behavior.  The username of the user who
runs initdb is used.

            regards, tom lane

pgsql-admin by date:

Previous
From: "Domingo Alvarez Duarte"
Date:
Subject: Re: Extended security/restriction to any role with login access
Next
From: Michael Monnerie
Date:
Subject: Re: Recommended RAID for Postgres