Thread: Windows xp initdb POSTGRES_SUPERUSERNAME

Windows xp initdb POSTGRES_SUPERUSERNAME

From
"Jan-Peter Seifert"
Date:
Hello,

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? 
Could you tell me, please?

Thank you very much,

Peter Seifert
--
Psssst! Schon vom neuen GMX MultiMessenger gehört?
Der kann`s mit allen: http://www.gmx.net/de/go/multimessenger

Re: Windows xp initdb POSTGRES_SUPERUSERNAME

From
Tom Lane
Date:
"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