update:
1. modified the replicate_def_pgbench.sql so that replicate_def becomes dist_def
result of replicate_def_pgbench.sql run:
ERROR: column "col_name" is of type text but expression is of type text[]
did a check of the pgpool_catalog.dist_def and saw that there was data put in:
bench_parallel | public | branches
bench_parallel | public | tellers
question:
1. so does that mean the insert worked from the replicate_def_pgbench.sql ?
2. I tested out data from the tutorial page
http://pgpool.projects.postgresql.org/tutorial-en.html
and completed going through the tutorial. And did a check via the shell script
shown at the end of the tutorial page, it all seemed well. So what affect did
the error in the replicate_def_pgbench.sql statement have?
Thanks
Addison Pan <[EMAIL PROTECTED]> wrote: 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._______________________________________________
Pgpool-general mailing list
[email protected]
http://pgfoundry.org/mailman/listinfo/pgpool-general
---------------------------------
Looking for last minute shopping deals? Find them fast with Yahoo! Search._______________________________________________
Pgpool-general mailing list
[email protected]
http://pgfoundry.org/mailman/listinfo/pgpool-general
