WAL and master multi-slave replication

From: Eduardo Morras <emorras(at)s21sec(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: WAL and master multi-slave replication
Date: 2009-06-24 16:57:21
Message-ID: 20090624165506.136EC4BDCB7@s21sec.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello:

I'm currently building a Pg multiserver and have
a question about the possibility of working with
WAL in a multislave environment.

I have few master servers (write only) and
multiple slave servers (read only). I want to
write the WAL files from masters in a central
postgres and that the multiple slaves reads them
from time to time and auto update.

From time to time deleting the old entries. Can
it be done? Can it work as expected? Any problems
working this way? Should wal files be compressed or similar?

I'm thinking in a table schema like this:

CREATE TABLE "WAL_Table"
(
create_date timestamp with time zone NOT NULL,
wal bytea,
CONSTRAINT idx1 PRIMARY KEY (create_date)
)

Thanks in advance

--------------------------------
Eduardo Morrás González
Dept. I+D+i e-Crime Vigilancia Digital
S21sec Labs
Tlf: +34 902 222 521
Móvil: +34 555 555 555
www.s21sec.com, blog.s21sec.com

Salvo que se indique lo contrario, esta información es CONFIDENCIAL y
contiene datos de carácter personal que han de ser tratados conforme a la
legislación vigente en materia de protección de datos. Si usted no es
destinatario original de este mensaje, le comunicamos que no está autorizado
a revisar, reenviar, distribuir, copiar o imprimir la información en él
contenida y le rogamos que proceda a borrarlo de sus sistemas.

Kontrakoa adierazi ezean, posta elektroniko honen barruan doana ISILPEKO
informazioa da eta izaera pertsonaleko datuak dituenez, indarrean dagoen
datu pertsonalak babesteko legediaren arabera tratatu beharrekoa. Posta
honen hartzaile ez zaren kasuan, jakinarazten dizugu baimenik ez duzula
bertan dagoen informazioa aztertu, igorri, banatu, kopiatu edo inprimatzeko.
Hortaz, erregutzen dizugu posta hau zure sistemetatik berehala ezabatzea.

Antes de imprimir este mensaje valora si verdaderamente es necesario. De
esta forma contribuimos a la preservación del Medio Ambiente.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2009-06-24 17:05:46 Re: WAL and master multi-slave replication
Previous Message Thomas Kellerer 2009-06-24 16:40:54 Re: Replication