Two general, simple questions

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/ *

re: Two general, simple questions

On Thu, 13 Apr 2006 00:46:32 +0000, John Oliver wrote:
[color=blue]
> 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.[/color]

You could log in as root, then su postgres, then create your new user.

http://www.debianhelp.co.uk/postgresql.htm