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: