More on: Re: error on writing to postgres

[Marc Powell]

Nancy Bronstein <mailto:nan at simons-rock.edu> wrote:
> After wrangling with this installation further I have more info that
> I'm hoping will ring a bell with someone. To capsulize: 
> --running nagios 1.2
> --postgres 7.2.1
> --am getting this error message on starting nagios:
> 
> 	Error: Could not insert/update status record for program in
table
> 'programstatus' of database 
> 
> --and in syslog, this error message:
> 
> 	 ERROR:  Bad abstime external representation'1081953908'
> 


That actually does ring a bell. It's been a long time but I remember
having that same error (and other time-related issues with postgres).
I'm 98% sure they turned out to be a postgres bugs. We're currently
running 7.3.4 and all is well. I'm not exactly sure at what release
versions each was fixed though. Just in case my mind is fuzzy (it
happens more these days ;)), I'd do a test installation of a newer
version of postgres before upgrading fully unless nagios is the only
thing you're using it for.

--
Marc


-------------------------------------------------------
This SF.Net email is sponsored by: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of
GenToo technologies. Learn everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id70&alloc_id638&op=click
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null