Aaahh, of course.... I forgot about the trust settings I have there... BTJ Gavin Love wrote: > > Bjørn T Johansen wrote: > >> I am trying to change the password for the postgres user but it >> doesn't work... I >> have tried changing it from pgAdmin, EMS PostgreSQL Manager, etc but >> whatever >> password I set, I still can log in without using password.... (And it >> seems that no >> sql code is run on the server) >> >> What am i missing? > > > Have you checked your pg_hba.conf ? > > It will be set to trust most likely which means the user doesn't need a > password change it to crypt or password or md5 depending on your needs. > > http://www.postgresql.org/docs/8.0/interactive/client-authentication.html#EXAMPLE-PG-HBA.CONF > > > Gavin ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
