Re: Post Install / Secure PostgreSQL

On Fri, Sep 10, 2010 at 11:53:12AM -0400, Carlos Mennens wrote:
> On Fri, Sep 10, 2010 at 11:33 AM, Richard Broersma
> <richard(dot)broersma(at)gmail(dot)com> wrote:
> > I don't believe there is a script like this.  However, I would say
> > that out of the box, PostgreSQL is so secure that some people
> > cannot figure out how to log in. :)
>
> I agree and I am just now learning this. I can't seem to find out
> how to login to the database. I am using 'psql -U root' however
> during my installation there may have been a default password used
> which I am not aware of. I need to read the docs and see how to
> login to the database.

This is where MySQL's crazily-insecure-by-default assumptions are
messing you up.

The root user has nothing to do with PostgreSQL, except in the sense
that root installs software. Thereafter, the postgres (or pgsql on
some of the BSDs) user is the database superuser. Once it's
installed, try:

su - postgres
psql -l

Happy PostgreSQLing :)

Cheers,
David.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate