[Slackbuilds-users] Upgrading postgres

Eugen Wissner belka at caraus.de
Thu Jun 8 19:39:42 UTC 2017


No, you don't.

You have to use pg_upgrade only if you make a major update (from 9.5 to
9.6 for example). Just build the package, stop postgresql, do
upgradepkg and start postgresql again.

Regards,
Eugene

Am Donnerstag, den 08.06.2017, 12:35 -0700 schrieb Rich Shepard:
>    Now postgresql-9.6.2 is installed in /var/lib/pgsql/9.6/. To
> upgrade using
> the SBo script to version -9.6.3 do I need to install it in a
> different
> subdirectory then use pg_upgrade to transfer pointers to the binary
> and data
> directories from the 9.6.2 location to the 9.6.3 location?
> 
>    Or, do I use pg_dumpall, upgrade micro versions, then use psql to
> read the
> dumped data file into the new version?
> 
> Rich
> _______________________________________________
> SlackBuilds-users mailing list
> SlackBuilds-users at slackbuilds.org
> http://lists.slackbuilds.org/mailman/listinfo/slackbuilds-users
> Archives - https://lists.slackbuilds.org/pipermail/slackbuilds-users/
> FAQ - https://slackbuilds.org/faq/
> 


More information about the SlackBuilds-users mailing list