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
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 |
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 |