On Thu, Mar 27, 2014 at 7:11 PM, Manuel Kniep <manuel(at)adjust(dot)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