From: Simon Riggs <simon@2ndQuadrant.com>
To: Silvio Brandani <silvio.brandani@tech.sdb.it>
Cc: pgsql-admin@postgresql.org
Subject: Re: replication solution
Date: Wed, 13 Oct 2010 21:06:27 +0100
Message-ID: <1287000387.1709.2649.camel@ebony> (raw)
In-Reply-To: <4C73CD20.5040909@tech.sdb.it>
References: <4C73CD20.5040909@tech.sdb.it>
On Tue, 2010-08-24 at 15:46 +0200, Silvio Brandani wrote:
> Hi all,
>
> we are looking for a solution to create a replicated database to be used
> as reporting database with same data of production ( we can accept a lag
> of some minutes).
>
> we already have the Point In Time Recovery but we need a solution where
> the standby is always open in readonly , but the data is replicated
> continuosly from primary.
>
> The Slony solution could be a possibility but the production database is
> 80 Gb of data with around 10000 transaction each hour.
>
> DO you have some suggestion for our implementaiont if exists??
PostgreSQL 9.0 is production ready now and supports Hot Standby, which
is exactly what you want.
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Training and Services
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: simon@2ndQuadrant.com, silvio.brandani@tech.sdb.it
Subject: Re: replication solution
In-Reply-To: <1287000387.1709.2649.camel@ebony>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox