"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
[EMAIL PROTECTED]
