Synch Replication - Synch rep 0114 - Mailing list pgsql-hackers

From smitap3
Subject Synch Replication - Synch rep 0114
Date
Msg-id 21745603.post@talk.nabble.com
Whole thread Raw
List pgsql-hackers
Hi, I have been testing in recent, the Synch Replication(Synch rep 0114 (Jan 14, 2009) ) on PostgreSQL version 8.4
(postgresql-8.4devel_20081229.tar.bz2)I followed the steps in Readme as well used the test script provided in patch for
thesetup. As per wiki, I am able to bring up the walsender and the walreceiver process in a single server as well when
primaryand seconday are setup on different nodes(making necessary changes to the test script) Then I am able to see the
walsenderand walreceiver process are in progress. Then I try to insert some records into the table created (within the
script)as below: ./psql psql (8.4devel) Type "help" for help. postgres=# insert into temp values(5,'e'); I get the
followingoutput : Standby 6820 FATAL: unexpected EOF on replication connection: lost synchronization with server: got
messagetype "c", length -805175295 Primary 6821 LOG: unexpected EOF on replication connection Primary 6821 LOG:
replicationdone at: write 0/1000000 (file 000000010000000000000000), flush 0/1000000 (file 000000010000000000000000)
Standby6820 LOG: replication done at: write 0/1000000 (file 000000010000000000000000), flush 0/1000000 (file
000000010000000000000000)Standby 6812 LOG: could not open file "pg_xlog/000000010000000000000001" (log file 0, segment
1):No such file or directory Standby 6812 LOG: redo done at 0/4A983C Standby 6812 PANIC: could not open file
"pg_xlog/000000010000000000000000"(log file 0, segment 0): No such file or directory Standby 6809 LOG: startup process
(PID6812) was terminated by signal 6: Aborted Standby 6809 LOG: aborting startup due to startup process failure INSERT
01 After this, I see both walsender and walreceiver are down and writer process is still running. Is this because,
thereis no provision of replication between primary and secondary? Or is it because write transactions are not
supported?In case where primary and standby are run on two different nodes, I am able to bring up the walsender and
walreceiverprocess. But atleast read transactions( records inserted in primary ) are not getting reflected in the
standbynode. In such cases I would like to know about what exact features are working with this patch? Because, in the
Readmesection of Synch Replication wiki, it is mentioned to check whether the walsender and walreceiver process are in
progress.How about replication and read - write transactions? Also with the latest patch Synch rep 0128 (Jan 28, 2009),
Amgetting compilation errors. Please let me about the correct status of the Synch Replication about what features are
workingproperly. Regards, Smita Patil <br /><hr align="left" width="300" /> View this message in context: <a
href="http://www.nabble.com/Synch-Replication---Synch-rep-0114-tp21745603p21745603.html">SynchReplication - Synch rep
0114</a><br/> Sent from the <a href="http://www.nabble.com/PostgreSQL---hackers-f780.html">PostgreSQL - hackers mailing
listarchive</a> at Nabble.com.<br /> 

pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Hot standby, recovery infra
Next
From: smitap3
Date:
Subject: Synch Replication - Synch rep 0114