[HACKERS] Synch Replication: Synchronization of files between Primary & Standby

Hi, Starting a new thread related to synchronization of the data files, WAL etc.. between Primary and standby servers in Synchronous replication patch. Use case: Whenever the primary and standby are out of sync due to network problems. Existing handling is to prepare the standby by 1) Deleting

Re: [HACKERS] Synch Replication

hi, [I am working in the same team as Niranjan] Niranjan wrote: > > 3) Do you have test programs that can used > > for synchronous replication testing? > > No, I've not used the automated test program. Yeah, since > it's very useful, I'll make it before long. > > > 4) I'am thinking of trying

Re: [HACKERS] Synch Replication

Hi, Thanks for the comments! On Fri, Feb 13, 2009 at 5:00 AM, Alvaro Herrera wrote: > Fujii Masao escribió: > > I noticed two very minor issues while reading your docs: > >>This is because WAL files generated in the primary server before this >> built-in >>replication starts hav

Re: [HACKERS] Synch Replication

Fujii Masao escribió: I noticed two very minor issues while reading your docs: >This is because WAL files generated in the primary server before this > built-in >replication starts have to be transferred to the standby server by >using file-based log shipping. When CLASS

Re: [HACKERS] Synch Replication

Hi, Thanks. Now it works. Few questions: 1) Do you have an idea by when the Hot standby patch and Sync replication patch will be integrated? 2) I have used 1 physical machine to try current patch of synchronous replication. Is it OK for me to try with 2 separate machines for Primary & Standby ser

Re: [HACKERS] Synch Replication

Hi Niranjan, On Mon, Feb 9, 2009 at 10:39 PM, K, Niranjan (NSN - IN/Bangalore) wrote: > But after I login to replication database (note the active I had brought > it down earlier & created a finish.trigger), I still cannot see the > table that was created on the primary. > Also please note that t

Re: [HACKERS] Synch Replication

Hi Niranjan, On Mon, Feb 9, 2009 at 6:58 PM, K, Niranjan (NSN - IN/Bangalore) wrote: >> 1) pg_ctl -D /home/postgres/postgresHSB/actdata stop >> 2) touch /home/postgres/postgresHSB/finish.trigger > > Yes. This the procedure that I followed. I have attached the relevant > logs. > "change_standby_mo

Re: [HACKERS] Synch Replication

Hi Niranjan, Thanks very much! On Mon, Feb 9, 2009 at 3:08 PM, K, Niranjan (NSN - IN/Bangalore) wrote: > Now, the active and standby database are up & running even after the > execution of the SQL (create table). What was the problem? The problem is that 1-byte variable was assigned the value c

Re: [HACKERS] Synch Replication

Hi Niranjan, On Fri, Feb 6, 2009 at 10:17 PM, K, Niranjan (NSN - IN/Bangalore) wrote: > > Hi, > >> * server log >> * /sbydata/walreceiver_trace.out >> * tcpdump -i lo -n tcp >> > Please refer attachments. Please try the updated synch-rep, which probably fixes the problem, I hope. If the same tro

Re: [HACKERS] Synch Replication

Hi Niranjan, On Fri, Feb 6, 2009 at 6:46 PM, K, Niranjan (NSN - IN/Bangalore) wrote: > Hi, > >> Please retry new synch-rep code and report the following information. >> >> * server log >> * /sbydata/walreceiver_trace.out >> * tcpdump -i lo -n tcp >> > > Refer attachments. I'm afraid that the mes

Re: [HACKERS] Synch Replication

Hi, On Fri, Feb 6, 2009 at 2:14 PM, K, Niranjan (NSN - IN/Bangalore) wrote: > Hi, > >> * server log >> * walreceiver_trace.out >> * netstat -nap (before and after replication crashes) >> * tcpdump -i lo -n tcp >> > In addition to the requested logs, I have provided the network interface > informa

Re: [HACKERS] Synch Replication

Hi Niranjan, On Thu, Feb 5, 2009 at 10:50 PM, K, Niranjan (NSN - IN/Bangalore) wrote: >> I changed the code to dump all messages for replication, so >> please try it and report the result. The messages which the >> standby server receives are logged in the file (*1). Please >> send also that file

Re: [HACKERS] Synch Replication

Hi Niranjan, On Thu, Feb 5, 2009 at 3:34 PM, K, Niranjan (NSN - IN/Bangalore) wrote: >>I added the further logging codes >> into the patch, and uploaded the source. If you have time, >> please try it and report the results. > > Refer attached logs. Thanks, but I have not identified the cause yet

Re: [HACKERS] Synch Replication

Hi Niranjan, On Wed, Feb 4, 2009 at 6:21 PM, K, Niranjan (NSN - IN/Bangalore) wrote: > >> - Do you use a packet filtering software (eg. firewall)? >> If yes, what happens if you disabled such a software? > Firewall was disabled > >> - Do you use SELinux? >> If yes, what happens if you disable

Re: [HACKERS] Synch Replication

> - Do you use a packet filtering software (eg. firewall)? > If yes, what happens if you disabled such a software? Firewall was disabled > - Do you use SELinux? > If yes, what happens if you disabled SELinux? SELinux is disabled. > - Please run the following commands and report those result

Re: [HACKERS] Synch Replication

Hi, Thanks for the response. I tried with the your sources and found the same issue. I explain the steps that I followed, just to avoid any gaps in understanding. 1) I assumes that the patch was already applied in your sources. So did went ahead doing "configure", "make" and "make install" 2) Bui

Re: [HACKERS] Synch Replication

Hi, On Wed, Feb 4, 2009 at 4:17 PM, K, Niranjan (NSN - IN/Bangalore) wrote: > Thanks for the response. > I tried with the your sources and found the same issue. Thanks for the retesting! > Could you please help. If you need any more symptoms, I can re-work. May I ask you some questions? - Do

Re: [HACKERS] Synch Replication

Hi, Ooops, my mail client has sent the previous message, on the way. Sorry. On Wed, Feb 4, 2009 at 10:24 AM, Fujii Masao wrote: > Hi, > > Thanks for your testing and report! > > On Tue, Feb 3, 2009 at 8:18 PM, K, Niranjan (NSN - IN/Bangalore) > wrote: >> Hi, >> >> I tried using the Synchronous

Re: [HACKERS] Synch Replication

Hi, Thanks for your testing and report! On Tue, Feb 3, 2009 at 8:18 PM, K, Niranjan (NSN - IN/Bangalore) wrote: > Hi, > > I tried using the Synchronous replication and I'am unable to replicate > the queries (Ex. create table temp1(int int);). > > I have downloaded the latest postgres dev snapsho

Re: [HACKERS] Synch Replication - Synch rep 0114

Hi, On Fri, Jan 30, 2009 at 8:05 PM, Patil, Smita (NSN - IN/Bangalore) wrote: > 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) Thanks for your testing and report! I'm afraid that th

[HACKERS] Synch Replication - Synch rep 0114

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 )

[HACKERS] Synch Replication - Synch rep 0114

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 an

[HACKERS] Synch Replication - Synch rep 0114

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 an