Joshua Boyd <jb...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
