On the other hand, dumping a newer version database with an older
version of *pg_dump* is much more likely to succeed. It's not a
guarantee, but it should get you pretty close. And as someone else
mentioned, doing a plain text dump is probably your best bet in this case.
No, that's not an
Jim Nasby [EMAIL PROTECTED] writes:
On the other hand, dumping a newer version database with an older
version of *pg_dump* is much more likely to succeed.
You meant to say that the other way around, no? Certainly for a jump
this big I'd rather expect the older pg_dump to fail altogether.
[
Richard Broersma Jr wrote:
My understanding is that dumps are not backwards compatible. Any dumps created
with a Version 8.*
pg_dump cannot be used for any older versions. If you want play it safe you
should create a new
server for the postgresql version 8.1 to preform validation tests with
Shane Ambler wrote:
I don't see that as being the case - there will be exceptions where
you have new features in an 8.x database that won't work in a 7.x db
but otherwise it shouldn't matter, the dumps can be used to import
into other databases than postgres as long as you use dump with
Hi to all,
We have a pretty big database that is going for an upgrade (PG7 - PG8)
in the next few days, we have tested all the features of our application
but we cannot be sure that everything will work out perfectly (db is
managing several blob's only tables that have proven to be pretty
We have a pretty big database that is going for an upgrade (PG7 - PG8)
in the next few days, we have tested all the features of our application
but we cannot be sure that everything will work out perfectly (db is
managing several blob's only tables that have proven to be pretty hard
to
Hi,
I've already made almost same upgrade (7.4-8.1) under Debian linux.
On Debian the 8.1 database structure will be installed into
/var/lib/postgresql/ by default and on 7.4 it's /var/lib/postgres/. So
if you remove the packages and you (or your package manager) do not
remove the databases
Thank you for this infos, I wasn't sure about this, now, at least, I know
that this is not possible.
On the other hand, even the most experienced database programmer /
administrator when upgrading a production environment can't be 100% sure
about whether the application,will fail or not.
Of