Hello. I'm a newbie in using PGPool as a partitioning solution for PostgreSQL. I saw that PGPool might be the best solution for my needs.
I already set things up, and made things work with regards to partitioning data. Is there an option to both partition and replicate tables at the same time? For example, I want to replicate my users table across all nodes but have their corresponding "education_bgs" on allocated tables, say, the rule is I should return as node id the value of (user_id % 3), at the same time, having the "blogs" and "comments" table partitioned with node id equal to (blog_id % 3, comments table also has blog_id as foreign key). I followed the pg_bench example in the site's README, and I wanted to replicate branches and tellers in all nodes, while accounts and history are partitioned by the column aid. I already set load_balance_mode, replication_mode, and parallel_mode to true. I also had my dist_def and replicate_def set up (branches and tellers in replicate_def, and accounts and history under dist_def with aid being the column specifying the partition). I ran pgbench and I get this error: ERROR: pgpool2 sql restriction DETAIL: cannot find dist_def table info I tried creating the dist_def definitions for branches and tellers (this time, everything is partitioned by bid, the branch id), and apparently, it did partition the data. It seems to me that I'm being forced to partition everything, and replicate doesn't seem to be noticed. Is there anything missing from what I'm doing so far? My PGPool II setup comes from the Ubuntu Repository, Hardy Heron LTS, and it's version 1.3 (sohiboshi). I'm trying out installing from source, but if this is the case, i might as well switch to a much easier setup, which is MySQL federation :( I love PostgreSQL and I guess having this roadblock off my way would be greatly appreciated. Hope you guys help me out on this. I'm also attaching my pgpool.conf, just in case.
pgpool.conf
Description: Binary data
_______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
