Born Today: PostBIX to monitor PostgreSQL

[dalle]

I've wrote Postbix as a fork of Orabbix.
this mean that PostBix has the same features of Orabbix:

• Connection Pool
• Multithread
• Don't has limits on number of monitored databases
• Is opensource and released under GPL

It's just a pre-release so be patience with him (and me of course )
Any help to develope this project is really welcome i mean that if someone has some request, want add a query, trigger, item please notice to me.
Now Postbix just graphs some items and advice is Postbix don't send more data any other kind of trigger or item to monitor is welcome!!!
nice day!
all is available as usual on sourceforge or on my website

[fgallese]

Nice! I will give it a try =D

[dalle]

let me know how-to improve-it!

[exkg]

Is not working ...

[main] ERROR Postbix - Error diuring alive testing for dbname ->xxxorg.postgresql.util.PSQLException: ERROR: relation "dual" does not exist

[]s,
Luciano

[dalle]

Is not working ...

[main] ERROR Postbix - Error diuring alive testing for dbname ->xxxorg.postgresql.util.PSQLException: ERROR: relation "dual" does not exist

[]s,
Luciano

I'm working on it I've introduced some problem before relase it. I'm sorry i'll notify asap for the new release
Andrea

[dalle]

I've released Postbix 1.1.0-rc1
This is a candidate release any feedback will be really appreciate!
this software is available for download on my website
and on sourceforge
Nice day
Dalle

[tof233]

Thank you Dalle,
I will test it now and give you my feedback.

[dalle]

please download the lastest release
Postbix-1.1.0-RC2
from my website or from sourceforge
Regards
Andrea

[tof233]

Here is my first feedback:

As Orabbix, it's quite easy to set up.

With an unused databse, I got the following results:

accessexclusivelock	 01 Dec 2010 16:09:43	0	- 	Graph
accesssharelock		 01 Dec 2010 16:09:43	1	- 	Graph
Activeconnection	 01 Dec 2010 16:09:43	0	- 	Graph
Alive			 01 Dec 2010 16:09:43	1	- 	Graph
exclusivelock		 01 Dec 2010 16:09:43	1	- 	Graph
rowexclusivelock	 01 Dec 2010 16:09:43	0	- 	Graph
rowsharelock		 01 Dec 2010 16:09:43	0	- 	Graph
sharerowexclusivelock	 01 Dec 2010 16:09:43	0	- 	Graph
shareupdateexclusivelock 01 Dec 2010 16:09:43	0	- 	Graph
tupreturned		 - 			-	- 	Graph
xactcommit		 01 Dec 2010 16:09:43	0	- 	Graph
xactrollback		 01 Dec 2010 16:09:43	0	- 	Graph

2010-12-01 16:09:43,280 [main] INFO  Postbix - Starting Postbix  Version 1.1.0-RC2 
 2010-12-01 16:09:43,289 [main] INFO  Postbix - PostBix started with pid:22157
 2010-12-01 16:09:43,289 [main] INFO  Postbix - PidFile -> ./logs/postbix.pid
 2010-12-01 16:09:43,316 [main] INFO  Postbix - Note: Postgresql.MaxActive null
 2010-12-01 16:09:43,316 [main] INFO  Postbix - Note: Postgresql.MaxWait null
 2010-12-01 16:09:43,316 [main] INFO  Postbix - Note: Postgresql.MaxIdle null
 2010-12-01 16:09:43,489 [main] INFO  Postbix - Connected as zabbix
 2010-12-01 16:09:43,498 [main] INFO  Postbix - --------- on Database -> opennms
 2010-12-01 16:09:43,576 [pool-1-thread-1] WARN  Postbix - I'm going to return 0 for query activeconn on database=Postgresql
 2010-12-01 16:09:43,578 [pool-1-thread-1] WARN  Postbix - Error while executing ->tupfetched- on database ->Postgresql- Exception received ERROR: column "tup_fetched" does not exist
 2010-12-01 16:09:43,579 [pool-1-thread-1] ERROR Postbix - Error on DBEnquiry on query=tupfetched on database=Postgresql Error returned is java.lang.IllegalArgumentException: null value for key 'tupfetched'
 2010-12-01 16:09:43,579 [pool-1-thread-1] WARN  Postbix - I'm going to return  for query tupfetched on database=Postgresql
 2010-12-01 16:09:43,579 [pool-1-thread-1] WARN  Postbix - Error while executing ->tupinserted- on database ->Postgresql- Exception received ERROR: column "tup_inserted" does not exist
 2010-12-01 16:09:43,579 [pool-1-thread-1] ERROR Postbix - Error on DBEnquiry on query=tupinserted on database=Postgresql Error returned is java.lang.IllegalArgumentException: null value for key 'tupinserted'
 2010-12-01 16:09:43,579 [pool-1-thread-1] WARN  Postbix - I'm going to return  for query tupinserted on database=Postgresql
 2010-12-01 16:09:43,580 [pool-1-thread-1] WARN  Postbix - Error while executing ->tupupdated- on database ->Postgresql- Exception received ERROR: column "tup_updated" does not exist
 2010-12-01 16:09:43,580 [pool-1-thread-1] ERROR Postbix - Error on DBEnquiry on query=tupupdated on database=Postgresql Error returned is java.lang.IllegalArgumentException: null value for key 'tupupdated'
 2010-12-01 16:09:43,580 [pool-1-thread-1] WARN  Postbix - I'm going to return  for query tupupdated on database=Postgresql
 2010-12-01 16:09:43,580 [pool-1-thread-1] WARN  Postbix - Error while executing ->tupdeleted- on database ->Postgresql- Exception received ERROR: column "tup_deleted" does not exist
 2010-12-01 16:09:43,581 [pool-1-thread-1] ERROR Postbix - Error on DBEnquiry on query=tupdeleted on database=Postgresql Error returned is java.lang.IllegalArgumentException: null value for key 'tupdeleted'
 2010-12-01 16:09:43,581 [pool-1-thread-1] WARN  Postbix - I'm going to return  for query tupdeleted on database=Postgresql
 2010-12-01 16:09:43,582 [pool-1-thread-1] WARN  Postbix - I'm going to return 0 for query xactcommit on database=Postgresql
 2010-12-01 16:09:43,583 [pool-1-thread-1] WARN  Postbix - I'm going to return 0 for query xactrollback on database=Postgresql
 2010-12-01 16:09:43,585 [pool-1-thread-1] WARN  Postbix - I'm going to return 1 for query exclusivelock on database=Postgresql
 2010-12-01 16:09:43,586 [pool-1-thread-1] WARN  Postbix - I'm going to return 0 for query accessexclusivelock on database=Postgresql
 2010-12-01 16:09:43,586 [pool-1-thread-1] WARN  Postbix - I'm going to return 1 for query accesssharelock on database=Postgresql
 2010-12-01 16:09:43,600 [pool-1-thread-1] WARN  Postbix - I'm going to return 0 for query rowsharelock on database=Postgresql
 2010-12-01 16:09:43,601 [pool-1-thread-1] WARN  Postbix - I'm going to return 0 for query rowexclusivelock on database=Postgresql
 2010-12-01 16:09:43,601 [pool-1-thread-1] WARN  Postbix - I'm going to return 0 for query shareupdateexclusivelock on database=Postgresql
 2010-12-01 16:09:43,602 [pool-1-thread-1] WARN  Postbix - I'm going to return 0 for query sharerowexclusivelock on database=Postgresql
 2010-12-01 16:09:43,603 [pool-1-thread-1] WARN  Postbix - Error while executing ->checkpoints_timed- on database ->Postgresql- Exception received ERROR: relation "pg_stat_bgwriter" does not exist
 2010-12-01 16:09:43,603 [pool-1-thread-1] ERROR Postbix - Error on DBEnquiry on query=checkpoints_timed on database=Postgresql Error returned is java.lang.IllegalArgumentException: null value for key 'checkpoints_timed'
 2010-12-01 16:09:43,603 [pool-1-thread-1] WARN  Postbix - I'm going to return  for query checkpoints_timed on database=Postgresql
 2010-12-01 16:09:43,603 [pool-1-thread-1] WARN  Postbix - Error while executing ->checkpoints_req- on database ->Postgresql- Exception received ERROR: relation "pg_stat_bgwriter" does not exist
 2010-12-01 16:09:43,603 [pool-1-thread-1] ERROR Postbix - Error on DBEnquiry on query=checkpoints_req on database=Postgresql Error returned is java.lang.IllegalArgumentException: null value for key 'checkpoints_req'
 2010-12-01 16:09:43,603 [pool-1-thread-1] WARN  Postbix - I'm going to return  for query checkpoints_req on database=Postgresql
 2010-12-01 16:09:43,604 [pool-1-thread-1] WARN  Postbix - Error while executing ->buffers_checkpoint- on database ->Postgresql- Exception received ERROR: relation "pg_stat_bgwriter" does not exist
 2010-12-01 16:09:43,604 [pool-1-thread-1] ERROR Postbix - Error on DBEnquiry on query=buffers_checkpoint on database=Postgresql Error returned is java.lang.IllegalArgumentException: null value for key 'buffers_checkpoint'
 2010-12-01 16:09:43,604 [pool-1-thread-1] WARN  Postbix - I'm going to return  for query buffers_checkpoint on database=Postgresql
 2010-12-01 16:09:43,604 [pool-1-thread-1] WARN  Postbix - Error while executing ->buffers_clean- on database ->Postgresql- Exception received ERROR: relation "pg_stat_bgwriter" does not exist
 2010-12-01 16:09:43,604 [pool-1-thread-1] ERROR Postbix - Error on DBEnquiry on query=buffers_clean on database=Postgresql Error returned is java.lang.IllegalArgumentException: null value for key 'buffers_clean'
 2010-12-01 16:09:43,605 [pool-1-thread-1] WARN  Postbix - I'm going to return  for query buffers_clean on database=Postgresql
 2010-12-01 16:09:43,605 [pool-1-thread-1] WARN  Postbix - Error while executing ->maxwritten_clean- on database ->Postgresql- Exception received ERROR: relation "pg_stat_bgwriter" does not exist
 2010-12-01 16:09:43,605 [pool-1-thread-1] ERROR Postbix - Error on DBEnquiry on query=maxwritten_clean on database=Postgresql Error returned is java.lang.IllegalArgumentException: null value for key 'maxwritten_clean'
 2010-12-01 16:09:43,605 [pool-1-thread-1] WARN  Postbix - I'm going to return  for query maxwritten_clean on database=Postgresql
 2010-12-01 16:09:43,606 [pool-1-thread-1] WARN  Postbix - Error while executing ->buffers_backend- on database ->Postgresql- Exception received ERROR: relation "pg_stat_bgwriter" does not exist
 2010-12-01 16:09:43,606 [pool-1-thread-1] ERROR Postbix - Error on DBEnquiry on query=buffers_backend on database=Postgresql Error returned is java.lang.IllegalArgumentException: null value for key 'buffers_backend'
 2010-12-01 16:09:43,606 [pool-1-thread-1] WARN  Postbix - I'm going to return  for query buffers_backend on database=Postgresql
 2010-12-01 16:09:43,606 [pool-1-thread-1] WARN  Postbix - Error while executing ->buffers_alloc- on database ->Postgresql- Exception received ERROR: relation "pg_stat_bgwriter" does not exist
 2010-12-01 16:09:43,606 [pool-1-thread-1] ERROR Postbix - Error on DBEnquiry on query=buffers_alloc on database=Postgresql Error returned is java.lang.IllegalArgumentException: null value for key 'buffers_alloc'
 2010-12-01 16:09:43,606 [pool-1-thread-1] WARN  Postbix - I'm going to return  for query buffers_alloc on database=Postgresql
 2010-12-01 16:09:43,629 [pool-1-thread-1] INFO  Postbix - Done with dbJob on database Postgresql QueryList elapsed time 55 m

I don't really now postgresql. So maybe, I should have to modify something (buffers_alloc,pg_stat_bgwriter...) ?

[dalle]

may be that is a trouble of grant of the user used to connect to databases have you done as explained on documentation?

[tof233]

I did the following:

psql -d opennms
opennms=# CREATE USER zabbix;
CREATE ROLE
opennms=# GRANT SELECT ON pg_stat_activity to zabbix;
GRANT
opennms=# GRANT SELECT ON pg_stat_activity to zabbix;
GRANT
opennms=# GRANT SELECT ON pg_database to zabbix;
GRANT
opennms=# GRANT SELECT ON pg_authid to zabbix;
GRANT

But still got the same errors.

[dalle]

I'm pretty much sure that there is a trouble on my documentation, please try so:
GRANT SELECT ON pg_stat_bgwriter to zabbix;
GRANT SELECT ON pg_locks to zabbix;
GRANT SELECT ON pg_stat_database to zabbix;
and let me know

[tof233]

Il y a eu un petit souci avec pg_stat_bgwriter

# psql -d opennms
Welcome to psql 8.1.22, the PostgreSQL interactive terminal.
opennms=# GRANT SELECT ON pg_stat_bgwriter to zabbix;
ERROR:  relation "pg_stat_bgwriter" does not exist
opennms=# GRANT SELECT ON pg_locks to zabbix;
GRANT
opennms=# GRANT SELECT ON pg_stat_database to zabbix;
GRANT
[/QUOTE]

sinon le souci est toujours le même :
[QUOTE] 2010-12-02 14:00:03,128 [main] INFO  Postbix - Connected as zabbix
 2010-12-02 14:00:03,135 [main] INFO  Postbix - --------- on Database -> opennms
 2010-12-02 14:00:03,308 [pool-1-thread-1] WARN  Postbix - I'm going to return 0 for query activeconn on database=Postgresql
 2010-12-02 14:00:03,311 [pool-1-thread-1] WARN  Postbix - Error while executing ->tupfetched- on database ->Postgresql- Exception received ERROR: column "tup_fetched" does not exist
 2010-12-02 14:00:03,311 [pool-1-thread-1] ERROR Postbix - Error on DBEnquiry on query=tupfetched on database=Postgresql Error returned is java.lang.IllegalArgumentException: null value for key 'tupfetched'
 2010-12-02 14:00:03,311 [pool-1-thread-1] WARN  Postbix - I'm going to return  for query tupfetched on database=Postgresql
 2010-12-02 14:00:03,311 [pool-1-thread-1] WARN  Postbix - Error while executing ->tupinserted- on database ->Postgresql- Exception received ERROR: column "tup_inserted" does not exist
 2010-12-02 14:00:03,311 [pool-1-thread-1] ERROR Postbix - Error on DBEnquiry on query=tupinserted on database=Postgresql Error returned is java.lang.IllegalArgumentException: null value for key 'tupinserted'
 2010-12-02 14:00:03,311 [pool-1-thread-1] WARN  Postbix - I'm going to return  for query tupinserted on database=Postgresql
 2010-12-02 14:00:03,312 [pool-1-thread-1] WARN  Postbix - Error while executing ->tupupdated- on database ->Postgresql- Exception received ERROR: column "tup_updated" does not exist
 2010-12-02 14:00:03,312 [pool-1-thread-1] ERROR Postbix - Error on DBEnquiry on query=tupupdated on database=Postgresql Error returned is java.lang.IllegalArgumentException: null value for key 'tupupdated'
 2010-12-02 14:00:03,312 [pool-1-thread-1] WARN  Postbix - I'm going to return  for query tupupdated on database=Postgresql
 2010-12-02 14:00:03,312 [pool-1-thread-1] WARN  Postbix - Error while executing ->tupdeleted- on database ->Postgresql- Exception received ERROR: column "tup_deleted" does not exist
 2010-12-02 14:00:03,313 [pool-1-thread-1] ERROR Postbix - Error on DBEnquiry on query=tupdeleted on database=Postgresql Error returned is java.lang.IllegalArgumentException: null value for key 'tupdeleted'
 2010-12-02 14:00:03,313 [pool-1-thread-1] WARN  Postbix - I'm going to return  for query tupdeleted on database=Postgresql
 2010-12-02 14:00:03,330 [pool-1-thread-1] WARN  Postbix - I'm going to return 0 for query xactcommit on database=Postgresql
 2010-12-02 14:00:03,331 [pool-1-thread-1] WARN  Postbix - I'm going to return 0 for query xactrollback on database=Postgresql
 2010-12-02 14:00:03,385 [pool-1-thread-1] WARN  Postbix - I'm going to return 1 for query exclusivelock on database=Postgresql
 2010-12-02 14:00:03,386 [pool-1-thread-1] WARN  Postbix - I'm going to return 0 for query accessexclusivelock on database=Postgresql
 2010-12-02 14:00:03,388 [pool-1-thread-1] WARN  Postbix - I'm going to return 1 for query accesssharelock on database=Postgresql
 2010-12-02 14:00:03,389 [pool-1-thread-1] WARN  Postbix - I'm going to return 0 for query rowsharelock on database=Postgresql
 2010-12-02 14:00:03,390 [pool-1-thread-1] WARN  Postbix - I'm going to return 0 for query rowexclusivelock on database=Postgresql
 2010-12-02 14:00:03,391 [pool-1-thread-1] WARN  Postbix - I'm going to return 0 for query shareupdateexclusivelock on database=Postgresql
 2010-12-02 14:00:03,392 [pool-1-thread-1] WARN  Postbix - I'm going to return 0 for query sharerowexclusivelock on database=Postgresql
 2010-12-02 14:00:03,393 [pool-1-thread-1] WARN  Postbix - Error while executing ->checkpoints_timed- on database ->Postgresql- Exception received ERROR: relation "pg_stat_bgwriter" does not exist
 2010-12-02 14:00:03,393 [pool-1-thread-1] ERROR Postbix - Error on DBEnquiry on query=checkpoints_timed on database=Postgresql Error returned is java.lang.IllegalArgumentException: null value for key 'checkpoints_timed'
 2010-12-02 14:00:03,393 [pool-1-thread-1] WARN  Postbix - I'm going to return  for query checkpoints_timed on database=Postgresql
 2010-12-02 14:00:03,393 [pool-1-thread-1] WARN  Postbix - Error while executing ->checkpoints_req- on database ->Postgresql- Exception received ERROR: relation "pg_stat_bgwriter" does not exist
 2010-12-02 14:00:03,394 [pool-1-thread-1] ERROR Postbix - Error on DBEnquiry on query=checkpoints_req on database=Postgresql Error returned is java.lang.IllegalArgumentException: null value for key 'checkpoints_req'
 2010-12-02 14:00:03,394 [pool-1-thread-1] WARN  Postbix - I'm going to return  for query checkpoints_req on database=Postgresql
 2010-12-02 14:00:03,395 [pool-1-thread-1] WARN  Postbix - Error while executing ->buffers_checkpoint- on database ->Postgresql- Exception received ERROR: relation "pg_stat_bgwriter" does not exist
 2010-12-02 14:00:03,395 [pool-1-thread-1] ERROR Postbix - Error on DBEnquiry on query=buffers_checkpoint on database=Postgresql Error returned is java.lang.IllegalArgumentException: null value for key 'buffers_checkpoint'
 2010-12-02 14:00:03,395 [pool-1-thread-1] WARN  Postbix - I'm going to return  for query buffers_checkpoint on database=Postgresql
 2010-12-02 14:00:03,395 [pool-1-thread-1] WARN  Postbix - Error while executing ->buffers_clean- on database ->Postgresql- Exception received ERROR: relation "pg_stat_bgwriter" does not exist
 2010-12-02 14:00:03,396 [pool-1-thread-1] ERROR Postbix - Error on DBEnquiry on query=buffers_clean on database=Postgresql Error returned is java.lang.IllegalArgumentException: null value for key 'buffers_clean'
 2010-12-02 14:00:03,396 [pool-1-thread-1] WARN  Postbix - I'm going to return  for query buffers_clean on database=Postgresql
 2010-12-02 14:00:03,396 [pool-1-thread-1] WARN  Postbix - Error while executing ->maxwritten_clean- on database ->Postgresql- Exception received ERROR: relation "pg_stat_bgwriter" does not exist
 2010-12-02 14:00:03,396 [pool-1-thread-1] ERROR Postbix - Error on DBEnquiry on query=maxwritten_clean on database=Postgresql Error returned is java.lang.IllegalArgumentException: null value for key 'maxwritten_clean'
 2010-12-02 14:00:03,397 [pool-1-thread-1] WARN  Postbix - I'm going to return  for query maxwritten_clean on database=Postgresql
 2010-12-02 14:00:03,397 [pool-1-thread-1] WARN  Postbix - Error while executing ->buffers_backend- on database ->Postgresql- Exception received ERROR: relation "pg_stat_bgwriter" does not exist
 2010-12-02 14:00:03,397 [pool-1-thread-1] ERROR Postbix - Error on DBEnquiry on query=buffers_backend on database=Postgresql Error returned is java.lang.IllegalArgumentException: null value for key 'buffers_backend'
 2010-12-02 14:00:03,397 [pool-1-thread-1] WARN  Postbix - I'm going to return  for query buffers_backend on database=Postgresql
 2010-12-02 14:00:03,398 [pool-1-thread-1] WARN  Postbix - Error while executing ->buffers_alloc- on database ->Postgresql- Exception received ERROR: relation "pg_stat_bgwriter" does not exist
 2010-12-02 14:00:03,398 [pool-1-thread-1] ERROR Postbix - Error on DBEnquiry on query=buffers_alloc on database=Postgresql Error returned is java.lang.IllegalArgumentException: null value for key 'buffers_alloc'
 2010-12-02 14:00:03,398 [pool-1-thread-1] WARN  Postbix - I'm going to return  for query buffers_alloc on database=Postgresql
 2010-12-02 14:00:03,443 [pool-1-thread-1] INFO  Postbix - Done with dbJob on database Postgresql QueryList elapsed time 237 ms

Je pense pouvoir tester sur une autre BDD cet aprèm. J te dirais si ça va mieux.

Merci pour ton aide

[dalle]

Il y a eu un petit souci avec pg_stat_bgwriter



sinon le souci est toujours le même :


Je pense pouvoir tester sur une autre BDD cet aprèm. J te dirais si ça va mieux.

Merci pour ton aide

try with this it's the mine on production it's the same just has a different logging level that better in such a way

[tof233]

Here is the output:

2010-12-02 14:21:15,259 [main] INFO  Postbix - --------- on Database -> opennms
 2010-12-02 14:21:15,384 [pool-1-thread-1] WARN  Postbix - Error while executing ->tupfetched- on database ->Postgresql- Exception received ERROR: column "tup_fetched" does not exist
 2010-12-02 14:21:15,385 [pool-1-thread-1] ERROR Postbix - Error on DBEnquiry on query=tupfetched on database=Postgresql Error returned is java.lang.IllegalArgumentException: null value for key 'tupfetched'
 2010-12-02 14:21:15,385 [pool-1-thread-1] WARN  Postbix - Error while executing ->tupinserted- on database ->Postgresql- Exception received ERROR: column "tup_inserted" does not exist
 2010-12-02 14:21:15,385 [pool-1-thread-1] ERROR Postbix - Error on DBEnquiry on query=tupinserted on database=Postgresql Error returned is java.lang.IllegalArgumentException: null value for key 'tupinserted'
 2010-12-02 14:21:15,386 [pool-1-thread-1] WARN  Postbix - Error while executing ->tupupdated- on database ->Postgresql- Exception received ERROR: column "tup_updated" does not exist
 2010-12-02 14:21:15,386 [pool-1-thread-1] ERROR Postbix - Error on DBEnquiry on query=tupupdated on database=Postgresql Error returned is java.lang.IllegalArgumentException: null value for key 'tupupdated'
 2010-12-02 14:21:15,386 [pool-1-thread-1] WARN  Postbix - Error while executing ->tupdeleted- on database ->Postgresql- Exception received ERROR: column "tup_deleted" does not exist
 2010-12-02 14:21:15,386 [pool-1-thread-1] ERROR Postbix - Error on DBEnquiry on query=tupdeleted on database=Postgresql Error returned is java.lang.IllegalArgumentException: null value for key 'tupdeleted'
 2010-12-02 14:21:15,408 [pool-1-thread-1] WARN  Postbix - Error while executing ->checkpoints_timed- on database ->Postgresql- Exception received ERROR: relation "pg_stat_bgwriter" does not exist
 2010-12-02 14:21:15,409 [pool-1-thread-1] ERROR Postbix - Error on DBEnquiry on query=checkpoints_timed on database=Postgresql Error returned is java.lang.IllegalArgumentException: null value for key 'checkpoints_timed'
 2010-12-02 14:21:15,409 [pool-1-thread-1] WARN  Postbix - Error while executing ->checkpoints_req- on database ->Postgresql- Exception received ERROR: relation "pg_stat_bgwriter" does not exist
 2010-12-02 14:21:15,409 [pool-1-thread-1] ERROR Postbix - Error on DBEnquiry on query=checkpoints_req on database=Postgresql Error returned is java.lang.IllegalArgumentException: null value for key 'checkpoints_req'
 2010-12-02 14:21:15,410 [pool-1-thread-1] WARN  Postbix - Error while executing ->buffers_checkpoint- on database ->Postgresql- Exception received ERROR: relation "pg_stat_bgwriter" does not exist
 2010-12-02 14:21:15,410 [pool-1-thread-1] ERROR Postbix - Error on DBEnquiry on query=buffers_checkpoint on database=Postgresql Error returned is java.lang.IllegalArgumentException: null value for key 'buffers_checkpoint'
 2010-12-02 14:21:15,410 [pool-1-thread-1] WARN  Postbix - Error while executing ->buffers_clean- on database ->Postgresql- Exception received ERROR: relation "pg_stat_bgwriter" does not exist
 2010-12-02 14:21:15,410 [pool-1-thread-1] ERROR Postbix - Error on DBEnquiry on query=buffers_clean on database=Postgresql Error returned is java.lang.IllegalArgumentException: null value for key 'buffers_clean'
 2010-12-02 14:21:15,411 [pool-1-thread-1] WARN  Postbix - Error while executing ->maxwritten_clean- on database ->Postgresql- Exception received ERROR: relation "pg_stat_bgwriter" does not exist
 2010-12-02 14:21:15,411 [pool-1-thread-1] ERROR Postbix - Error on DBEnquiry on query=maxwritten_clean on database=Postgresql Error returned is java.lang.IllegalArgumentException: null value for key 'maxwritten_clean'
 2010-12-02 14:21:15,411 [pool-1-thread-1] WARN  Postbix - Error while executing ->buffers_backend- on database ->Postgresql- Exception received ERROR: relation "pg_stat_bgwriter" does not exist
 2010-12-02 14:21:15,412 [pool-1-thread-1] ERROR Postbix - Error on DBEnquiry on query=buffers_backend on database=Postgresql Error returned is java.lang.IllegalArgumentException: null value for key 'buffers_backend'
 2010-12-02 14:21:15,412 [pool-1-thread-1] WARN  Postbix - Error while executing ->buffers_alloc- on database ->Postgresql- Exception received ERROR: relation "pg_stat_bgwriter" does not exist
 2010-12-02 14:21:15,412 [pool-1-thread-1] ERROR Postbix - Error on DBEnquiry on query=buffers_alloc on database=Postgresql Error returned is java.lang.IllegalArgumentException: null value for key 'buffers_alloc'
 2010-12-02 14:21:15,441 [pool-1-thread-1] INFO  Postbix - Done with dbJob on database Postgresql QueryList elapsed time 79 ms