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:kgrittn@xxxxxxxxx] Sent: Friday, November 22, 2013 1:21 PM To: Joshua Boyd; pgsql-general@xxxxxxxxxxxxxx Subject: Re: Easiest way to CREATE EXTENSION when upgrading from 9.0 to 9.2? Joshua Boyd <JBoyd@xxxxxxxxxxxxxxxx> 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 (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
