From: Joshua D. Drake <jd@commandprompt.com>
To: Tomasz Ziss <tziss85@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: Oracle Logical Standby equivalent in PostgreSQL
Date: Sat, 19 Nov 2016 09:03:44 -0800
Message-ID: <9441c115-924f-f2b8-3bfc-1d02e9c97558@commandprompt.com> (raw)
In-Reply-To: <CAKFKtuc+0i7s_HKCt=4Gx4UjK3WcngWpgJJmuqb1=LF-BbS7UQ@mail.gmail.com>
References: <CAKFKtuc+0i7s_HKCt=4Gx4UjK3WcngWpgJJmuqb1=LF-BbS7UQ@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
On 11/19/2016 08:52 AM, Tomasz Ziss wrote:
> Hi,
>
> I'm quite new in PostgreSQL and receive some task to check if we could
> do something like Oracle logical standby database in PostgresSQL.
> I mean we have several huge tables and we don't want to replicate them
> into standby database (skiip changes for them).
> Is it possible to achieve in PosgresSQL?
> Where should start looking in PostgresSQL world?
Yes you can do this.
PgLogical
Slony
Skytools
JD
>
> Regards,
> zizu1985
--
Command Prompt, Inc. http://the.postgres.company/
+1-503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Everyone appreciates your honesty, until you are honest with them.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
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: jd@commandprompt.com, tziss85@gmail.com
Subject: Re: Oracle Logical Standby equivalent in PostgreSQL
In-Reply-To: <9441c115-924f-f2b8-3bfc-1d02e9c97558@commandprompt.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