From: | Silvio Brandani <silvio(dot)brandani(at)tech(dot)sdb(dot)it> |
---|---|
To: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: replication solution |
Date: | 2010-10-18 12:46:55 |
Message-ID: | 4CBC41BF.9060106@tech.sdb.it |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Simon Riggs ha scritto:
> 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.
>
>
We are testing postgres 9.0.1 hot-standby feautures in a dev environment.
Thanks a lot
Silvio Brandani
---
Utilizziamo i dati personali che la riguardano esclusivamente per nostre finalit amministrative e contabili, anche quando li comunichiamo a terzi. Informazioni dettagliate, anche in ordine al Suo diritto di accesso e agli altri Suoi diritti, sono riportate alla pagina http://www.savinodelbene.com/privacy.html
Se avete ricevuto questo messaggio per errore Vi preghiamo di ritornarlo al mittente eliminandolo assieme agli eventuali allegati, ai sensi art. 616 codice penale http://www.savinodelbene.com/privacy/codice_penale_616.html
L'Azienda non si assume alcuna responsabilit giuridica qualora pervengano da questo indirizzo messaggi estranei all'attivit lavorativa o contrari a norme.
--
From | Date | Subject | |
---|---|---|---|
Next Message | Maria L. Wilson | 2010-10-18 14:38:55 | Postgres 8.4 large table partitioning |
Previous Message | Robert Gravsjö | 2010-10-18 09:22:23 | Re: pg_ident.conf not working? |