Hi Tatsuo, Please help.
Thanks, Nir On Thu, Nov 13, 2008 at 12:28 AM, nir osovsky <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> >> 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 >> > > > >> > > >> > >
_______________________________________________ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general