On Thu, Mar 27, 2014 at 7:11 PM, Manuel Kniep <manuel@xxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
