Re: postgresql versions

[Manuel Bouyer <bouyer%antioche.eu.org@localhost>]

On Fri, Dec 19, 2014 at 11:32:32AM -0500, Greg Troxel wrote:
> 
> Manuel Bouyer <bouyer%antioche.eu.org@localhost> writes:
> 
> > On Fri, Dec 19, 2014 at 01:15:03PM +0000, Roy Marples wrote:
> >> Interesting.
> >> 
> >> http://www.postgresql.org/docs/9.2/static/pgupgrade.html
> >> 
> >> Implies that both old server and new server need to be running on the
> >> same box. I wasn't aware our pkgsrc support that as they share the same
> >> rc.d script?
> >
> > No, they should not be run from the rc.d scripts. pg_upgrade start them
> > with the appropriate options (which are not the same as rc.d scripts),
> > and stop them afterward.
> >
> > pkgsrc doesn't support installing both versions at the same time, but
> > for the purpose of pg_upgrade, extracting the pkg tarball in /tmp
> > is enough (I've done it twice). I install the new version and extract the
> > previous one in /tmp, so that I can create the new database with
> > the new initdb.
> 
> So is pg_upgrade doing an upgrade, or automating the dump/restore?   It

I don 't know if it does only a dump/restore, or if it also transfers some
properties not inclued in the dump

-- 
Manuel Bouyer <bouyer%antioche.eu.org@localhost>
     NetBSD: 26 ans d'experience feront toujours la difference
--