|
Home > Archive > PostgreSQL Administration > October 2006 > Cant connect to psql on winxp
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Cant connect to psql on winxp
|
|
| Wolfgang Schedl 2006-10-25, 8:24 am |
| 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
| |
| Adam Radlowski 2006-10-25, 8:24 am |
| 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
>
>
>
>
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
| |
| Wolfgang Schedl 2006-10-25, 8:24 am |
| 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:
>
>
>
>
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
---------------------------------------
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql
.org so that your
message can get through to the mailing list cleanly
| |
| Ray Stell 2006-10-25, 8:24 am |
| On Mon, Oct 09, 2006 at 11:20:22AM +0200, Wolfgang Schedl wrote:
> Thanks, point 3 did the trick! Seems, I have to read the documentation
> better....
point 3 was a test, right? You are not intending to leave it that way,
of course?
[color=darkred]
you can use the telnet client to connect to any port, the telnet service
does not have to be the service that syn/acks:
& #91;postgresql@wirew
orm postgresql]$ telnet stell 25
Trying 198.82.169.14...
Connected to locust.cns.vt.edu (198.82.169.14).
Escape character is '^]'.
220 locust.cns.vt.edu ESMTP
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
| |
| Wolfgang Schedl 2006-10-25, 8:24 am |
| I meant, that the pga_postgres.conf-setting "listen_adress='*'" did the
trick! :-)
Thanks again
Wolfgang
> On Mon, Oct 09, 2006 at 11:20:22AM +0200, Wolfgang Schedl wrote:
>
> point 3 was a test, right? You are not intending to leave it that way,
> of course?
>
>
>
>
>
> you can use the telnet client to connect to any port, the telnet service
> does not have to be the service that syn/acks:
>
> & #91;postgresql@wirew
orm postgresql]$ telnet stell 25
> Trying 198.82.169.14...
> Connected to locust.cns.vt.edu (198.82.169.14).
> Escape character is '^]'.
> 220 locust.cns.vt.edu ESMTP
>
>
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
---------------------------------------
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
|
|
|
|
|