Re: PostgreSQL/PGAdmin service hangs when listen_addresses - Mailing list pgsql-hackers-win32

From Andrew Dunstan
Subject Re: PostgreSQL/PGAdmin service hangs when listen_addresses
Date
Msg-id 41BE2A9D.9020005@dunslane.net
Whole thread Raw
In response to PostgreSQL/PGAdmin service hangs when listen_addresses = '*'  (Vitaly Belman <vitalyb@gmail.com>)
Responses Re: PostgreSQL/PGAdmin service hangs when listen_addresses
List pgsql-hackers-win32

what shows up in the server log?

If that parameter is in error you should see messages like this:

  could not create listen socket for "foo"

(Is there a windows utility that does the equivalent of netstat -a? How
does one see what is being listened to?)

cheers

andrew

Vitaly Belman wrote:

>After changing the listen_address to '*' I told PGAdmin to stop the
>service, then to start it.
>Then when I tried to connect to the database PGAdmin just hanged. The
>service wouldn't stop afterward and I had to restart. I tried several
>times with the same result.
>
>Changing the listen_addresses to 'localhost' and even to 'localhost,*'
>and following the same procedure with PGAdmin works fine.
>
>Anyone can confirm this? Why is it happening?
>
>PostgreSQL 8.0.0rc1
>PGAdmin 1.2.0 Post-RC2 (Nov 20 2004)
>
>
>

pgsql-hackers-win32 by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Version numbers on libpq.dll
Next
From: Jonathan Barnhart
Date:
Subject: Application specific installs