pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedReplication Solution
10+ messages / 9 participants
[nested] [flat]
* Replication Solution
@ 2003-02-24 22:26 DA-Luis Lorenzo <lorenzo@cimex.com.cu>
2003-02-25 15:35 ` Re: Replication Solution Robert Treat <xzilla@users.sourceforge.net>
0 siblings, 1 reply; 10+ messages in thread
From: DA-Luis Lorenzo @ 2003-02-24 22:26 UTC (permalink / raw)
To: pgsql-admin
Hi
I need some help on this topic.
Can anyone give me an advice how I can to replicate data between one
server and many slaves? If is posible I need the replication in two
ways.
I was trying to look some solution on internet, but I don't understand.
Please, any ideas
Thanx
Luis
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: Replication Solution
2003-02-24 22:26 Replication Solution DA-Luis Lorenzo <lorenzo@cimex.com.cu>
@ 2003-02-25 15:35 ` Robert Treat <xzilla@users.sourceforge.net>
0 siblings, 0 replies; 10+ messages in thread
From: Robert Treat @ 2003-02-25 15:35 UTC (permalink / raw)
To: DA-Luis Lorenzo <lorenzo@cimex.com.cu>; +Cc: pgsql-admin
On Mon, 2003-02-24 at 17:26, DA-Luis Lorenzo wrote:
> Hi
>
> I need some help on this topic.
>
> Can anyone give me an advice how I can to replicate data between one
> server and many slaves? If is posible I need the replication in two
> ways.
>
> I was trying to look some solution on internet, but I don't understand.
>
> Please, any ideas
>
I can't imagine you haven't seen the information at
http://gborg.postgresql.org/project/pgreplication/projdisplay.php
it gives a pretty good overview of some of the current solutions. You'll
also notice some articles on techdocs. Take a look at those and if you
have specific questions on a particular implementation, please post back
here or on general (which might be more fruitful)
Robert Treat
^ permalink raw reply [nested|flat] 10+ messages in thread
* replication solution
@ 2010-08-24 13:46 Silvio Brandani <silvio.brandani@tech.sdb.it>
2010-08-24 13:54 ` Re: replication solution Kevin Grittner <Kevin.Grittner@wicourts.gov>
2010-08-24 16:32 ` Re: replication solution Devrim GÜNDÜZ <devrim@gunduz.org>
2010-08-24 16:38 ` Re: replication solution Joshua D. Drake <jd@commandprompt.com>
2010-10-13 20:06 ` Re: replication solution Simon Riggs <simon@2ndQuadrant.com>
0 siblings, 4 replies; 10+ messages in thread
From: Silvio Brandani @ 2010-08-24 13:46 UTC (permalink / raw)
To: pgsql-admin
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??
thanks a lot
Silvio
---
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/news/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/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.
--
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: replication solution
2010-08-24 13:46 replication solution Silvio Brandani <silvio.brandani@tech.sdb.it>
@ 2010-08-24 13:54 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
3 siblings, 0 replies; 10+ messages in thread
From: Kevin Grittner @ 2010-08-24 13:54 UTC (permalink / raw)
To: pgsql-admin; Silvio Brandani <silvio.brandani@tech.sdb.it>
Silvio Brandani <silvio.brandani@tech.sdb.it> wrote:
> 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.
What's your time frame? The Hot Standby and Streaming Replication
features in PostgreSQL 9.0 will do exactly that. 9.0 is currently
in beta testing and expected to be released next month. These new
features are based on PITR techniques, but SR allows the WAL data
to flow across a connection in near real-time, and HS allows the
standby to be used for read-only queries.
-Kevin
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: replication solution
2010-08-24 13:46 replication solution Silvio Brandani <silvio.brandani@tech.sdb.it>
@ 2010-08-24 16:32 ` Devrim GÜNDÜZ <devrim@gunduz.org>
3 siblings, 0 replies; 10+ messages in thread
From: Devrim GÜNDÜZ @ 2010-08-24 16:32 UTC (permalink / raw)
To: Silvio Brandani <silvio.brandani@tech.sdb.it>; +Cc: pgsql-admin
Hi,
24.Ağu.2010 tarihinde 16:46 saatinde, Silvio Brandani <silvio.brandani@tech.sdb.i
t> şunları yazdı:
> The Slony solution could be a possibility but the production
> database is 80 Gb of data with around 10000 transaction each hour.
We do at least 15x more transactions with Slony, w/o any issues. Slony
should be good for you.
--
Devrim GÜNDÜZ
PostgreSQL DBA @ Akinon/Markafoni, Red Hat Certified Engineer
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: replication solution
2010-08-24 13:46 replication solution Silvio Brandani <silvio.brandani@tech.sdb.it>
@ 2010-08-24 16:38 ` Joshua D. Drake <jd@commandprompt.com>
2010-08-24 21:43 ` Re: replication solution Rosser Schwarz <rosser.schwarz@gmail.com>
3 siblings, 1 reply; 10+ messages in thread
From: Joshua D. Drake @ 2010-08-24 16:38 UTC (permalink / raw)
To: Silvio Brandani <silvio.brandani@tech.sdb.it>; +Cc: pgsql-admin
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.
Slony (or Londiste) can handle that without issue, at all.
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http://twitter.com/cmdpromptinc | http://identi.ca/commandprompt
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: replication solution
2010-08-24 13:46 replication solution Silvio Brandani <silvio.brandani@tech.sdb.it>
2010-08-24 16:38 ` Re: replication solution Joshua D. Drake <jd@commandprompt.com>
@ 2010-08-24 21:43 ` Rosser Schwarz <rosser.schwarz@gmail.com>
0 siblings, 0 replies; 10+ messages in thread
From: Rosser Schwarz @ 2010-08-24 21:43 UTC (permalink / raw)
To: jd@commandprompt.com; +Cc: Silvio Brandani <silvio.brandani@tech.sdb.it>; pgsql-admin
On Tue, Aug 24, 2010 at 10:38 AM, Joshua D. Drake <jd@commandprompt.com> wrote:
> On Tue, 2010-08-24 at 15:46 +0200, Silvio Brandani wrote:
>> The Slony solution could be a possibility but the production database is
>> 80 Gb of data with around 10000 transaction each hour.
> Slony (or Londiste) can handle that without issue, at all.
Bucardo, too. All three work on similar principles.
rls
--
:wq
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: replication solution
2010-08-24 13:46 replication solution Silvio Brandani <silvio.brandani@tech.sdb.it>
@ 2010-10-13 20:06 ` Simon Riggs <simon@2ndQuadrant.com>
2010-10-14 17:00 ` Re: replication solution Dinesh Bhandary <dbhandary@iii.com>
2010-10-18 12:46 ` Re: replication solution Silvio Brandani <silvio.brandani@tech.sdb.it>
3 siblings, 2 replies; 10+ messages in thread
From: Simon Riggs @ 2010-10-13 20:06 UTC (permalink / raw)
To: Silvio Brandani <silvio.brandani@tech.sdb.it>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: replication solution
2010-08-24 13:46 replication solution Silvio Brandani <silvio.brandani@tech.sdb.it>
2010-10-13 20:06 ` Re: replication solution Simon Riggs <simon@2ndQuadrant.com>
@ 2010-10-14 17:00 ` Dinesh Bhandary <dbhandary@iii.com>
1 sibling, 0 replies; 10+ messages in thread
From: Dinesh Bhandary @ 2010-10-14 17:00 UTC (permalink / raw)
To: pgsql-admin
I've heard that rubyrep (http://www.rubyrep.org) is a good tool for
replication too. I think it has gained popularity because of its ease of
use.
On a similar note I am eager to try postgreSQl 9.0 bulit in hot standby
solution.I can't really wait till Postgersql rolls out replicated
solution which can also be used for a failover.
Dinesh
On 10/13/2010 1:06 PM, Simon Riggs wrote:
> 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.
>
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: replication solution
2010-08-24 13:46 replication solution Silvio Brandani <silvio.brandani@tech.sdb.it>
2010-10-13 20:06 ` Re: replication solution Simon Riggs <simon@2ndQuadrant.com>
@ 2010-10-18 12:46 ` Silvio Brandani <silvio.brandani@tech.sdb.it>
1 sibling, 0 replies; 10+ messages in thread
From: Silvio Brandani @ 2010-10-18 12:46 UTC (permalink / raw)
To: Simon Riggs <simon@2ndQuadrant.com>; +Cc: 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.
--
^ permalink raw reply [nested|flat] 10+ messages in thread
end of thread, other threads:[~2010-10-18 12:46 UTC | newest]
Thread overview: 10+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-02-24 22:26 Replication Solution DA-Luis Lorenzo <lorenzo@cimex.com.cu>
2003-02-25 15:35 ` Robert Treat <xzilla@users.sourceforge.net>
2010-08-24 13:46 replication solution Silvio Brandani <silvio.brandani@tech.sdb.it>
2010-08-24 13:54 ` Re: replication solution Kevin Grittner <Kevin.Grittner@wicourts.gov>
2010-08-24 16:32 ` Re: replication solution Devrim GÜNDÜZ <devrim@gunduz.org>
2010-08-24 16:38 ` Re: replication solution Joshua D. Drake <jd@commandprompt.com>
2010-08-24 21:43 ` Re: replication solution Rosser Schwarz <rosser.schwarz@gmail.com>
2010-10-13 20:06 ` Re: replication solution Simon Riggs <simon@2ndQuadrant.com>
2010-10-14 17:00 ` Re: replication solution Dinesh Bhandary <dbhandary@iii.com>
2010-10-18 12:46 ` Re: replication solution Silvio Brandani <silvio.brandani@tech.sdb.it>
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