Lists: | pgsql-hackers |
---|
From: | Jürgen Wolfsgruber <juergen(dot)wolfsgruber(at)gmail(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Problem with postgresql database connection in combination with HUAWEI data modem |
Date: | 2011-01-31 09:16:22 |
Message-ID: | 09D01FEA-78F8-437C-A715-BDA0282BD2B9@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
Hello,
I discussed my problem at www.pg-forum.de with Mr. Scherbaum (ADS) and he recommended me to inform you about this problem.
I worked on my Mac-Book (Mac OS X 10.6.6) with postgresql database version 9 (postgresql-9.0.1-1-osx.dmg). After installing and connecting my HUAWEI E122 data modem (net provider 3 (drei)), I have detected, that I could't connect to database.
Disconnecting the HUAWEI modem has no effects. I could not connect to database. Restarting the system makes the database available again.
The problem occurs exactly at connecting to internet from 3DataManager. There are no problems with connecting USB-Stick to Mac Book or starting the 3DataManager.
I installed the postgresql-database with default settings:
host: localhost
port: 5432
user: postgres
listen_addresses: *
This is a netstat-result after connecting via HUAWEI data modem:
Active Internet connections (including servers)
Proto Recv-Q Send-Q Local Address Foreign Address (state)
tcp4 0 0 178.113.226.250..52044 c-98-245-185-91..56489 ESTABLISHED
tcp4 0 0 *.21234 *.* LISTEN
tcp4 0 0 *.postgresql *.* LISTEN
tcp6 0 0 *.postgres *.* LISTEN
tcp4 0 0 .psf.ipp *.* LISTEN
tcp6 0 0 localhost.ipp *.* LISTEN
Trying to start a telnet-connection, the result was:
telnet 127.0.0.1 5432
Trying 127.0.0.1...
telnet: connect to address 127.0.0.1: Operation timed out
telnet: Unable to connect to remote host
As I had no idea, what the problem could be, I tried installing the latest version of postgresql (postgresql-9.0.2-1-osx.dmg), maybe that this problem is fixed now.
But it has no effect.
Then I tried reproducing the problem on my Windows 7 system. I installed the HUAWEI data stick and connected it to the internet.
I could connect to database without problems!! So I checked the version of postgresql on my windows system. The version is 8.4! (postgresql-8.4.2-1-windows.exe)
After uninstalling of postgresql 9 from my Mac Book and installing the latest 8.4 version (postgresql-8.4.6-1-osx.dmg), the problem was also solved.
Maybe that the problem is a 32/64 bit problem.
best regards,
Juergen Wolfsgruber
From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
---|---|
To: | Jürgen Wolfsgruber <juergen(dot)wolfsgruber(at)gmail(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Problem with postgresql database connection in combination with HUAWEI data modem |
Date: | 2011-02-03 15:45:51 |
Message-ID: | AANLkTimp8oxXUquTVirkSaYcRbxQKkWWajPu6+Yxxahf@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
2011/1/31 Jürgen Wolfsgruber <juergen(dot)wolfsgruber(at)gmail(dot)com>:
> Trying to start a telnet-connection, the result was:
>
> telnet 127.0.0.1 5432
> Trying 127.0.0.1...
> telnet: connect to address 127.0.0.1: Operation timed out
> telnet: Unable to connect to remote host
That's just bizarre. How can you get a network timeout over the
loopback address?
Your data modem is probably doing something funky to your network
stack, but I don't know what. Can you connect to PostgreSQL over a
UNIX socket when the system is in this state? Does stuff continue to
show up in the log file? (e.g. If you send the postmaster a SIGTERM
while it's like this, do you see shutdown messages?)
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
From: | Markus Wanner <markus(at)bluegap(dot)ch> |
---|---|
To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
Cc: | Jürgen Wolfsgruber <juergen(dot)wolfsgruber(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Problem with postgresql database connection in combination with HUAWEI data modem |
Date: | 2011-02-04 16:16:52 |
Message-ID: | 4D4C2674.2050900@bluegap.ch |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
On 02/03/2011 04:45 PM, Robert Haas wrote:
> Your data modem is probably doing something funky to your network
> stack, but I don't know what.
Are other network services affected as well? In that case, I'd file a
bug against the modem driver software.
Regards
Markus Wanner