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:
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?
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:
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
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.
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
Ah, I see. Thanks. Well I think that information would still be useful in
the docs.
Thom