Hi again, I still can't connect. I need someone to tell me what I can try to discover what the problem is. Again, here's the problem: pgSQL 8.0.3 install on WinXP SP1. The install works fine. The DB starts and works until we restart the computer. When the machine reboots, we can't connect to the DB anymore. Our developer thinks it might be a problem with permissions on the account. I think it might be something else, especially since I can't telnet 127.0.0.1 5432 after reboot. Here are some other symptoms: If I shut down the service, then try to start it up again, sometimes it simply refuses to start again (bad user/pwd). I have to give it the user and pwd again, and then it seems to start fine. Seems like it's not remembering the info. In the EventLog, I have one application error: 2005-07-26 16:27:57 LOG: logger shutting down That seems to happen every time I shut down the service. There is no error on startup. pgSQL logs seem normal (to my untrained eye) 2005-07-26 16:24:52 LOG: database system was shut down at 2005-07-26 16:24:47 Est 2005-07-26 16:24:52 LOG: checkpoint record is at 0/D33F08 2005-07-26 16:24:52 LOG: redo record is at 0/D33F08; undo record is at 0/0; shutdown TRUE 2005-07-26 16:24:52 LOG: next transaction ID: 3313; next OID: 33614 2005-07-26 16:24:52 LOG: database system is ready 2005-07-26 16:27:56 LOG: received fast shutdown request 2005-07-26 16:27:56 LOG: shutting down 2005-07-26 16:27:56 LOG: database system is shut down 2005-07-26 16:27:57 LOG: logger shutting down 2005-07-26 16:28:17 LOG: database system was shut down at 2005-07-26 16:27:56 Est 2005-07-26 16:28:17 LOG: checkpoint record is at 0/D33F48 2005-07-26 16:28:17 LOG: redo record is at 0/D33F48; undo record is at 0/0; shutdown TRUE 2005-07-26 16:28:17 LOG: next transaction ID: 3313; next OID: 33614 2005-07-26 16:28:17 LOG: database system is ready Now, if I try to connect with pgAdmin III: An error has occured: could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "127.0.0.1" and accepting TCP/IP connections on port 5432? The answer to that is, apparently, no, because I can't telnet 127.0.0.1 5432... Trying to connect doesn't generate either a pg log or an event log, so I have to guess there is really nothing happening. AND I can't seem to find anything relevant on the Internet... Thanks for any help you can provide. ____________________________________________________ Start your day with Yahoo! - make it your home page http://www.yahoo.com/r/hs ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
