[Pgpool-general] Missing sample/replicate_def_pgbench.sql file

[Yoshiyuki Asaba]

Hi,

From: calimlimvl at nationalbookstore.com.ph
Subject: [Pgpool-general] Missing sample/replicate_def_pgbench.sql file
Date: Wed, 9 Apr 2008 14:03:42 +0800 (PHT)

> Is it just me or is it really missing? I downloaded pgpool-II 2.1beta1 and
> 2.0.1, all of them did not include replicate_def_pgbench.sql (as per the
> tutorial). Please enlighten me on this. Thank you.

Sorry, I did not include replicate_def_pgbench.sql. I've fixed.
Please use the attached file.

Regards,
--
Yoshiyuki Asaba
y-asaba at sraoss.co.jp
-------------- next part --------------
-- $Header: /cvsroot/pgpool/pgpool-II/sample/replicate_def_pgbench.sql,v 1.1 2007/11/09 06:09:36 y-mori Exp $

INSERT INTO pgpool_catalog.replicate_def VALUES (
    'bench_parallel',
    'public',
    'branches',
    ARRAY['bid', 'bbalance', 'filler'],
    ARRAY['integer', 'integer', 'character(88)']
);

INSERT INTO pgpool_catalog.dist_def VALUES (
    'bench_parallel',
    'public',
    'tellers',
    ARRAY['tid', 'bid', 'tbalance', 'filler'],
    ARRAY['integer', 'integer', 'integer', 'character(84)']
);