pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Need Help in Taking Backups
4+ messages / 2 participants
[nested] [flat]

* Need Help in Taking Backups
@ 2004-12-06 14:28 Gourish Singbal <gourish@gmail.com>
  2004-12-07 03:25 ` Re: Need Help in Taking Backups Christopher Browne <cbbrowne@acm.org>
  2004-12-07 04:17 ` Re: Need Help in Taking Backups Christopher Browne <cbbrowne@acm.org>
  0 siblings, 2 replies; 4+ messages in thread

From: Gourish Singbal @ 2004-12-06 14:28 UTC (permalink / raw)
  To: pgsql-admin

Whats the Best plan to take Backups for Postgres 7.4.5 database
considering the database is 24/7 and transaction based.

-- 
Best,
Gourish Singbal



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Need Help in Taking Backups
  2004-12-06 14:28 Need Help in Taking Backups Gourish Singbal <gourish@gmail.com>
@ 2004-12-07 03:25 ` Christopher Browne <cbbrowne@acm.org>
  1 sibling, 0 replies; 4+ messages in thread

From: Christopher Browne @ 2004-12-07 03:25 UTC (permalink / raw)
  To: pgsql-admin

In the last exciting episode, gourish@gmail.com (Gourish Singbal) wrote:
> Whats the Best plan to take Backups for Postgres 7.4.5 database
> considering the database is 24/7 and transaction based.

Well, you can take a pg_dump to get the state of the system at a point
in time.  That's very easy, although it's anyone's guess whether
that's an acceptable answer or not.

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.  Or perhaps the answer will be
to wait for "sophistication" for 8.0 and record transaction logs in
order to use PITR.
-- 
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



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Need Help in Taking Backups
  2004-12-06 14:28 Need Help in Taking Backups Gourish Singbal <gourish@gmail.com>
@ 2004-12-07 04:17 ` Christopher Browne <cbbrowne@acm.org>
  2004-12-07 11:31   ` Re: Need Help in Taking Backups Gourish Singbal <gourish@gmail.com>
  1 sibling, 1 reply; 4+ messages in thread

From: Christopher Browne @ 2004-12-07 04:17 UTC (permalink / raw)
  To: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Need Help in Taking Backups
  2004-12-06 14:28 Need Help in Taking Backups Gourish Singbal <gourish@gmail.com>
  2004-12-07 04:17 ` Re: Need Help in Taking Backups Christopher Browne <cbbrowne@acm.org>
@ 2004-12-07 11:31   ` Gourish Singbal <gourish@gmail.com>
  0 siblings, 0 replies; 4+ messages in thread

From: Gourish Singbal @ 2004-12-07 11:31 UTC (permalink / raw)
  To: Christopher Browne <cbbrowne@acm.org>; +Cc: 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@acm.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@postgresql.org so that your
>      message can get through to the mailing list cleanly
> 


-- 
Best,
Gourish Singbal



^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2004-12-07 11:31 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-12-06 14:28 Need Help in Taking Backups Gourish Singbal <gourish@gmail.com>
2004-12-07 03:25 ` Christopher Browne <cbbrowne@acm.org>
2004-12-07 04:17 ` Christopher Browne <cbbrowne@acm.org>
2004-12-07 11:31   ` Gourish Singbal <gourish@gmail.com>

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