Hi Jaume, Actually Lukasz reported that and Tatsuo provided a patch for it yesterday at 4:22AM email.
I actually just changed the pool_process_query.c file on beta2 to comment out the two lines with T_CreatedbStmt and also T_DropdbStmt since the same goes for droping a DB and then created some etch pkgs for it. I tried out CREATE and DROP DB and wokred ok after that. Marcelo PostgreSQL DBA Linux/Solaris System Administrator On Feb 10, 2009, at 10:19 AM, Jaume Sabater wrote: > 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>_______________________________________________ > Pgpool-general mailing list > [email protected] > http://pgfoundry.org/mailman/listinfo/pgpool-general _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
