is there a way to dump the version of extensions

On Thu, Mar 27, 2014 at 7:11 PM, Manuel Kniep <manuel@adjust.com> wrote:

Hi,

when doing a pg_dump on postgres 9.2 the resulting sql file only has

CREATE EXTENSION extension_name;

I would like to include the specific version of the extension to make sure that the correct version
is installed when loading the dump like

CREATE EXTENSION extension_name VERSION vesion;

Is there a way to do that?

With pg_dump only, no. It only dumps CREATE EXTENSION with the
extension name and the schema on which it is created to ensure that
the latest version available with server is created. You could always
correct by hand the dump file created though, just be sure that the
version of the extension you are compiling is compatible with the
server you are going to load the dump to.
Regards,
--
Michael

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general