[icinga-users] Problem with PostgreSQL and FROM_UNIXTIME(int)?

Carl R. Friend crfriend at rcn.com
Sun Dec 16 21:34:06 CET 2012


    On Sun, 16 Dec 2012, Bjørn T Johansen wrote:

> I just thought I would check if this was a known problem first..
> And it seems to be that it should have been, but it might have
> been fixed in a later version...

    The error text is pretty concrete -- Postgresql doesn't have the
FROM_UNIXTIME() function.  Are you declaring MySQL or Postgres in
your ido2db.cfg file?

> I took a quick search and that function seems to be a function that
> MySQL has and PGSQL has not.. But I also find a funtion that I could
> add to make PGSQL support the from_unixtime funtion and it seems to
> be working....

    If there is an addition to the Postgres package to add the
FROM_UNIXTIME() function (and UNIX_TIMESTAMP()) then it's a matter
of adding it to the Postgres environment.  If that's the case, please
post details of it.  A documentation case may need to be created to
showcase that and call it to folks' attention.

    Cheers!

+------------------------------------------------+---------------------+
| Carl Richard Friend (UNIX Sysadmin)            | West Boylston       |
| Minicomputer Collector / Enthusiast            | Massachusetts, USA  |
| mailto:crfriend at rcn.com                        +---------------------+
| http://users.rcn.com/crfriend/museum           | ICBM: 42:22N 71:47W |
+------------------------------------------------+---------------------+


More information about the icinga-users mailing list