On Sat, Feb 7, 2009 at 3:45 PM, Tatsuo Ishii <[email protected]> wrote:
> pgpool-II 2.2 beta2 released. Changes from beta1: Hi, Tatsuo. Here are you are my first bug report to beta2 version (the "vanilla" one taken from the downloads section in pgFoundry). I set up the cluster with load balance and replication. Then I tried to create a database remotely with the following command: createdb -h 10.0.3.75 -p 9999 -U pgpool2 bench_replication This is the syslog in the master node: 2009-02-10 17:12:02 CET ERROR: CREATE DATABASE cannot run inside a transaction block 2009-02-10 17:12:02 CET STATEMENT: CREATE DATABASE bench_replication; And this is the syslog in the slave node: 2009-02-10 17:12:02 CET ERROR: syntax error at or near "send" at character 1 2009-02-10 17:12:02 CET STATEMENT: send invalid query from pgpool to abort transaction This was on Debian Lenny with PostgreSQL 8.3.5-1. Shall you need any more information, please let me know. See the attached pgpool.conf file for reference. P.S. To be honest, I cannot remember whether, with version 2.1, I created the databases on each node first or whether I did that through pgpool2, although I think it was the latter. -- Jaume Sabater http://linuxsilo.net/ "Ubi sapientas ibi libertas"
pgpool.conf.gz
Description: GNU Zip compressed data
_______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
