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@campbellsci.com