Re: Hot Backup

From: Justin Clift <justin(at)postgresql(dot)org>
To: Erwan DUROSELLE <EDuroselle(at)seafrance(dot)fr>
Cc: itvthor(at)sdf(dot)lonestar(dot)org, kleptog(at)svana(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Re: Hot Backup
Date: 2002-10-08 14:04:40
Message-ID: 3DA2E5F8.EA496ADD@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Hi Erwan,

Erwan DUROSELLE wrote:
<snip>
> As someone said, Replication may be a way to reduce the risks.

Yes, it can, but it all depends on how much the data is worth, what kind
of load happens, etc.

Something as simple as a master->slave replication setup will do,
because the master would generally be the beefy box doing processing,
and the slave database server only receives changes, etc.

Useful for lots of circumstances, although not the only solution.

:-)

Regards and best wishes,

Justin Clift


> E.D.
>
> -------------------------------------------------------------------------------
> Erwan DUROSELLE // SEAFRANCE DSI
> Responsable Bases de Données // Databases Manager
> Tel: +33 (0)1 55 31 59 70 // Fax: +33 (0)1 55 31 85 28
> email: eduroselle(at)seafrance(dot)fr
> -------------------------------------------------------------------------------

--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Justin Clift 2002-10-08 14:08:45 Re: Rép. : Re: Hot Backup
Previous Message Richard Huxton 2002-10-08 14:04:29 Re: pg_dump command inside shell scripts

Browse pgsql-hackers by date

  From Date Subject
Next Message Curtis Faith 2002-10-08 14:15:30 Re: Analysis of ganged WAL writes
Previous Message Curtis Faith 2002-10-08 14:00:06 Re: Analysis of ganged WAL writes