From 50742aed68b7a3a8d1a0c8ef8d970c97fc74dd9b Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Sun, 29 Aug 2004 21:08:48 +0000 Subject: Add WAL logging for CREATE/DROP DATABASE and CREATE/DROP TABLESPACE. Fix TablespaceCreateDbspace() to be able to create a dummy directory in place of a dropped tablespace's symlink. This eliminates the open problem of a PANIC during WAL replay when a replayed action attempts to touch a file in a since-deleted tablespace. It also makes for a significant improvement in the usability of PITR replay. --- doc/src/sgml/backup.sgml | 14 +++----------- 1 file changed, 3 insertions(+), 11 deletions(-) (limited to 'doc/src') diff --git a/doc/src/sgml/backup.sgml b/doc/src/sgml/backup.sgml index 7a3c4f73ff9..af06249203a 100644 --- a/doc/src/sgml/backup.sgml +++ b/doc/src/sgml/backup.sgml @@ -1,5 +1,5 @@ Backup and Restore @@ -902,17 +902,9 @@ restore_command = 'cp /mnt/server/archivedir/%f %p' At this writing, there are several limitations of the on-line backup - technique. These will probably be fixed in future releases. + technique. These will probably be fixed in future releases: - - - The effects of CREATE DATABASE, DROP DATABASE, - CREATE TABLESPACE, and DROP TABLESPACE are - not fully reflected in the WAL log. It is recommended that you take - a new base backup after performing one of these operations. - - Operations on non-btree indexes (hash, R-tree, and GiST indexes) are @@ -932,7 +924,7 @@ restore_command = 'cp /mnt/server/archivedir/%f %p' since we may need to fix partially-written disk pages. It is not necessary to store so many page copies for PITR operations, however. An area for future development is to compress archived WAL data by - removing unnecesssary page copies. + removing unnecessary page copies. -- cgit v1.2.3