Re: Can't connect after restart - Mailing list pgsql-general

--- "Matthew T. O'Connor" <matthew@zeut.net> 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