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

From Jaime Casanova
Subject Re: Comparing Oracle vs Postgres Fwd: [ADMIN] Database replication to 50-80 nodes
Date
Msg-id CAJKUy5gqcEiTnnDNzSK=6xzcCSOfcODvF4u27o5Fx5vi1FhLTQ@mail.gmail.com
Whole thread Raw
In response to Re: Comparing Oracle vs Postgres Fwd: [ADMIN] Database replication to 50-80 nodes  (Ian Lawrence Barwick <barwick@gmail.com>)
List pgsql-general
On Thu, Oct 3, 2013 at 5:40 PM, Ian Lawrence Barwick <barwick@gmail.com> wrote:
> 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.
>

and the postgres_fdw


--
Jaime Casanova         www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación
Phone: +593 4 5107566         Cell: +593 987171157


pgsql-general by date:

Previous
From: Ian Lawrence Barwick
Date:
Subject: Re: Comparing Oracle vs Postgres Fwd: [ADMIN] Database replication to 50-80 nodes
Next
From: Michal TOMA
Date:
Subject: Re: pg_xlog size growing untill it fills the partition