Skip site navigation (1) Skip section navigation (2)

Re: PostgreSQL/PGAdmin service hangs when listen_addresses

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Vitaly Belman <vitalyb(at)gmail(dot)com>
Cc: PostgreSQL Win32 <pgsql-hackers-win32(at)postgresql(dot)org>
Subject: Re: PostgreSQL/PGAdmin service hangs when listen_addresses
Date: 2004-12-13 23:49:49
Message-ID: 41BE2A9D.9020005@dunslane.net (view raw or flat)
Thread:
Lists: 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)
>
>  
>

In response to

Responses

pgsql-hackers-win32 by date

Next:From: Jonathan BarnhartDate: 2004-12-14 01:40:44
Subject: Application specific installs
Previous:From: Bruce MomjianDate: 2004-12-13 19:43:27
Subject: Re: Version numbers on libpq.dll

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group