On 12/15/2010 07:34 AM, Andrus Moor wrote:
No, this is just pilot error. Any version of pg_dump will produce
output that is meant to be loaded into the matching server version
(or a later version). If you are intending to load back into 8.4,
use the 8.4 pg_dump.
You may have been reading the recommendation to use the later version's
pg_dump when dumping an older server to perform an upgrade. It's good
advice, but only for upgrades.
Windows application needs to support backup/restore for all servers >=8
between same server version.
So it must distibute 8.0, 8.1, 8.2, 8.3, 8.4, 9.0 pg_dump/pg_restore
with application,
including all VC++ runtime versions and all dlls specific to this
version and invoke
specific pg_dump/pg_restore depending on server version ?
No it only needs to use the pg_dump/pg_restore that exist for each Pg
instance.
Do you really think that this is reasonable ?
I'nt there a simpler way ?
I havent seen that pg_admin includes every pg_dump / pg_restore version.
I don't use pgAdmin so I am flying blind here, but I guess they use some
variation of what I suggest above.
Andrus.
--
Adrian Klaver
adrian.klaver@xxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
