Re: Cant connect to psql on winxp - Mailing list pgsql-admin
From | Wolfgang Schedl |
---|---|
Subject | Re: Cant connect to psql on winxp |
Date | |
Msg-id | 1038.83.65.166.242.1160385622.squirrel@webmail.consult-it.biz Whole thread Raw |
In response to | Re: Cant connect to psql on winxp (Adam Radlowski <adamr@informatyka.gdansk.pl>) |
Responses |
Re: Cant connect to psql on winxp
|
List | pgsql-admin |
Thanks, point 3 did the trick! Seems, I have to read the documentation better.... Sorry for the simple question and thanks again Wolfgang > 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 >> >> >> >> > > > Mit freundlichen Grüssen / Best Regards --------------------------------------- Wolfgang Schedl Mobil +43/699/143 695 77 Fax +43/699/443 695 77 mailto:wolfgang.schedl@consult-it.biz --------------------------------------- CONSULT|IT GmbH A-7311 Neckenmarkt www.consult-it.biz ---------------------------------------
pgsql-admin by date: