"David Bernal" <david.bernal@xxxxxxxxx> writes: > I recently have been attempting to get my install of postgresql 8.1 > (running Win XP as OS) to listen on both 127.0.0.1 and my IP address, > 192.168.0.100 (inside my network, obviously.) As such, I tried first > setting listen_addresses = '192.168.0.100, localhost' By "8.1" do you really mean "8.1.0"? If so, you might try updating to the latest subrelease (currently 8.1.3). This problem doesn't offhand seem to match any of the bug fixes I see in the CVS logs, but there have been a number of Windows-specific fixes and maybe one of them explains it. > With it like that, when I try to connect to the server using localhost > (I've tried this on a couple different clients) I get an error. If, > for example, I run psql -U user -d base, I get > "psql: server closed the connection unexpectedly > This probably means the server terminated abnormally > before or while processing the request." This should certainly leave some trace in the postmaster log file. If you don't know where the log output is going, find out ;-) regards, tom lane
