PostgreSQL Replication

From: Franklin Haut <franklin(dot)haut(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: PostgreSQL Replication
Date: 2013-04-06 00:31:47
Message-ID: CAN1QLZJdMjaUNg4=Sixm3t_84_CXfRTsnD0paOwuBdzheSewEA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I have a doubt about replication, hopefully they can help me. I have
several databases all in version 9.2, geographically distant, as in the
example below:

200.xxx.xxx.1
database1 (260GB)
database2 (20GB)

200.xxx.xxx.2
database3 (60GB)
database4 (10GB)

200.xxx.xxx.3
database5 (200GB)
database6 (500GB)

200.xxx.xxx.4
database7 (200GB)
database8 (3GB)

I need to replicate databases
(database2, database4, database5, database6, database7) to another
230.yyy.zzz.5 server only for backup, no insert, update or delete command.
Some times can be the downfall of Internet link

230.yyy.zzz.5
database2
database4
database5
database6
database7

Is there way to implement this replication?

Best regards

Franklin Haut

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Kevin Grittner 2013-04-06 14:05:56 Re: PostgreSQL Replication
Previous Message Pandu Poluan 2013-04-04 04:34:57 Re: 32 and 64-bit versions of PostgreSQL for Windows