Postgres Pro
Downloads
Home   >   mailing lists

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

From Patil, Smita (NSN - IN/Bangalore)
Subject Synch Replication - Synch rep 0114
Date
Msg-id F475619F97187B4182AC489DBD03D52B04C5F45D@inbhexc001.nsn-intra.net
Whole thread Raw
Responses Re: Synch Replication - Synch rep 0114  (Fujii Masao <masao.fujii@gmail.com>)
List pgsql-hackers
Tree view
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 the setup.
As per wiki, I am able to bring up the walsender and the walreceiver process in a single server as well when primary and seconday are setup on different nodes(making necessary changes to the test script)
 
Then I am able to see the walsender and 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 following output :
Standby 6820 FATAL:  unexpected EOF on replication connection: lost synchronization with server: got message type "c", length -805175295
 
Primary 6821 LOG:  unexpected EOF on replication connection
Primary 6821 LOG:  replication done at: write 0/1000000 (file 000000010000000000000000), flush 0/1000000 (file 000000010000000000000000)
Standby 6820 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 (PID 6812) was terminated by signal 6: Aborted
Standby 6809 LOG:  aborting startup due to startup process failure
INSERT 0 1
After this, I see both walsender and walreceiver are down and writer process is still running.
Is this because, there is 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 walreceiver process.
But atleast read transactions( records inserted in primary ) are not getting reflected in the standby node.
 
In such cases I would like to know about what exact features are working with this patch?
Because, in the Readme section 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), Am getting compilation errors.
Please let me about the correct status of the Synch Replication about what features are working properly.
 
Regards,
Smita Patil

 
Attachment

pgsql-hackers by date:

Previous
From: smitap3
Date:
Subject: Synch Replication - Synch rep 0114
Next
From: Fujii Masao
Date:
Subject: Re: Synch Replication - Synch rep 0114