Thread: pg_dump custom format across versions
Hi,
Does anyone know if there are issues with performing a pg_dump in custom format in one major version, and using pg_restore on it on a higher version?
Thanks
Thom
On Wed, 2010-05-12 at 19:05 +0100, Thom Brown wrote: > Hi, > > > Does anyone know if there are issues with performing a pg_dump in > custom format in one major version, and using pg_restore on it on a > higher version? You want to use the pg_dump from the higher version. Joshua D. Drake > > > Thanks > > > Thom -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom Development, Engineering
On 12 May 2010 19:29, Joshua D. Drake <jd@commandprompt.com> wrote:
You want to use the pg_dump from the higher version.On Wed, 2010-05-12 at 19:05 +0100, Thom Brown wrote:
> Hi,
>
>
> Does anyone know if there are issues with performing a pg_dump in
> custom format in one major version, and using pg_restore on it on a
> higher version?
Joshua D. Drake
Am I to gather that there are possible incompatibilities?
Thom
On Wed, 2010-05-12 at 19:33 +0100, Thom Brown wrote: > On 12 May 2010 19:29, Joshua D. Drake <jd@commandprompt.com> wrote: > > On Wed, 2010-05-12 at 19:05 +0100, Thom Brown wrote: > > Hi, > > > > > > Does anyone know if there are issues with performing a > pg_dump in > > custom format in one major version, and using pg_restore on > it on a > > higher version? > > > You want to use the pg_dump from the higher version. > > Joshua D. Drake > > > Am I to gather that there are possible incompatibilities? Definitely. Joshua D. Drake > > > Thom > -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom Development, Engineering
On 12 May 2010 19:40, Joshua D. Drake <jd@commandprompt.com> wrote:
Definitely.On Wed, 2010-05-12 at 19:33 +0100, Thom Brown wrote:
> On 12 May 2010 19:29, Joshua D. Drake <jd@commandprompt.com> wrote:
>
> On Wed, 2010-05-12 at 19:05 +0100, Thom Brown wrote:
> > Hi,
> >
> >
> > Does anyone know if there are issues with performing a
> pg_dump in
> > custom format in one major version, and using pg_restore on
> it on a
> > higher version?
>
>
> You want to use the pg_dump from the higher version.
>
> Joshua D. Drake
>
>
> Am I to gather that there are possible incompatibilities?
Joshua D. Drake
Thanks for the info Joshua.
In that case, it might be an idea to clarify that on the documentation. I couldn't find this information.
Thom
Thom Brown <thombrown@gmail.com> writes:
> On 12 May 2010 19:40, Joshua D. Drake <jd@commandprompt.com> wrote:
>>> Am I to gather that there are possible incompatibilities?
>>
>> Definitely.
> In that case, it might be an idea to clarify that on the documentation. I
> couldn't find this information.
If it were true, it would be in the documentation.
The reason for suggesting that you use the newer pg_dump during a
version upgrade is that the newer version might have bug fixes that
your current version lacks. In the absence of bugs, however, pg_restore
is supposed to read dump files produced by older versions of pg_dump.
If it fails to, that in itself is a filable bug.
regards, tom lane
On 12 May 2010 20:18, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Thom Brown <thombrown@gmail.com> writes:
> On 12 May 2010 19:40, Joshua D. Drake <jd@commandprompt.com> wrote:>>> Am I to gather that there are possible incompatibilities?
>>
>> Definitely.> In that case, it might be an idea to clarify that on the documentation. IIf it were true, it would be in the documentation.
> couldn't find this information.
The reason for suggesting that you use the newer pg_dump during a
version upgrade is that the newer version might have bug fixes that
your current version lacks. In the absence of bugs, however, pg_restore
is supposed to read dump files produced by older versions of pg_dump.
If it fails to, that in itself is a filable bug.
regards, tom lane
Ah, I see. Thanks. Well I think that information would still be useful in the docs.
Thom
On Wed, 2010-05-12 at 19:05 +0100, Thom Brown wrote: > Hi, > > > Does anyone know if there are issues with performing a pg_dump in > custom format in one major version, and using pg_restore on it on a > higher version? You want to use the pg_dump from the higher version. Joshua D. Drake > > > Thanks > > > Thom -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom Development, Engineering
On Wed, 2010-05-12 at 19:33 +0100, Thom Brown wrote: > On 12 May 2010 19:29, Joshua D. Drake <jd@commandprompt.com> wrote: > > On Wed, 2010-05-12 at 19:05 +0100, Thom Brown wrote: > > Hi, > > > > > > Does anyone know if there are issues with performing a > pg_dump in > > custom format in one major version, and using pg_restore on > it on a > > higher version? > > > You want to use the pg_dump from the higher version. > > Joshua D. Drake > > > Am I to gather that there are possible incompatibilities? Definitely. Joshua D. Drake > > > Thom > -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom Development, Engineering