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

[Praveen]

Hi Tatsuo Ishii,

Thanks for u r response,

So the pgpool-II (3.0.3) is not supported in master to master
replication.So can u please suggest me which is the best for master to
master replication method.

AND also i am attaching pgpool.log file it give following eror:

bind() failed. reason: Address already in use

On 5/4/11, Tatsuo Ishii <ishii at sraoss.co.jp> wrote:
>> 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
>


-- 
Best Regards,
Praveen
-------------- next part --------------
A non-text attachment was scrubbed...
Name: phpbCTdsh
Type: application/octet-stream
Size: 9470 bytes
Desc: not available
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20110504/4032d00a/attachment.obj>