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

Re: BUG #4548: Documentation Contradiction for 8.3

From: Bill Moran <wmoran(at)collaborativefusion(dot)com>
To: "Barry Reddy" <barryreddy(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4548: Documentation Contradiction for 8.3
Date: 2008-11-24 21:41:11
Message-ID: 20081124164111.0d2e6e91.wmoran@collaborativefusion.com (view raw or flat)
Thread:
Lists: pgsql-bugs
In response to "Barry Reddy" <barryreddy(at)gmail(dot)com>:
> 
> The following bug has been logged online:
> 
> Bug reference:      4548
> Logged by:          Barry Reddy
> Email address:      barryreddy(at)gmail(dot)com
> PostgreSQL version: 8.3.3
> Operating system:   Linux 2.6.24-19-server i686 RHEL5
> Description:        Documentation Contradiction for 8.3
> Details: 
> 
> I’ve been going over the PostgreSQL documentation for pg_archiving,
> And have been struck by an apparent contradiction, which I’m hoping
> To clarify…not sure if you have any thoughts, or can refer this to any
> Contacts for a clarification, if so, feel free to forward.
> 
> http://www.postgresql.org/docs/8.3/interactive/backup-file.html
> 
> 1.	The database server must be shut down in order to get a usable backup.
> Half-way measures such as disallowing all connections will not work (in part
> because tar and similar tools do not take an atomic snapshot of the state of
> the file system, but also because of internal buffering within the server).
> Information about stopping the server can be found in Section 17.5. Needless
> to say that you also need to shut down the server before restoring the
> data.
> 
> http://www.postgresql.org/docs/8.3/interactive/continuous-archiving.html#BAC
> KUP-BASE-BACKUP
> 
> 3.	Perform the backup, using any convenient file-system-backup tool such as
> tar or cpio. It is neither necessary nor desirable to stop normal operation
> of the database while you do this.
> 
> Can anyone clarify if this apparent contradiction is an oversight ?  Old
> documentation with new archiving documentation patched on, with no attention
> paid to the seeming contradiction on guidelines for filesystem backups of a
> running PG database ?

The data is correct and non-contradictory.  The problem is that you're
reading two different documents on two different methods of making
backups.  The methods have different rules that must be followed to
get a good backup.

-- 
Bill Moran
Collaborative Fusion Inc.
http://people.collaborativefusion.com/~wmoran/

wmoran(at)collaborativefusion(dot)com
Phone: 412-422-3463x4023

In response to

pgsql-bugs by date

Next:From: Peter EisentrautDate: 2008-11-24 21:55:17
Subject: Re: BUG #4548: Documentation Contradiction for 8.3
Previous:From: Barry ReddyDate: 2008-11-24 21:37:02
Subject: BUG #4548: Documentation Contradiction for 8.3

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