pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Oracle Logical Standby equivalent in PostgreSQL
2+ messages / 2 participants
[nested] [flat]

* Oracle Logical Standby equivalent in PostgreSQL
@ 2016-11-19 16:52  Tomasz Ziss <tziss85@gmail.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Tomasz Ziss @ 2016-11-19 16:52 UTC (permalink / raw)
  To: pgsql-admin

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?

Regards,
zizu1985

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Oracle Logical Standby equivalent in PostgreSQL
@ 2016-11-19 17:03  Joshua D. Drake <jd@commandprompt.com>
  parent: Tomasz Ziss <tziss85@gmail.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Joshua D. Drake @ 2016-11-19 17:03 UTC (permalink / raw)
  To: Tomasz Ziss <tziss85@gmail.com>; 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.


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2016-11-19 17:03 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2016-11-19 16:52 Oracle Logical Standby equivalent in PostgreSQL Tomasz Ziss <tziss85@gmail.com>
2016-11-19 17:03 ` Joshua D. Drake <jd@commandprompt.com>

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