Re: Discrepancy in postgresql entry in UPDATING
On 12/16/2014 2:51 AM, Francois Tigeot wrote: With pg_upgrade, I found the best method to be: - locally build the two postgres versions you're interested in from the Postgres distfiles. - run pg_upgrade from one of them and don't bother with the packages. I hadn't thought about that. I could just build them in the ports tree and leave them staged. Thanks! ___ freebsd-ports@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-ports To unsubscribe, send any mail to "freebsd-ports-unsubscr...@freebsd.org"
Re: Discrepancy in postgresql entry in UPDATING
+--On 15 décembre 2014 17:41:30 -0800 Darren Pilgrim wrote: | The entry reads: | | 20141208: |AFFECTS: users of databases/postgresql??-(server|client) |AUTHOR: mar...@freebsd.org | |PostgreSQL version 9.3 is now the default. To upgrade from a version |lower than 9.3, follow the instructions on the PostgreSQL.org website. |http://www.postgresql.org/docs/9.3/interactive/upgrading.html |Please note that the pg_upgrade program is installed by the |databases/postgresql93-contrib port | |When using binary packages, if you only use the client port, you can |issue the following command to follow the default version: | |# pkg set -o | databases/postgresql92-client:databases/postgresql93-client | | The problem is pg_upgrade requires both the old and new versions be | installed concurrently--something pkg/ports can't do. So how are we | supposed to upgrade? You don't *need* both to be installed, you only really need the postgres binary for the old version. What I usually do is: pkg fetch postgresqlOLD-server cd /tmp tar xf /var/cache/pkg/postgresqlOLD-server* -s ,^,pg/, and run pg_upgrade with the old postgresql being in /tmp/pg/usr/local/bin. -- Mathieu Arnold ___ freebsd-ports@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-ports To unsubscribe, send any mail to "freebsd-ports-unsubscr...@freebsd.org"
Re: Discrepancy in postgresql entry in UPDATING
On Mon, Dec 15, 2014 at 05:41:30PM -0800, Darren Pilgrim wrote: > The entry reads: > > 20141208: [...] >When using binary packages, if you only use the client port, you can >issue the following command to follow the default version: > ># pkg set -o databases/postgresql92-client:databases/postgresql93-client > > The problem is pg_upgrade requires both the old and new versions be > installed concurrently--something pkg/ports can't do. So how are we > supposed to upgrade? With pg_upgrade, I found the best method to be: - locally build the two postgres versions you're interested in from the Postgres distfiles. - run pg_upgrade from one of them and don't bother with the packages. The Postgres packages are fine for regular operation but like you said, not really adapted for this kind of one shot operation IMHO. -- Francois Tigeot ___ freebsd-ports@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-ports To unsubscribe, send any mail to "freebsd-ports-unsubscr...@freebsd.org"
Discrepancy in postgresql entry in UPDATING
The entry reads: 20141208: AFFECTS: users of databases/postgresql??-(server|client) AUTHOR: mar...@freebsd.org PostgreSQL version 9.3 is now the default. To upgrade from a version lower than 9.3, follow the instructions on the PostgreSQL.org website. http://www.postgresql.org/docs/9.3/interactive/upgrading.html Please note that the pg_upgrade program is installed by the databases/postgresql93-contrib port When using binary packages, if you only use the client port, you can issue the following command to follow the default version: # pkg set -o databases/postgresql92-client:databases/postgresql93-client The problem is pg_upgrade requires both the old and new versions be installed concurrently--something pkg/ports can't do. So how are we supposed to upgrade? ___ freebsd-ports@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-ports To unsubscribe, send any mail to "freebsd-ports-unsubscr...@freebsd.org"