Skip site navigation (1) Skip section navigation (2)

Suggested changes to Tutorial

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-docs(at)postgresql(dot)org
Subject: Suggested changes to Tutorial
Date: 2006-07-31 22:29:35
Message-ID: 200607311529.35214.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-docs
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

Responses

pgsql-docs by date

Next:From: Joshua D. DrakeDate: 2006-08-01 00:09:12
Subject: Re: Suggested changes to Tutorial
Previous:From: Joshua D. DrakeDate: 2006-07-31 21:46:45
Subject: Re: [HACKERS] 8.2 features?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group