Re: Data Replication - Mailing list pgsql-general

From Tim Uckun
Subject Re: Data Replication
Date
Msg-id 855e4dcf0812101840s45b616bw7f0c80a8c29a50b5@mail.gmail.com
Whole thread Raw
In response to Re: Data Replication  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: Data Replication
List 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.

pgsql-general by date:

Previous
From: Phillip Berry
Date:
Subject: Startup process thrashing
Next
From: "Scott Marlowe"
Date:
Subject: Re: Data Replication