[HACKERS] Review of Synchronous Replication patches

2010-08-04 Thread Kolb, Harald (NSN - DE/Munich)
Hi, After setting up a real SR cluster based on V9 beta3 and Fuji's SR patch synch_rep_0722.patch and doing some simple update_and_check tests, it seems that active and standby are not in sync. Can this be a problem of the SR or the HSB feature ? Or is fsync still not supported ? Used

Re: [HACKERS] postmaster recovery and automatic restart suppression

2009-06-15 Thread Kolb, Harald (NSN - DE/Munich)
Hi -Original Message- From: ext Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: Tuesday, June 09, 2009 9:20 PM To: Kolb, Harald (NSN - DE/Munich) Cc: Robert Haas; Greg Stark; Simon Riggs; Fujii Masao; pgsql-hackers@postgresql.org; Czichy, Thoralf (NSN - FI/Helsinki) Subject: Re

Re: [HACKERS] postmaster recovery and automatic restart suppression

2009-06-09 Thread Kolb, Harald (NSN - DE/Munich)
Hi, -Original Message- From: ext Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: Tuesday, June 09, 2009 1:35 AM To: Robert Haas Cc: Greg Stark; Simon Riggs; Fujii Masao; Kolb, Harald (NSN - DE/Munich); pgsql-hackers@postgresql.org; Czichy, Thoralf (NSN - FI/Helsinki) Subject: Re

Re: [HACKERS] postmaster recovery and automatic restart suppression

2009-06-05 Thread Kolb, Harald (NSN - DE/Munich)
Hi, -Original Message- From: ext Fujii Masao [mailto:masao.fu...@gmail.com] Sent: Friday, June 05, 2009 8:14 AM To: Kolb, Harald (NSN - DE/Munich) Cc: pgsql-hackers@postgresql.org Subject: Re: [HACKERS] postmaster recovery and automatic restart suppression Hi, On Fri, Jun

Re: [HACKERS] Synchronous replication: status of standby side

2009-06-05 Thread Kolb, Harald (NSN - DE/Munich)
Hi, -Original Message- From: ext Fujii Masao [mailto:masao.fu...@gmail.com] Sent: Friday, June 05, 2009 9:19 AM To: Kolb, Harald (NSN - DE/Munich) Cc: pgsql-hackers@postgresql.org; Czichy, Thoralf (NSN - FI/Helsinki) Subject: Re: [HACKERS] Synchronous replication: status

Re: [HACKERS] Synchronous replication: status of standby side

2009-06-04 Thread Kolb, Harald (NSN - DE/Munich)
Hi, -Original Message- From: ext Fujii Masao [mailto:masao.fu...@gmail.com] Sent: Thursday, June 04, 2009 6:25 AM To: Kolb, Harald (NSN - DE/Munich) Cc: pgsql-hackers@postgresql.org Subject: Re: [HACKERS] Synchronous replication: status of standby side Hi, On Thu, Jun 4

[HACKERS] postmaster recovery and automatic restart suppression

2009-06-04 Thread Kolb, Harald (NSN - DE/Munich)
Hi, in case of a serious failure of a backend or an auxiliary process the postmaster performs a crash recovery and restarts the db automatically. Is there a possibility to deactivate the restart and to force the postmaster to simply exit at the end ? The background is that we will have a

[HACKERS] Synchronous replication: status of standby side

2009-06-03 Thread Kolb, Harald (NSN - DE/Munich)
Hi, will there be a possibility to retrieve the standby situation in case of synchronous replication ? We would need a command or similar to report the current state and state changes (like: syncing, in-sync, replication broken, ..). Observing and scaning the logfile would not be appropriate.

Re: [HACKERS] Synchronous replication: Promotion of Standby to Primary

2009-05-25 Thread Kolb, Harald (NSN - DE/Munich)
) Cc: Kolb, Harald (NSN - DE/Munich); Czichy, Thoralf (NSN - FI/Helsinki); PostgreSQL-development Subject: Re: Synchronous replication: Promotion of Standby to Primary Hi, On Thu, May 14, 2009 at 8:16 PM, Fujii Masao masao.fu...@gmail.com wrote: Hi, On Mon, May 4, 2009 at 11:07 PM, K, Niranjan