Folks:
in tutorial-createdb, it says:
"... where your own login name is mentioned. This will happen if the
administrator has not created a PostgreSQL user account for you.
(PostgreSQL user accounts are distinct from operating system user
accounts.) If you are the administrator, see Chapter 18 for help creating
accounts. You will need to become the operating system user under which
PostgreSQL was installed (usually postgres) to create the first user
account. It could also be that you were assigned a PostgreSQL user name
that is different from your operating system user name; in that case you
need to use the -U switch or set the PGUSER environment variable to
specify your PostgreSQL user name."
This isn't nearly clear enough for a tutorial. It should say:
"... where your own login name is mentioned. This will happen if the
administrator has not created a PostgreSQL user account for you.
(PostgreSQL user accounts are distinct from operating system user
accounts.) It could also be that you were assigned a PostgreSQL user name
that is different from your operating system user name; in that case you
need to use the -U switch or set the PGUSER environment variable to
specify your PostgreSQL user name.
If this is a new installation and you are the administrator, then you
probably need to connect as the system user who owns the PostgreSQL
installation, usually "postgres", but sometimes "pgsql". On POSIX systems
you can do this via the command "su - postgres"; otherwise simply log into
the system as that system user. Once you are logged in as the
installation owner, you can use createuser<link> to add other accounts."
--
--Josh
Josh Berkus
PostgreSQL @ Sun
San Francisco