Skip site navigation (1) Skip section navigation (2)

Re: Backup of live database

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Brian Modra <epailty(at)googlemail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Backup of live database
Date: 2008-01-16 07:02:53
Message-ID: 478DAC1D.3010909@commandprompt.com (view raw or flat)
Thread:
Lists: pgsql-admin
Brian Modra wrote:
> Hi,
> If tar reports that a file was modified while it was being archived, 
> does that mean that the file was archived correctly, or is it corrupted 
> in the archive?
> Does tar take a snapshot of the file so that even if it is modified, at 
> least the archive is safe?

You can not use tar to backup postgresql if it is running.

http://www.postgresql.org/docs/8.2/static/backup.html

Sincerely,

Joshua D. Drake

> Thanks
> 
> -- 
> Brian Modra   Land line: +27 23 5411 462
> Mobile: +27 79 183 8059
> 6 Jan Louw Str, Prince Albert, 6930
> Postal: P.O. Box 2, Prince Albert 6930
> South Africa


In response to

Responses

pgsql-admin by date

Next:From: Brian ModraDate: 2008-01-16 07:10:42
Subject: Re: Backup of live database
Previous:From: Brian ModraDate: 2008-01-16 06:57:23
Subject: Backup of live database

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group