Re: Oracle Logical Standby equivalent in PostgreSQL

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Tomasz Ziss <tziss85(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Oracle Logical Standby equivalent in PostgreSQL
Date: 2016-11-19 17:03:44
Message-ID: 9441c115-924f-f2b8-3bfc-1d02e9c97558@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message rajan 2016-11-20 06:38:08 Re: Why are a lot of ROLLBACK queries in idle state
Previous Message Tomasz Ziss 2016-11-19 16:52:33 Oracle Logical Standby equivalent in PostgreSQL