Re: Comparing Oracle vs Postgres Fwd: [ADMIN] Database replication to 50-80 nodes - Mailing list pgsql-general

From Ian Lawrence Barwick
Subject Re: Comparing Oracle vs Postgres Fwd: [ADMIN] Database replication to 50-80 nodes
Date
Msg-id CAB8KJ=hnLkMGO+ZL5aXPMBBdNUAQLHxeC4mK5UiwDTDqPHFWDw@mail.gmail.com
Whole thread Raw
In response to Comparing Oracle vs Postgres Fwd: [ADMIN] Database replication to 50-80 nodes  (Jaime Casanova <jaime@2ndquadrant.com>)
Responses Re: Comparing Oracle vs Postgres Fwd: [ADMIN] Database replication to 50-80 nodes  (Jaime Casanova <jaime@2ndquadrant.com>)
List pgsql-general
2013/10/4 Jaime Casanova <jaime@2ndquadrant.com>:
> what version of postgres is this? starting in 9.3 you can create
> foreign tables between postgres databases, before that you can create
> a foreing server and use the functions from th dblink module to
> connect to that server and query the table on it

Read-only foreign tables have been available since 9.1, it's writeable foreign
tables which were introduced in 9.3.

Regards

Ian Barwick


pgsql-general by date:

Previous
From: Ken Brush
Date:
Subject: Re: pg_xlog size growing untill it fills the partition
Next
From: Jaime Casanova
Date:
Subject: Re: Comparing Oracle vs Postgres Fwd: [ADMIN] Database replication to 50-80 nodes