[Pgpool-general] Partitioning and an error

[Jopes Gallardo]

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/pgpool-general/attachments/20081104/c7031281/attachment-0001.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool.conf
Type: application/octet-stream
Size: 4799 bytes
Desc: not available
Url : http://pgfoundry.org/pipermail/pgpool-general/attachments/20081104/c7031281/attachment-0001.obj