Four thigs:
1. Do You have in "postgresql.conf" in section "CONNECION AND
AUTENTICATION" active opction (default is 'localhost'):
listen_adress='*' (if You want to be more safe, read PDF with PostgreSQL
doc chapter 17)
2. You're telneting 83.xxx.xxx.xxx, but You have 62.xxx.xxx.xxx in
pg_hba.conf
3. Try using mode "open for all": 0.0.0.0/0. If You have this mode and
"listen_adress='*'" You have fully open PostgreSQL. If You have still
problems, this should be TCP/IP connection problem. If You want to be
more safe: if You are using 24 mode adress, so in pg_hba.conf You will
have: xxx.xxx.xxx.0/24, 32 mode: xxx.xxx.xxx.xxx/32 for more read PDF
with PostgreSQL doc (chapter 20)
4. Do You have really telnet service started on 5432 port ? I suggest to
stop this service, when You are using other service on tis same port.
With greetings
Adam
Wolfgang Schedl wrote:
Hello,
I have a postgresql-server 8.1 running on a winxp-server. I want to
connect with my ubuntu at home (in the end, it should work with a
ASP.net-program) to the db, but it fails to connect. The port is open - I
can prove this with a working telnet connection.
-----
user@pc:~$ telnet 83.xxx.xxx.xxx 5432
Trying 83.xxx.xxx.xxx...
Connected to 83.xxx.xxx.xxx.
Escape character is '^]'.
-----
The problem is, that the psql-connection fails.
-----
-----
My admin-tool for the pqsql-Server is pgadminIII. I tried to change the
pg_hba.conf and added a line with my IP-adress with the pgadminIII. The
line is correct in the pg_hba.conf.
-----
host all all 62.xxx.xxx.xxx md5
-----
In the config-file everything looks fine, but when I start
pgadminIII->Tools->Server Configuration->pg_hba.conf, it still doesn't
show this line. Could this be the problem or is it just a
pgadminIII-WinXP-bug?
Any ideas, how I could solve the problem?
Thanks
Mit freundlichen Grüssen / Best Regards
---------------------------------------
Wolfgang Schedl
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
