Subject: Re: Oracle Logical Standby equivalent in PostgreSQL
To: Tomasz Ziss <tziss85@gmail.com>, pgsql-admin@postgresql.org
References: 
 <CAKFKtuc+0i7s_HKCt=4Gx4UjK3WcngWpgJJmuqb1=LF-BbS7UQ@mail.gmail.com>
From: "Joshua D. Drake" <jd@commandprompt.com>
Organization: Command Prompt, Inc.
Message-ID: <9441c115-924f-f2b8-3bfc-1d02e9c97558@commandprompt.com>
Date: Sat, 19 Nov 2016 09:03:44 -0800
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101
 Thunderbird/45.4.0
MIME-Version: 1.0
In-Reply-To: 
 <CAKFKtuc+0i7s_HKCt=4Gx4UjK3WcngWpgJJmuqb1=LF-BbS7UQ@mail.gmail.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

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