I know nothing about databases, SQL, or PostGreSQL :-)

I installed PostGreSQL and phpPgAdmin on a web server. It looks like
PostGreSQL insists that a username / password be supplied, unlike MySQL
that just runs as "root". I'm trying to find out how to add a user, but
apparently, this is such a stupendously simple operation that everybody
should know how to do, since it isn't mentioned anywhere :-) As an
adjunct (and my second question), I'm trying to find out how to enable
logging.

--
* John Oliver http://www.john-oliver.net/ *
* Reform California gun laws - http://www.reformcagunlaws.com/ *
* http://www.gunownersca.com - http://www.crpa.org/ *
* San Diego shooters come to http://shooting.forsandiego.com/ *

John Oliver wrote:
have permission from the root user or systems admin or depending on who
installed PostgreSQL. If you can become the postgres user (i.e. - 'su
postgres') then simply type 'createuser'. Postgres will ask is the new
user can 'create new users?' and 'can create new databases?' I think in
that order. It will then say 'NEW USER CREATED' and there you have it!
Check the PostgreSQL documentation on how to set up accounts. The nice
feature about PostgreSQL compared to MySQL is that it can be installed
and used by a standard user as opposed to the 'root' user which can be
extremely dangerous in a UNIX/Linux environment. Also logging for
PostgreSQL is kept in the '/etc/postgresql/8.0/main/' on a Debian or
Ubuntu (what I have) based system. I believe the source version is kept
in the same directory as well. Well good luck and enjoy!!!

Schmidty