pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Scott Marlowe <scott.marlowe@gmail.com>
To: Martin Badie <martinbadie@yahoo.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: replication with table add/removes..
Date: Wed, 8 Oct 2008 12:28:54 -0600
Message-ID: <dcc563d10810081128i25f9471cv81e8092d4094bd1b@mail.gmail.com> (raw)
In-Reply-To: <103015.29150.qm@web59907.mail.ac4.yahoo.com>
References: <103015.29150.qm@web59907.mail.ac4.yahoo.com>

On Wed, Oct 8, 2008 at 9:10 AM, Martin Badie <martinbadie@yahoo.com> wrote:
> Hi,
>
> I have a system that have constant table adds/removes are present. I want to
> make a replication between master and slaves but not sure which one is the
> best solution for that kind of a situation. Since I am new to replication
> stuff on postgresql I am truly lost but I know that Slony is not an answer
> for replications where table add/remove are present.

I think that pgpool might work for this.  There are probably some
other "front end" type replication systems that would work too.



view thread (4+ messages)  latest in thread

Message-ID: <dcc563d10810081128i25f9471cv81e8092d4094bd1b@mail.gmail.com>
Permalink:  ../dcc563d10810081128i25f9471cv81e8092d4094bd1b@mail.gmail.com/
Also on:    postgresql.org/message-id/dcc563d10810081128i25f9471cv81e8092d4094bd1b@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 using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: scott.marlowe@gmail.com, martinbadie@yahoo.com
  Subject: Re: replication with table add/removes..
  In-Reply-To: <dcc563d10810081128i25f9471cv81e8092d4094bd1b@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