Search Postgresql Archives

Re: How to restore from backup to 8.4.3 server using 9.0 dump/restore

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 ?

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.

Andrus.

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux