pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
pg_upgrade with --link then pg_basebackup for replication 2+ messages / 2 participants [nested] [flat]
* pg_upgrade with --link then pg_basebackup for replication @ 2015-11-03 00:39 Jorge Torralba <jorge.torralba@gmail.com> 0 siblings, 1 reply; 2+ messages in thread From: Jorge Torralba @ 2015-11-03 00:39 UTC (permalink / raw) To: pgsql-admin Here is an odd question. If one was to upgrade Postgres to 9.4 from 9.1 using the --link option, then setup replication using pg_basebackup, would the standby server preserve the hard links with the pg_basebackup or will -D /new/destination/data/dir be a clean unlinked version? Afterwards, if failing over to standby then failing back, would that implement a non linked version back on the primary if specifying a new data directory as well ? -- Thanks, Jorge Torralba ---------------------------- Note: This communication may contain privileged or other confidential information. If you are not the intended recipient, please do not print, copy, retransmit, disseminate or otherwise use the information. Please indicate to the sender that you have received this email in error and delete the copy you received. Thank You. ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: pg_upgrade with --link then pg_basebackup for replication @ 2015-11-04 14:49 Bruce Momjian <bruce@momjian.us> parent: Jorge Torralba <jorge.torralba@gmail.com> 0 siblings, 0 replies; 2+ messages in thread From: Bruce Momjian @ 2015-11-04 14:49 UTC (permalink / raw) To: Jorge Torralba <jorge.torralba@gmail.com>; +Cc: pgsql-admin On Mon, Nov 2, 2015 at 04:39:02PM -0800, Jorge Torralba wrote: > Here is an odd question. > > If one was to upgrade Postgres to 9.4 from 9.1 using the --link option, then > setup replication using pg_basebackup, would the standby server preserve the > hard links with the pg_basebackup or will -D /new/destination/data/dir be a > clean unlinked version? I will be clean. If you want to upgrade the the standby to 9.4 without a new basebackup, see this blog entry: http://momjian.us/main/blogs/pgblog/2015.html#June_10_2015 > Afterwards, if failing over to standby then failing back, would that implement > a non linked version back on the primary if specifying a new data directory as > well ? The links are only created on the server you run pg_upgrade, meaning normally not on the standby. -- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + As you are, so once was I. As I am, so you will be. + + Roman grave inscription + -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2015-11-04 14:49 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2015-11-03 00:39 pg_upgrade with --link then pg_basebackup for replication Jorge Torralba <jorge.torralba@gmail.com> 2015-11-04 14:49 ` Bruce Momjian <bruce@momjian.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox