| 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 |
| Message-ID: | 20150122192051.GJ27749@momjian.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ Everyone has their own god. +
| Attachment | Content-Type | Size |
|---|---|---|
| rsync.diff | text/x-diff | 1.2 KB |
| 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? |