Re: pg_upgrade and rsync

Bruce,

* Bruce Momjian (bruce@momjian.us) wrote:
> On Tue, Jan 27, 2015 at 09:36:58AM -0500, Stephen Frost wrote:
> > The example listed works, but only when it's a local rsync:
> >
> > rsync --archive --hard-links --size-only old_dir new_dir remote_dir
> >
> > Perhaps a better example (or additional one) would be with a remote
> > rsync, including clarification of old and new dir, like so:
> >
> > (run in /var/lib/postgresql)
> > rsync --archive --hard-links --size-only \
> >   9.3/main \
> >   9.4/main \
> >   server:/var/lib/postgresql/
> >
> > Note that 9.3/main and 9.4/main are two source directories for rsync to
> > copy over, while server:/var/lib/postgresql/ is a remote destination
> > directory.  The above directories match a default Debian/Ubuntu install.
>
> OK, sorry everyone was confused by 'remote_dir'.  Does this new patch
> help?

Looks better, but --links is not the same as --hard-links.  The example
is right, the but documentation below it mentions "<option>--link</>"
which is for symlinks, not hard links.

This also should really include a discussion about dealing with
tablespaces, since the example command won't deal with them.
Thanks,
    Stephen