Re: No user being created during initdb for OS X

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: jamie(at)doitonce(dot)net(dot)au
Cc: tfo(at)sitening(dot)com, pgsql-hackers(at)postgresql(dot)org
Subject: Re: No user being created during initdb for OS X
Date: 2005-07-21 12:53:30
Message-ID: 42DF9ACA.4010804@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Andrew Dunstan wrote:

>>
>>
>
>2. initdb will only create one user, as specified by -U and defaulting to
>the name of the user running initdb. Thus it will only ever create a user
>called postgres if '-U postgres' is specified, or
>if -U is not used and the user running initdb is called postgres.
>
>

grammar fixed above so it makes sense

4. if you want to see what user(s) it knows about, shut down the
postmaster and run postgres in standalone mode like this:

echo 'select usename from pg_user' | /pathto/postgres -D /pathto/data
template1

cheers

andrew

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joe Maldonado 2005-07-21 13:31:22 Re: TRUNCATE locking problem
Previous Message dmsoft 2005-07-21 11:33:18 ANN: Access2PostrgreSQL Pro v1.0.0 release

Browse pgsql-hackers by date

  From Date Subject
Next Message Brusser, Michael 2005-07-21 13:15:51 Re: recover corrupted pg_controldata from WAL
Previous Message Michael Fuhr 2005-07-21 11:10:55 Re: [HACKERS] No user being created during initdb for OS X