Re: Need Help in Taking Backups

From: Gourish Singbal <gourish(at)gmail(dot)com>
To: Christopher Browne <cbbrowne(at)acm(dot)org>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Need Help in Taking Backups
Date: 2004-12-07 11:31:19
Message-ID: 674d1f8a04120703316af85b8c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Thanks, i think Slony-I might be an answer to my questions. But need
to explore Slony-I before saying anything.

Has Anybody found any dificulties in implementing hotback, using Slony-I.
Thoughts would be of great help.

regards
Gourish.

On 7 Dec 2004 04:17:21 GMT, Christopher Browne <cbbrowne(at)acm(dot)org> wrote:
> Well, you can take a pg_dump to get the state of the system at a point
> in time. That's very easy.
>
>
>
> But you really need to specify your 'disaster modelling' and recovery
> requirements in _much_ greater detail. It may be that in order to
> keep recovery time down, you'll need to use a replication system such
> as Slony-I to give you a "hot backup" that's sitting just a few
> transactions behind.
> --
> let name="cbbrowne" and tld="gmail.com" in name ^ "@" ^ tld;;
> http://linuxfinances.info/info/postgresql.html
> "We defeated the enemy with teamwork and the hammer of not bickering."
> -- The Shoveller, Mystery Men
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>

--
Best,
Gourish Singbal

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message John Jensen 2004-12-07 11:47:44 Backup is too slow
Previous Message Peter Eisentraut 2004-12-07 08:59:54 Re: DRBD with Postgres: Good or Bad?