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