Migration 2.0.4 with partitionned table on postgres

[tid008]

Hello,

just a question , i am preparing the migration of zabbix in version 2.

Were are working with a postgres 9.1.3 database which is partitionned on table history and history_uint

I'll migrate directly from 1.8.13 to 2.0.4.

I am actaulling doing the tests but i have seen in a forum this comment :
" Comment from jbayer
Time October 16, 2012 at 7:17 pm

Thank you.

Unfortunately, the Zabbix 2.0 database is using relational integrity, which doesn’t work with partitions. So the choice is to remove the relations, or not use partitioning.

The Zabbix team implement foreign keys, which MySql doesn’t support in partitioning."

so , i am jsut wondering if partitionned table are supported in 2.0 with postgres.

Thanks for any response on this subject.

regards

Thierry

[BDiE8VNy]

Works very well.

Started from scratch with release 2.0.2 and without inherited tables.
Later I renamed the tables I want to be partitioned, created the necessary (inherited) tables and finally SELECT the data from renamed tables into the new master table without any issues.

My Environment:
CentOS-6
PostgreSQL 9.1.4