Skip site navigation (1) Skip section navigation (2)

Re: Replication

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Craig James <craig_james(at)emolecules(dot)com>
Cc: Andreas Kostyrka <andreas(at)kostyrka(dot)org>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Replication
Date: 2007-06-15 02:37:07
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
Craig James wrote:
> Andreas Kostyrka wrote:
>> Slony provides near instantaneous failovers (in the single digit seconds
>>  range). You can script an automatic failover if the master server
>> becomes unreachable.
> But Slony slaves are read-only, correct?  So the system isn't fully 
> functional once the master goes down.

That is what promotion is for.

Joshua D. Drake

> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings


       === 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

Donate to the PostgreSQL Project:
PostgreSQL Replication:

In response to

pgsql-performance by date

Next:From: A. KretschmerDate: 2007-06-15 04:58:06
Subject: Re: Database size
Previous:From: Eugene OgurtsovDate: 2007-06-15 02:17:46
Subject: Re: Replication

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group