By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,515 Members | 1,339 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,515 IT Pros & Developers. It's quick & easy.

Two general, simple questions

P: n/a
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/ *
Apr 13 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Thu, 13 Apr 2006 00:46:32 +0000, John Oliver wrote:
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.


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

http://www.debianhelp.co.uk/postgresql.htm
Jun 9 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.