You should not connect to PostgreSQL on dev1 directly. You always need to connect via pgpool. -- Tatsuo Ishii SRA OSS, Inc. Japan
> 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 [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
