[Pgpool-general] Pgpool-II - replication problems

[nir osovsky]

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/e8e66a9d/attachment.html