Re: Replication with partitions?

From: FattahRozzaq <ssoorruu(at)gmail(dot)com>
To: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
Cc: Dave Johansen <davejohansen(at)gmail(dot)com>, pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Replication with partitions?
Date: 2015-12-09 00:59:29
Message-ID: CAKnA-A1G91MF2dqro=f1d8mcUb60k545QhF+mJ2nrPfHjvEnZQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi Dave,

I don't know if DRBD will help to fulfil your requirement.
But DRBD is a nice one to try since it will replicate a whole
disk/volume from 1 server to backup server.
Therefore, you'll need a dedicated disk/volume for your PostgreSQL
data directory to be replicated to the same size of disk/volume in the
backup server.

On 09/12/2015, Scott Ribe <scott_ribe(at)elevated-dev(dot)com> wrote:
> On Dec 8, 2015, at 8:35 AM, Dave Johansen <davejohansen(at)gmail(dot)com> wrote:
>>
>> Does 9.3 or 9.4 support this sort of configuration?
>
> No.
>
>> If not, from the table in the documentation, it looks like Slony [1] and
>> Bucardo [2] would both work, so does any one have any recommendations?
>
> I know Slony does, but I don't have any recommendation for one or the
> other.
>
> --
> Scott Ribe
> scott_ribe(at)elevated-dev(dot)com
> http://www.elevated-dev.com/
> https://www.linkedin.com/in/scottribe/
> (303) 722-0567 voice
>
>
>
>
>
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Emily de Souza 2015-12-09 04:29:56 Getting a better performance
Previous Message Scott Ribe 2015-12-08 17:47:35 Re: Replication with partitions?