From 8694cc96b52a967a49725f32be7aa77fd3b6ac25 Mon Sep 17 00:00:00 2001 From: Teodor Sigaev Date: Fri, 23 Mar 2018 19:14:12 +0300 Subject: Exclude unlogged tables from base backups Exclude unlogged tables from base backup entirely except init fork which marks created unlogged table. The next question is do not backup temp table but it's a story for separate patch. Author: David Steele Review by: Adam Brightwell, Masahiko Sawada Discussion: https://www.postgresql.org/message-id/flat/04791bab-cb04-ba43-e9c0-664a4c1ffb2c@pgmasters.net --- doc/src/sgml/protocol.sgml | 6 ++++++ 1 file changed, 6 insertions(+) (limited to 'doc/src') diff --git a/doc/src/sgml/protocol.sgml b/doc/src/sgml/protocol.sgml index 366b6842934..472bd3ef693 100644 --- a/doc/src/sgml/protocol.sgml +++ b/doc/src/sgml/protocol.sgml @@ -2568,6 +2568,12 @@ The commands accepted in replication mode are: with pgsql_tmp. + + + Unlogged relations, except for the init fork which is required to + recreate the (empty) unlogged relation on recovery. + + pg_wal, including subdirectories. If the backup is run -- cgit v1.2.3