Re: Data Replication

From: "Tim Uckun" <timuckun(at)gmail(dot)com>
To: jd(at)commandprompt(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Data Replication
Date: 2008-12-11 02:40:47
Message-ID: 855e4dcf0812101840s45b616bw7f0c80a8c29a50b5@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>
> You have to run a new base backup and have the slave ship logs to the
> master.

Mmmm. Does this backup have to be a full backup? What if your database
is very large?

I am hoping to get a setup which is similar to SQL server mirroring.
It uses a witness server to keep track of who got what "logs" (it's
based on transaction logging) and allows you to failover and fail back
without having to do a full backup in between.

>> Is there a product which enables this kind of functionality?
>>
>
> https://projects.commandprompt.com/public/pitrtools
>

I'll check these out. Thanks.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2008-12-11 03:41:30 Re: Data Replication
Previous Message Phillip Berry 2008-12-11 02:32:33 Startup process thrashing