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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match