Обсуждение: Comparing Oracle vs Postgres Fwd: [ADMIN] Database replication to 50-80 nodes

---------- Forwarded message ----------
> From: Shahzad Bashir <shahzadbashir4477@hotmail.com>
> Date: Thu, Oct 3, 2013 at 5:43 AM
> Subject: RE: [ADMIN] Database replication to 50-80 nodes
> To: Jaime Casanova <jaime@2ndquadrant.com>
>
>
> hi,
> I am very much new to postgres, infact just started... can anyone please share
> whats and what not of postgres in comparison with oracle .


Hi,

Please, when you do a new question send a new mail not just a reply
from an existing question. This is important because these mails are
archived so people can search later for when similar issues appear.

Also, please use "reply all" so you can be sure your question arrives
to the list and not one person.

> Secondly is there
> ":database link " in postgres and if not , what is the alternative of it.
>

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

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

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

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