Re: [HACKERS] Hot standby, overflowed snapshots, testing

2009-11-15 Thread Robert Hodges
On 11/15/09 2:25 AM PST, "Simon Riggs" wrote: > On Sat, 2009-11-14 at 08:43 -0800, Robert Hodges wrote: > >> I can help set up automated basic tests for hot standby using 1+1 setups on >> Amazon. I¹m already working on tests for warm standby for our commercial &g

Re: [HACKERS] Hot standby, overflowed snapshots, testing

2009-11-14 Thread Robert Hodges
Hi Simon and Heikki, I can help set up automated basic tests for hot standby using 1+1 setups on Amazon. I¹m already working on tests for warm standby for our commercial Tungsten implementation and need to solve the problem of creating tests that adapt flexibly across different replication mecha

Re: [HACKERS] write ahead logging in standby (streaming replication)

2009-11-12 Thread Robert Hodges
Hi Greg and Fujii, Just a point on terminology: there's a difference in the usage of semi-synchronous between DRBD and MySQL semi-synchronous replication, which was originally developed by Google. In the Google case semi-synchronous replication is a quorum algorithm where clients receive a comm

Re: [HACKERS] Conflict resolution in Multimaster replication(Postgres-R)

2008-09-03 Thread Robert Hodges
ql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers -- Robert Hodges, CTO, Continuent, Inc. Email: [EMAIL PROTECTED] Mobile: +1-510-501-3728 Skype: hodgesrm

Re: [HACKERS] Transaction-controlled robustness for replication

2008-08-12 Thread Robert Hodges
ynchronous. PostgreSQL will eventually be far better as these discussions boil down into designs. Thanks, Robert On 8/12/08 8:51 PM, "Tom Lane" <[EMAIL PROTECTED]> wrote: Markus Wanner <[EMAIL PROTECTED]> writes: > Robert Hodges wrote: >> Could you expand on why logical

Re: [HACKERS] Transaction-controlled robustness for replication

2008-08-12 Thread Robert Hodges
... so ... well, it's barely worth laughing at. > > regards, tom lane > > -- > Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-hackers > -- Rob

Re: [HACKERS] Follow-up on replication hooks for PostgreSQL

2008-07-10 Thread Robert Hodges
management headache of ensuring that triggers are correctly installed. It seems as if one of these generic approaches could hook into WAL record transport. Cheers, Robert On 7/10/08 4:56 AM, "Marko Kreen" <[EMAIL PROTECTED]> wrote: On 7/10/08, Robert Hodges <[EMAIL PROTECTED]

[HACKERS] Follow-up on replication hooks for PostgreSQL

2008-07-09 Thread Robert Hodges
ct me directly. Meanwhile, we are quite serious about this problem and intend to work on helpful additions to PostgreSQL in this area. I will post more as we make progress. Thanks, Robert -- Robert Hodges, CTO, Continuent, Inc. Email: [EMAIL PROTECTED] P.s., Happy 12th birthday everyone!

Re: [HACKERS] Table rewrites vs. pending AFTER triggers

2008-06-01 Thread Robert Hodges
he right thing to do. >>> >>> >> >> +1. Doesn't make much sense to me either. >> >> cheers >> >> andrew >> >> ---(end of broadcast)--- >> TIP 4: Have you searched our li

Re: [HACKERS] Core team statement on replication in PostgreSQL

2008-06-01 Thread Robert Hodges
Hi Hannu, Hi Hannu, On 6/1/08 2:14 PM, "Hannu Krosing" <[EMAIL PROTECTED]> wrote: > >> As a consequence, I don¹t see how you can get around doing some sort >> of row-based replication like all the other databases. > > Is'nt WAL-base replication "some sort of row-based replication" ? > Yes, in t

Re: [HACKERS] Core team statement on replication in PostgreSQL

2008-06-01 Thread Robert Hodges
5/29/08 8:16 PM, "Merlin Moncure" <[EMAIL PROTECTED]> wrote: On Thu, May 29, 2008 at 3:05 PM, Robert Hodges <[EMAIL PROTECTED]> wrote: > Third, you can't stop with just this feature. (This is the BUT part of the > post.) The use cases not covered by this featu

Re: [HACKERS] replication hooks

2008-05-30 Thread Robert Hodges
ight. Cheers, Robert On 5/29/08 9:05 PM, "Marko Kreen" <[EMAIL PROTECTED]> wrote: On 5/29/08, Andrew Sullivan <[EMAIL PROTECTED]> wrote: > On Thu, May 29, 2008 at 12:05:18PM -0700, Robert Hodges wrote: > > people are starting to get religion on this issue I would st

Re: [HACKERS] Core team statement on replication in PostgreSQL

2008-05-30 Thread Robert Hodges
NTT slides were really great. Takahiro and Masao deserve congratulations on an absolutely first-rate presentation. On 5/29/08 9:09 PM, "Tom Lane" <[EMAIL PROTECTED]> wrote: > Andrew Sullivan <[EMAIL PROTECTED]> writes: >> On Thu, May 29, 2008 at 12:05:18PM -0700, R

Re: [HACKERS] Core team statement on replication in PostgreSQL

2008-05-29 Thread Robert Hodges
ut how to let slaves run read-only queries. But even without read-only queries, this will be a useful improvement for HA/backup scenarios. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://ww

Re: [HACKERS] Deterministic locking in PostgreSQL

2008-05-09 Thread Robert Hodges
help us avoid a number of unnecessary failures in master/master replication. If anything else about this raises hackles on your neck (or anyone else's for that matter) please let me know. It's better to know now. :) Cheers, Robert On 5/9/08 4:53 PM, "Tom Lane" <[EMAIL

[HACKERS] Deterministic locking in PostgreSQL

2008-05-09 Thread Robert Hodges
inistic order? Or can it vary based on load, lock manager state, etc., so that sometimes you get 'y' and sometimes 'z' as the final result? If this case turns out to be deterministic, are there other cases that come to mind that would turn out to be non-deterministic? Thanks,

Re: [HACKERS] Table rewrites vs. pending AFTER triggers

2008-03-24 Thread Robert Hodges
ifies tool implementation. We have an application at Continuent that depends on exactly this behavior. I was investigating PostgreSQL semantics just last week and was delighted to find they appear to be exactly right. Oracle on the other hand is going to be a pain... Cheers, Robert Hodges On 1

Re: [HACKERS] Test lab

2007-11-06 Thread Robert Hodges
"normal" test frameworks. Cheers, Robert Robert Hodges, CTO, Continuent, Inc. Email: [EMAIL PROTECTED] Mobile: +1-510-501-3728 Skype: hodgesrm On Nov 6, 2007, at 9:49 AM, Mark Wong wrote: On Tue, 06 Nov 2007 13:15:02 + Simon Riggs <[EMAIL PROTECTED]> wrote: On Mon, 2