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)
>
>
>