[Pgpool-general] replicate_def_pgbench.sql
Addison Pan
addisonp at yahoo.com
Tue Mar 25 21:59:14 UTC 2008
When i do the command
psql -f replicate_def_pgbench.sql -p 5432 pgpool
I get the following errors
psql:/usr/share/postgresql-pgpool-II/replicate_def_pgbench.sql:7 ERROR: relation "pgpool_catalog.replicate_def" does not exist
psql:/usr/share/postgresql-pgpool-II/replicate_def_pgbench.sql:15: ERROR: column "col_name" is of type text but expression is of type text[]
here's a copy of the script that I'm using (I believe it matches up to the tutorial page on pgpool)
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)']
);
-Addison
---------------------------------
Looking for last minute shopping deals? Find them fast with Yahoo! Search.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/pgpool-general/attachments/20080325/e85c75d1/attachment.html
More information about the Pgpool-general
mailing list