On 26/01/2009 21:37, Dann Corbit wrote: > My notion is to do a character mode database dump as SQL statements and > then load into the new version by execution of psql against the sql > STATEMENTS. > > What are the "gotchas" we can expect with this approach? > > When I say 'ancient' I mean v7.1.3 and the target is v8.3.5. Off the top of my head, I have a memory that constraints were once-upon-a-time implemented as triggers, whereas now they're "real" foreign keys.... I once loaded an old database dump into a new server, and then had to drop the triggers and create the foreign keys. I can't remember what version the old database came from, though. Ray. ------------------------------------------------------------------ Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod@xxxxxx Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
