pg_upgrade and rsync

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Cc: Josh Berkus <josh(at)agliodbs(dot)com>
Subject: pg_upgrade and rsync
Date: 2015-01-22 19:20:51
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

It is possible to upgrade on pg_upgrade on streaming standby servers by
making them master servers, running pg_upgrade on them, then shuting
down all servers and using rsync to make the standby servers match the
real master.

However, Josh Berkus reported that he found that hint bits set on the
master server but not on the standby servers made rsync too slow.

The attached pg_upgrade doc patch recommends using wal_log_hints to make
hint bits on the standby match the master. One question I have is
whether hint bits are set by read-only transactions on standby servers.

Bruce Momjian <bruce(at)momjian(dot)us>

+ Everyone has their own god. +

Attachment Content-Type Size
rsync.diff text/x-diff 1.2 KB


Browse pgsql-hackers by date

  From Date Subject
Next Message Jim Nasby 2015-01-22 19:36:04 Re: Proposal: knowing detail of config files via SQL
Previous Message Andres Freund 2015-01-22 18:56:07 Re: basebackups during ALTER DATABASE ... SET TABLESPACE ... not safe?