Two general, simple questions

Question posted by: John Oliver (Guest) on April 13th, 2006 12:58 AM

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

Would you like to answer this question?
Sign up for a free account, or Login (if you're already a member).

ophidian

Guest

n/a Posts

June 9th, 2006
12:15 AM
#2

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

Not the answer you were looking for? Post your question . . .
184,013 Experts ready to help you find a solution.
Sign up for a free account, or Login (if you're already a member).

Latest Articles: Read & Comment

Didn't find the answer you were looking for?
Post Your Question

Top Community Contributors