From: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
---|---|
To: | Manuel Kniep <manuel(at)adjust(dot)com> |
Cc: | PostgreSQL - General ML <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: is there a way to dump the version of extensions |
Date: | 2014-03-28 13:30:49 |
Message-ID: | CAB7nPqT0U_PguXXY3jvWfmQnjKvT=SELoJh79LRBD8_J8aev7w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2014-03-28 13:52:03 | Re: [GENERAL] openvz and shared memory trouble |
Previous Message | Khangelani Gama | 2014-03-28 12:55:50 | Re: Synchronizing a table that is in two different databases : Need to dump a table as inserts from db1 and change the insert statements into UPDATE statements |