It's strange that you decided to make comparison to Oracle on this particular 
matter.
Oracle doesn't require during upgrades exporting all the data from the database 
and then importing - Oracle does upgrades "in-place", while with PG you can't 
upgrade without dump/restore.  And this becomes a problem (in PG) with large 
databases.

I'm not trying to start enother "war" compairing one DBMS to another (I have 
experience with both).
But, trashing Oracle that I'm seeing here lately, looks at least naïve - each 
db has it's advantages/disadvantages, but let's try to be at least somewhat 
objective.

Igor Neyman

-----Original Message-----
From: Gauthier, Dave [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 01, 2008 11:14 PM
To: pgsql-general@postgresql.org
Subject: That was easy

I just ported my whole DB instance, 4 db's inside with roles, triggers, stored 
procedures, etc... from v8.2.5 to v8.3.4. After the initdb, I mimiced the mods 
I had in the postgres.conf and pg_hba.conf files to v83.  Then I used 
pg_dumpall and psql to do the move. That was far and away the easiest DB 
upgrade I ever did.  It was fast and 100% clean.  Everything worked including 
remote attaches, all the perl/DBI scripts, even the odbc stuff on Windows 
worked... FIRST TRY !!!  I really don't miss the bad-ole days trying to do 
someting like this with Oracle.

 

Not many posts here are written to say "Great Job Guys".  This one is.  Thanks!

  


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

Reply via email to