[Pgpool-general] pgpool-II 2.2 beta2 released

[Jaume Sabater]

On Sat, Feb 7, 2009 at 3:45 PM, Tatsuo Ishii <ishii at sraoss.co.jp> 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"
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool.conf.gz
Type: application/x-gzip
Size: 2312 bytes
Desc: not available
Url : http://pgfoundry.org/pipermail/pgpool-general/attachments/20090210/df5b9c1f/attachment.bin