Re: Errors on VACUUM - Mailing list pgsql-admin

From Bob Smith
Subject Re: Errors on VACUUM
Date
Msg-id 9E174BCE-3883-11D6-B665-0003933DD370@h-e.com
Whole thread Raw
In response to Re: Errors on VACUUM  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
On Friday, March 15, 2002, at 03:07 , Tom Lane wrote:

> It's not clear to me why a restart (which would naturally clear shared
> memory) didn't fix the problem.

Er, um, (humble look), I just studied my syslog, and in fact the
postmaster _didn't_ restart.  I tried to restart it using the Red Hat
control script from /etc/rc.d/init.d,  but apparently that script lied
to me when it said the restart succeeded.  The syslog clearly shows the
postmaster didn't actually restart until about 10 minutes later, _after_
the second error.  So I was talking to the same postmaster every time.
Arrggh.

I'm reassured now that this is just a passing memory management issue
and not a symptom of a more serious problem, I'm sure the error wouldn't
have happened the second time if the postmaster had in fact restarted.
Everything looks fine now so I'm going to stop worrying about it.

Thanks much for your help!

Bob Smith
Hammett & Edison, Inc.
bsmith@h-e.com


pgsql-admin by date:

Previous
From:
Date:
Subject: Re: [GENERAL] Btree index extension question
Next
From: Jean-Michel POURE
Date:
Subject: Re: to --enable-locale or not to --enable-locale?