Comparing Oracle vs Postgres Fwd: [ADMIN] Database replication to 50-80 nodes

---------- Forwarded message ----------
> From: Shahzad Bashir <shahzadbashir4477(at)hotmail(dot)com>
> Date: Thu, Oct 3, 2013 at 5:43 AM
> Subject: RE: [ADMIN] Database replication to 50-80 nodes
> To: Jaime Casanova <jaime(at)2ndquadrant(dot)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