[Pgpool-general] Using pgpool port is unable to create database in backend

Tatsuo Ishii ishii at sraoss.co.jp
Wed May 4 06:02:35 UTC 2011


> Hi,
> 
> 1)	Is Pgpool-2 support multi-master replication method  ?

No.

> 2)	I am not able to create Database in backend servers through
> pgpool(replication is not working).

So you mix Linux PostgreSQL 8.4 and Windows PostgreSQL 9.0? You should
not do it.  Please use same PostgreSQL version and platform as
pgpool-II backend.  Also pgpool 1.3 is pretty old. Please use the
latest version (3.0.3).
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> My server info is,
> OS: Debian
> DB: Postgres 8.4
> PgPool 1.3
> if i create Database in server using below command,
> root at debian:~# createdb testdb -h 127.0.0.1 -p 4656 -U praveen2
> 
> it will created in only server not in the backend server(slave).
> I am using below port no,
> # Port number for pgpool
> port = 4656
> and
> postgres port is 5432
> 
> Backend machine information is,
> OS: Windows XP
> DB: Postgres 9.0
> in backend postgres port is 5432
> 
> Please do let me know.I am in very critical situation...Help Me
> 
> Best Regards,
> Praveen M


More information about the Pgpool-general mailing list