Обсуждение: Easiest way to CREATE EXTENSION when upgrading from 9.0 to 9.2?
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?
Thanks,
Josh
Joshua Boyd <JBoyd@nxsystemsinc.com> 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
Ah - that's what unpackaged meant. I read that page, but didn’t fully understand what it was referring to. Thank you foryour quick reply. :) Josh -----Original Message----- From: Kevin Grittner [mailto:kgrittn@ymail.com] Sent: Friday, November 22, 2013 1:21 PM To: Joshua Boyd; pgsql-general@postgresql.org Subject: Re: [GENERAL] Easiest way to CREATE EXTENSION when upgrading from 9.0 to 9.2? Joshua Boyd <JBoyd@nxsystemsinc.com> 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