Re: Can't connect after restart

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