pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Chad Wagner <chad.wagner@gmail.com>
To: Alexander B. <burbello3000@yahoo.com.br>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Another way to Replicate
Date: Fri, 19 Jan 2007 13:49:55 -0500
Message-ID: <81961ff50701191049r5f729dcbqd074731edd0e6de1@mail.gmail.com> (raw)
In-Reply-To: <45B110F6.9080607@yahoo.com.br>
References: <45B110F6.9080607@yahoo.com.br>

On 1/19/07, Alexander B. <burbello3000@yahoo.com.br> wrote:
>
> I would like to know if is possible to replicate in postgres applying
> binary logs (wal logs) like the same way is done on Oracle!!
> Did anybody tried to do that?


Oracle doesn't use binary logs for replication, for regular snapshots it
uses a "materialized log" -- which is nothing more than a table with a
primary key and what type of change.  If we are talking multi-master
replication, then Oracle uses Advanced Queues (essentially another table)
and pushes the data.  All off this occurs over DB links.

As for binary (archived redo) logs in Oracle, they can be used for a Hot
Standby.  Which PostgreSQL also supports, as I understand it this is a new
feature for 8.2.

I personally haven't investigated Slony, but I believe it functions similar.

Applying the simple ideia:
> - for each archived Wal logs, transfer to slave server;
> - after transfer, apply recover on postgres;
> - repeat the steps above, all the time;


Again, this is a hot (warm in PostgreSQL) standby database.  I don't think
you can bring online a database in read only while it is actively applying
the archived WAL logs.



-- 
Chad
http://www.postgresqlforums.com/

view thread (5+ messages)  latest in thread

Message-ID: <81961ff50701191049r5f729dcbqd074731edd0e6de1@mail.gmail.com>
Permalink:  ../81961ff50701191049r5f729dcbqd074731edd0e6de1@mail.gmail.com/
Also on:    postgresql.org/message-id/81961ff50701191049r5f729dcbqd074731edd0e6de1@mail.gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: chad.wagner@gmail.com, burbello3000@yahoo.com.br
  Subject: Re: Another way to Replicate
  In-Reply-To: <81961ff50701191049r5f729dcbqd074731edd0e6de1@mail.gmail.com>
  References: <45B110F6.9080607@yahoo.com.br> <81961ff50701191049r5f729dcbqd074731edd0e6de1@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox