public inbox for [email protected]
help / color / mirror / Atom feedFrom: Joshua D. Drake <[email protected]>
To: Bruce Momjian <[email protected]>
Cc: Jim C. Nasby <[email protected]>
Cc: Dawid Kuroczko <[email protected]>
Cc: [email protected]
Cc: [email protected]
Subject: Re: [HACKERS] Replication documentation addition
Date: Thu, 26 Oct 2006 09:19:13 -0700
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
Bruce Momjian wrote:
> Jim C. Nasby wrote:
>> On Wed, Oct 25, 2006 at 08:42:07PM -0400, Bruce Momjian wrote:
>>> Jim C. Nasby wrote:
>>>> Something else worth doing though is to have a paragraph explaining why
>>>> there's no built-in replication. I don't have time to write something
>>>> right now, but I can do it later tonight if no one beats me to it.
>>> I thought that was implied in the early paragraph about why there are
>>> many solutions.
>> I think we should explicitely spell it out, especially considering how
>> many times people ask about it. How about...
>>
>> This multitude of choices is why PostgreSQL does not ship with a
>> replication solution by default; any bundled solution would only
>> satisfy a subset of replication needs.
>
> The problem is that we do have some solutions in our code, like doing
> data partitioning in the application, warm standby, or using a shared
> disk for failover, so how do we spell that out? I say there are
> multiple solutions, but I don't see how I can say that all are external
> and not included.
None of those are replication solutions. So I would have to agree with
Jim here.
This isn't about what people do with their app, so that is not relevant.
Warm standby is PITR which is a backup and recovery solution. It does
not include a failover solution and is *not* replication. It technically
does not provide an HA solution either as it will be almost always
farther behind than a replication solution.
Shared disk for failover could be used by anything it isn't special to a
replication scenario it is standard for many HA.
Sincerely,
Joshua D. Drake
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
view thread (117+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected], [email protected]
Subject: Re: [HACKERS] Replication documentation addition
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox