[Slackbuilds-users] Upgrading Postgres

[Adis Nezirovic]

Rich,

There are some details about upgrade procedure in README.SBo file, you
can try to follow them if you want to use pg_upgrade. If you want to
use pg_dump, then after you create the dump, you can upgrade
PostgreSQL package and load sql into new

Regarding the directories in /var/lib/pgsql, generally, it is not
necessary to run pg_dump/pg_restore or pg_upgrade for patch version
upgrades, so instead of /var/lib/pgsql/$MAJOR.$MINOR.$PATCH, the
directory only contains $MAJOR.$MINOR, and you don't need to change
anything in SlackBuild.

Please copy database dump to some safe directory before running
upgrade scripts, in case something goes wrong :-)
If you need additional help, feel free to ask either on the list or on
my private email.

Best regards,
Adis


On Sat, Mar 14, 2015 at 11:15 PM, Rich Shepard <rshepard at appl-ecosys.com> wrote:
>   Currently, postgresql-9.3.4 is installed in /var/lib/pgsql/9.3.4/ and I
> want to upgrade to postgresql-9.4.1. As user postgres I ran pg_dumpall to a
> .sql file that I can read into the new version in /var/lib/pgsql/9.4.1/.
>
>   The SlackBuild file shows
>
> VERSION=${VERSION:-9.4.1}
>
> and
>
> PG_VERSION=${PG_VERSION:-9.4}
>
>   Do I need to change the latter to 9.4.1 to have that as the subdirctory
> name in /var/lib/pgsql/?
>
> Rich
>
> _______________________________________________
> SlackBuilds-users mailing list
> SlackBuilds-users at slackbuilds.org
> http://lists.slackbuilds.org/mailman/listinfo/slackbuilds-users
> Archives - http://lists.slackbuilds.org/pipermail/slackbuilds-users/
> FAQ - http://slackbuilds.org/faq/
>