From 4eb4b3f24561cb115b24984c755b2a75155afedf Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Thu, 4 Aug 2016 18:55:16 -0400 Subject: [PATCH] docs: mention rsync of temp and unlogged tables This happens when using rsync to pg_upgrade slaves. Reported-by: Jerry Sievers Discussion: 20160726161946.GA3511@momjian.us --- doc/src/sgml/ref/pgupgrade.sgml | 2 ++ 1 file changed, 2 insertions(+) diff --git a/doc/src/sgml/ref/pgupgrade.sgml b/doc/src/sgml/ref/pgupgrade.sgml index fcc94ee592..7f1c52a833 100644 --- a/doc/src/sgml/ref/pgupgrade.sgml +++ b/doc/src/sgml/ref/pgupgrade.sgml @@ -504,6 +504,8 @@ rsync --archive --delete --hard-links --size-only old_pgdata new_pgdata remote_d + Unfortunately, rsync also needlessly copies the + files associated with temporary and unlogged tables. If you have tablespaces, you will need to run a similar rsync command for each tablespace directory. If you have relocated pg_xlog outside the data directories, -- 2.39.5