On Wed, Nov 09, 2005 at 06:52:48PM +0800, Tito Mari Francis Escaño wrote: > Is there an issue on data handling compatibility between PostgreSQL 7.x and > 8.x?
I don't know yet but I think the best source of information for this matter is the release notes. > Would data dump from v7.x be acceptable to v8.x? The rule of thumb is to dump the old database using the pg_dump of the newer postgresql version. However, in my experience, whether or not it is an update/upgrade to a minor/major version, there are cases in which complex SQLs are not properly dumped and you have to manually fix it in order for the newer pgsql to understand it. > Our test app was developed using 7.x, specifically 7.4.8. Now, knowing > the features of version 8.x, particularly 8.0.4, I think this will > have a long-term benefit for the server if no issue will hinder. FWIW, 8.1 has just been released. You might consider upgrading into that version instead. HTH -- $_=q:; # SHERWIN # 70;72;69;6e;74;20; 27;4a;75;73;74;20; 61;6e;6f;74;68;65; 72;20;50;65;72;6c; 20;6e;6f;76;69;63; 65;27;:;;s=~?(..); ?=pack q$C$,hex$1; ;;;=egg;;;;eval;;; _________________________________________________ Philippine Linux Users' Group (PLUG) Mailing List [email protected] (#PLUG @ irc.free.net.ph) Read the Guidelines: http://linux.org.ph/lists Searchable Archives: http://archives.free.net.ph
