Re: [ADMIN] configuring pg_hba.conf...

"Oliver Elphick" wrote:
> Postgres GOD wrote:
> >> Use lines such as
> >>
> >> local all password
> >> host 192.137.23 255.255.255.0 crypt
> >>
> >> in /etc/postgresql/pg_hba.conf; then you can use
> >>
> >> CREATE USER user WITH PASSWORD password...
> >>
> >
> >thanks for your help. i followed your instructions but can't still connect
> >to my database. btw, i'm using 6.3.2 version. i copied exactly the two
> >lines you've mentioned above in my pg_hba.conf and i even tried modifying
> >using my server's ip but still user authentication failed.
> >
> >what should be the problem with this?
>
> Have you restarted the postmaster after editing pg_hba.conf?
> Have you created a password for yourself before trying to connect
> using password authentication?

That shouldn't be necessary. At least I havn't had to.

Can you connect remotly without crypt?
I would try the following.

local all password
host 127.0.0.1 255.255.255.0 password
host 192.137.23 255.255.255.0 crypt

and try to connect from your local machine but using localhost.

psql -u -h localhost

That exercises the network interface. if that works, Try

host 127.0.0.1 255.255.255.0 crypt

I've had the best luck with getting things working using the local
clients first.

Carl

Carl
zmola(at)campbellsci(dot)com