Ah - that's what unpackaged meant. I read that page, but didn’t fully understand what it was referring to. Thank you for your quick reply. :)
Josh -----Original Message----- From: Kevin Grittner [mailto:[email protected]] Sent: Friday, November 22, 2013 1:21 PM To: Joshua Boyd; [email protected] Subject: Re: [GENERAL] Easiest way to CREATE EXTENSION when upgrading from 9.0 to 9.2? Joshua Boyd <[email protected]> wrote: > We have a pre-production environment that was running postgresql > 9.0 and we created the extension “pgcrypto” in it by feeding psql the > contrib/pgcrypto.sql .. We just upgraded to 9.2 (via > pg_upgrade) – naturally all the functions still exist, but pgcrypto is > not a registered extension with the database, nor is it the most > recent sql for the extension. What would be the easiest way to both > register and upgrade to the most recent version of pgcrypto in our new > version? Or is running a rollback script to remove all of those and > then running CREATE EXTENSION our only option? http://www.postgresql.org/docs/9.2/interactive/sql-createextension.html CREATE EXTENSION pgcrypto FROM unpackaged; -- Kevin Grittner EDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
