Re: PITR for replication?

From: Gavin Sherry <swm(at)linuxworld(dot)com(dot)au>
To: "J(dot) Andrew Rogers" <jrogers(at)neopolitan(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: PITR for replication?
Date: 2004-04-02 01:50:36
Message-ID: Pine.LNX.4.58.0404021149270.31427@linuxworld.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy pgsql-hackers pgsql-hackers-pitr

On Fri, 1 Apr 2004, J. Andrew Rogers wrote:

>
> I may be completely missing the point here, but it looks to me as though
> the PITR archival mechanism is also most of a native replication
> facility. Is there anyone reason this couldn't be extended to
> replication, and if so, is anyone planning on using it as such?
>
> My memory is fuzzy on this point, but I seem to recall that this is
> (was?) how replication is more-or-less done for many of the big
> commercial RDBMS.

Logfile shipping is one replication option some commercial vendors offer.
It doesn't solve all problems however. It is mostly used for hot backups
in my experience.

Gavin

In response to

Browse pgsql-advocacy by date

  From Date Subject
Next Message Christopher Browne 2004-04-02 03:04:41 Re: PITR for replication?
Previous Message J. Andrew Rogers 2004-04-02 00:58:28 PITR for replication?

Browse pgsql-hackers by date

  From Date Subject
Next Message Joe Conway 2004-04-02 02:29:03 Re: Inconsistent behavior on Array & Is Null?
Previous Message Josh Berkus 2004-04-02 01:12:23 Re: Inconsistent behavior on Array & Is Null?

Browse pgsql-hackers-pitr by date

  From Date Subject
Next Message Christopher Browne 2004-04-02 03:04:41 Re: PITR for replication?
Previous Message J. Andrew Rogers 2004-04-02 00:58:28 PITR for replication?