[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