I've heared that upgrading is more painfull with PostgreSQL, since you have to dump the databases and restore them again after the upgrade
Dump and rebuild is an easy and reliable way to preserve your data through db engine updates. Are you saying that if the binary formats were compatible, you'd just run the upgrade without backing up your data?
With PostgreSQL, my normal backups are done by dumping the data into gzipped SQL files. Including the db structure in the dump does not add significant processing overhead or storage requirements.
So really, the difference is between "tar -czvf db_backup.tar.gz /data/dir" or "pg_dumpall | gzip - > db_backup.gz"
Tony -- Anthony E. Greene <mailto:[EMAIL PROTECTED]> OpenPGP Key: 0x6C94239D/7B3D BD7D 7D91 1B44 BA26 C484 A42A 60DD 6C94 239D AOL/Yahoo Chat: TonyG05 HomePage: <http://www.pobox.com/~agreene/> Linux. The choice of a GNU generation. <http://www.linux.org/>
-- redhat-list mailing list unsubscribe mailto:[EMAIL PROTECTED] https://listman.redhat.com/mailman/listinfo/redhat-list
