[Pgpool-general] Pgpool-II - replication problems

[nir osovsky]

Hi Tatsuo,

Please help.

Thanks,
Nir

On Thu, Nov 13, 2008 at 12:28 AM, nir osovsky <nosovsky1 at gmail.com> wrote:

> Thank you, Tstuso,
> I was able to download and install the new tar.
>
> Test 1:
> =====
> The following command is now *working* and both databases updated with the
> new insert.
> psql -p 9999 -c "INSERT INTO branches  VALUES (7,5,'yesh')" -d
> bench_replication
>
> Test 2:
> =====
> The following command is working on Dev1 only but the new insert is *not
> replicate* to Dev2:
> psql -h dev1 bench_replication postgres
> bench_replication=# insert into branches values (9,4,'test');
>
> How can I make it work automatically, meaning every time an
> insert,update,delete occurs in Dev1 it will replicate the same to Dev2?
>
> Thanks,
> Nir
>
>
> On Wed, Nov 12, 2008 at 5:49 AM, Tatsuo Ishii <ishii at sraoss.co.jp> wrote:
>
>> Thanks. I think I have figured out what's going on. pgpool tries to
>> start a new transaction if DML (for example INSERT) is sent. The
>> particular setting you use with PostgreSQL generates lots of DEBUG and
>> NOTICE messages while processing BEGIN and they make pgpool
>> confused. I have committed a fix for this. The new tar ball was put on
>> the same location as before. Can you please grab and try it again?
>> --
>> Tatsuo Ishii
>> SRA OSS, Inc. Japan
>>
>> > Postgresql.conf it attached
>> >
>> > Thank You!
>> >
>> > Nir
>> >
>> > On Wed, Nov 12, 2008 at 12:51 AM, Tatsuo Ishii <ishii at sraoss.co.jp>
>> wrote:
>> >
>> > > Thanks for the feedback. Could you show me postgresql.conf?
>> > > --
>> > > Tatsuo Ishii
>> > > SRA OSS, Inc. Japan
>> > >
>> > > > Hi Tatsuo,
>> > > >
>> > > > THANK YOU!
>> > > > I was able to download the file, and install it (configure, make &
>> make
>> > > > install).
>> > > >
>> > > > I run the command again and here are the log file you asked for:
>> > > >
>> > > >  psql -p 9999 -c "INSERT INTO branches  VALUES (3,1,' ')"
>> > > > ============================================
>> > > > DEBUG:  InitPostgres
>> > > > DEBUG:  StartTransaction
>> > > > DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR,
>> > > > xid/subid/cid: 28279195/1/0, nestlvl: 1, children: <>
>> > > > DEBUG:  CommitTransaction
>> > > > DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR,
>> > > > xid/subid/cid: 28279195/1/0, nestlvl: 1, children: <>
>> > > > server closed the connection unexpectedly
>> > > >         This probably means the server terminated abnormally
>> > > >         before or while processing the request.
>> > > > connection to server was lost
>> > > >
>> > >
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/pgpool-general/attachments/20081113/df023851/attachment.html