--- "Matthew T. O'Connor" <matthew@xxxxxxxx> wrote: > Audrey Bergeron-Morin wrote: > > >We've been having trouble with a pgSQL 8.0.3 > install > >on a WXP machine. Install goes fine, DB works until > we > >restart the machine, then we can't connect. First > time > >we thought something was corrupted because we had a > >power outage, we uninstalled/reinstalled and it was > >fine until, again, we decided to reboot. We were > >thinking it was a problem with permissions, but it > >doesn't make much sense to me that it's working > fine > >before we restart. > > > >So, what can I send you to better describe my > problem? > >Do you think it could be a problem with > permissions? > >How can I test to find out what the problem might > be? > > > > > > Have you looked at the postgersql log files to see > if there are any > errors? Sounds like one possibility is that the PID > file is not getting > deleted on reboot and needs to be manually removed > so that the > postmaster restarts. We need more information to > diagnose the problem, > and the log files are a good place to start. There were a couple of things in the logs, including anomalous shutdowns. I have absolutely no idea what is relevant and what is not, so I copied everything below. I also found in the EventLogs, under System, an error saying RCManClient couldn't start because of an invalid path. Again, I have no idea if it is relevant. In any case, I copied the logs written since we rebooted (around 14:05) below. Thank you for your help, and let me know what info I can send you to help find the problem... ********* 2005-07-21 11:01:25 LOG: database system was interrupted at 2005-07-11 14:24:13 Est 2005-07-21 11:01:25 LOG: checkpoint record is at 0/D33C48 2005-07-21 11:01:25 LOG: redo record is at 0/D33C48; undo record is at 0/0; shutdown FALSE 2005-07-21 11:01:25 LOG: next transaction ID: 3313; next OID: 33614 2005-07-21 11:01:25 LOG: database system was not properly shut down; automatic recovery in progress 2005-07-21 11:01:25 LOG: record with zero length at 0/D33C88 2005-07-21 11:01:25 LOG: redo is not required 2005-07-21 11:01:25 LOG: database system is ready 2005-07-21 11:02:04 FATAL: password authentication failed for user "jbondc" 2005-07-21 11:02:05 FATAL: password authentication failed for user "jbondc" 2005-07-21 11:02:06 FATAL: password authentication failed for user "jbondc" 2005-07-21 11:02:07 FATAL: password authentication failed for user "jbondc" 2005-07-21 11:02:38 FATAL: password authentication failed for user "jbondc" 2005-07-21 11:02:38 FATAL: password authentication failed for user "jbondc" 2005-07-21 11:02:39 FATAL: password authentication failed for user "jbondc" 2005-07-21 11:02:40 FATAL: password authentication failed for user "jbondc" 2005-07-21 11:03:18 FATAL: password authentication failed for user "jbondc" 2005-07-21 14:04:53 LOG: received fast shutdown request 2005-07-21 14:04:54 LOG: shutting down 2005-07-21 14:04:54 LOG: database system is shut down 2005-07-21 14:04:58 LOG: logger shutting down ******************************** 2005-07-21 11:02:36 LOG: database system was interrupted at 2005-07-21 11:01:25 Est 2005-07-21 11:02:36 LOG: checkpoint record is at 0/D33C88 2005-07-21 11:02:36 LOG: redo record is at 0/D33C88; undo record is at 0/0; shutdown TRUE 2005-07-21 11:02:36 LOG: next transaction ID: 3313; next OID: 33614 2005-07-21 11:02:36 LOG: database system was not properly shut down; automatic recovery in progress 2005-07-21 11:02:36 LOG: record with zero length at 0/D33CC8 2005-07-21 11:02:36 LOG: redo is not required 2005-07-21 11:02:36 LOG: database system is ready 2005-07-21 14:04:53 LOG: received fast shutdown request 2005-07-21 14:04:54 LOG: shutting down 2005-07-21 14:04:55 LOG: database system is shut down 2005-07-21 14:04:58 LOG: logger shutting down ********************************* 2005-07-21 14:06:10 LOG: database system was shut down at 2005-07-21 14:04:54 Est 2005-07-21 14:06:10 LOG: checkpoint record is at 0/D33D48 2005-07-21 14:06:10 LOG: redo record is at 0/D33D48; undo record is at 0/0; shutdown TRUE 2005-07-21 14:06:10 LOG: next transaction ID: 3313; next OID: 33614 2005-07-21 14:06:11 LOG: database system is ready 2005-07-21 14:28:28 LOG: received fast shutdown request 2005-07-21 14:28:28 LOG: shutting down 2005-07-21 14:28:28 LOG: database system is shut down 2005-07-21 14:28:28 LOG: logger shutting down *********************************** 2005-07-21 14:29:10 LOG: database system was shut down at 2005-07-21 14:28:28 Est 2005-07-21 14:29:10 LOG: checkpoint record is at 0/D33D88 2005-07-21 14:29:10 LOG: redo record is at 0/D33D88; undo record is at 0/0; shutdown TRUE 2005-07-21 14:29:10 LOG: next transaction ID: 3313; next OID: 33614 2005-07-21 14:29:10 LOG: database system is ready 2005-07-21 14:29:54 LOG: received fast shutdown request 2005-07-21 14:29:54 LOG: shutting down 2005-07-21 14:29:54 LOG: database system is shut down 2005-07-21 14:29:55 LOG: logger shutting down **************************************** 2005-07-21 14:29:56 LOG: database system was shut down at 2005-07-21 14:29:54 Est 2005-07-21 14:29:56 LOG: checkpoint record is at 0/D33DC8 2005-07-21 14:29:56 LOG: redo record is at 0/D33DC8; undo record is at 0/0; shutdown TRUE 2005-07-21 14:29:56 LOG: next transaction ID: 3313; next OID: 33614 2005-07-21 14:29:56 LOG: database system is ready 2005-07-21 15:04:50 LOG: received fast shutdown request 2005-07-21 15:04:50 LOG: shutting down 2005-07-21 15:04:50 LOG: database system is shut down 2005-07-21 15:04:52 LOG: logger shutting down ************************************* 2005-07-21 15:06:03 LOG: database system was shut down at 2005-07-21 15:04:50 Est 2005-07-21 15:06:03 LOG: checkpoint record is at 0/D33E48 2005-07-21 15:06:03 LOG: redo record is at 0/D33E48; undo record is at 0/0; shutdown TRUE 2005-07-21 15:06:03 LOG: next transaction ID: 3313; next OID: 33614 2005-07-21 15:06:03 LOG: database system is ready __________________________________ Yahoo! Mail for Mobile Take Yahoo! Mail with you! Check email on your mobile phone. http://mobile.yahoo.com/learn/mail ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
