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 har
> 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
>
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 phys
I wrote to Peter Wilson some day ago:
I had problems, like that. I've omitted them using "plain" format (SQL
script file) of dump file. I restore data from "plain" format with psql
- using command "\i FILE". It work always. If You gzip this "plain" file
- You become simillar volume of file usi
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 cours
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 wit
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
> i
On Nov 30, 2006, at 5:52 AM, Peter Eisentraut wrote:
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 database
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 op
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.
10 matches
Mail list logo