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/ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
