[GENERAL] Comparing Oracle vs Postgres Fwd: [ADMIN] Database replication to 50-80 nodes
-- Forwarded message -- > From: Shahzad Bashir > Date: Thu, Oct 3, 2013 at 5:43 AM > Subject: RE: [ADMIN] Database replication to 50-80 nodes > To: Jaime Casanova > > > 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Comparing Oracle vs Postgres Fwd: [ADMIN] Database replication to 50-80 nodes
2013/10/4 Jaime Casanova : > 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Comparing Oracle vs Postgres Fwd: [ADMIN] Database replication to 50-80 nodes
On Thu, Oct 3, 2013 at 5:40 PM, Ian Lawrence Barwick wrote: > 2013/10/4 Jaime Casanova : >> 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general