Re: Newbie's question: How can I connect to my postgresql-server?

On Fri, Sep 25, 2009 at 02:47:23AM +0700, Ricky Tompu Breaky wrote:
> I'm sure that I used the correct password as "createuser" the
> account of 'ricky'.

By default; PG is set up not to use passwords in the "local" case. This
is what the "ident" in the error is about. Your PG username needs to be
the same as your Unix username or ident authentication will fail.

Have a look at:

http://www.postgresql.org/docs/current/interactive/auth-pg-hba-conf.html

if you want to change it to use passwords as the authentication method
in the local case.

Note, that you don't need to restart PG when adding/removing users,
but you do when changing the config files like pg_hba.conf and
postgresql.conf. It's a "inside"/"outside" PG thing, users are stored
in the database and hence PG knows when they're added/removed, but the
config files are outside and PG doesn't know when to go looking for
changes. There are plans to change this for pg_hba.conf, but you'll
have to wait a bit before that happens.

--
Sam http://samason.me.uk/