pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
PostgreSQL backup issue
3+ messages / 3 participants
[nested] [flat]

* PostgreSQL backup issue
@ 2004-04-06 02:34  Eric Yum <eric.yum@ck-lifesciences.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Eric Yum @ 2004-04-06 02:34 UTC (permalink / raw)
  To: pgsql-admin

Dear all
 
I am using PostgreSQL 7.3 as DB server in my company. I am preparing
some DB backup and maintenance procedures. I found from Administrator
guide that we can use "dump" command to backup the DB. It just allow me
to backup the whole DB and restore the whole DB. I wonder that is any
command or feature in PostgreSQL allow me to have incremental backup
policy like SQL Server. In addition, when I restore the DB, is it
possible to select the specify time frame to restore. 
 
Million Thanks.
 
Best Regards, 
Eric Yum
 

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

* Re: PostgreSQL backup issue
@ 2004-04-06 15:53  Naomi Walker <nwalke@eldocomp.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Naomi Walker @ 2004-04-06 15:53 UTC (permalink / raw)
  To: Eric Yum <eric.yum@ck-lifesciences.com>; pgsql-admin

At this time, we do not have point in time recovery.  That is slated for 7.5 (we hope).  There is also no way to perform incremenatals (yet).
	-----Original Message----- 
	From: pgsql-admin-owner@postgresql.org on behalf of Eric Yum 
	Sent: Mon 4/5/2004 7:34 PM 
	To: pgsql-admin@postgresql.org 
	Cc: 
	Subject: [ADMIN] PostgreSQL backup issue
	
	
	Dear all
	 
	I am using PostgreSQL 7.3 as DB server in my company. I am preparing some DB backup and maintenance procedures. I found from Administrator guide that we can use “dump” command to backup the DB. It just allow me to backup the whole DB and restore the whole DB. I wonder that is any command or feature in PostgreSQL allow me to have incremental backup policy like SQL Server. In addition, when I restore the DB, is it possible to select the specify time frame to restore. 
	 
	Million Thanks.
	 
	Best Regards, 
	Eric Yum
	 

-- CONFIDENTIALITY NOTICE --

This message is intended for the sole use of the individual and entity to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the intended addressee, nor authorized to receive for the intended addressee, you are hereby notified that you may not use, copy, disclose or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email, and delete the message. Thank you.



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

* Re: PostgreSQL backup issue
@ 2004-04-06 20:44  Simon Riggs <simon@2ndquadrant.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Simon Riggs @ 2004-04-06 20:44 UTC (permalink / raw)
  To: Eric Yum <eric.yum@ck-lifesciences.com>; pgsql-admin

> Eric Yum wrote
> I am using PostgreSQL 7.3 as DB server in my company. I am preparing
> some DB backup and maintenance procedures. I found from Administrator
> guide that we can use "dump" command to backup the DB. It
> just allow me
> to backup the whole DB and restore the whole DB. I wonder that is any
> command or feature in PostgreSQL allow me to have incremental backup
> policy like SQL Server. In addition, when I restore the DB, is it
> possible to select the specify time frame to restore.

I'm working on this right now; PostgreSQL community calls this Point in
Time Recovery (PITR). This will allow you to take hot backups
occasionally, then backup the transaction logs in between. You would
need to migrate to 7.5 when it becomes available approx 3 months from
now (earlier in dev versions).

The design doesn't currently offer a facility to specify the time frame
to restore. I will be recommending calculating this following the
testing of your recovery procedures. It would then be up to you to
specify appropriately spaced full database backups to give you the MTTR
you require.

[Please note that PostgreSQL does not currently support "incremental"
backup, i.e. only what has changed since last backup, nor will it when
PITR is implemented...thats something different again]

Best Regards, Simon Riggs, 2ndQuadrant




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


end of thread, other threads:[~2004-04-06 20:44 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-04-06 02:34 PostgreSQL backup issue Eric Yum <eric.yum@ck-lifesciences.com>
2004-04-06 15:53 Re: PostgreSQL backup issue Naomi Walker <nwalke@eldocomp.com>
2004-04-06 20:44 Re: PostgreSQL backup issue Simon Riggs <simon@2ndquadrant.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