[GENERAL] What is the best plan to upgrade PostgreSQL from an ancient version?

2009-01-26 Thread Dann Corbit
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. -- Sent via pgsql-general

Re: [GENERAL] What is the best plan to upgrade PostgreSQL from an ancient version?

2009-01-26 Thread Raymond O'Donnell
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

Re: [GENERAL] What is the best plan to upgrade PostgreSQL from an ancient version?

2009-01-26 Thread Raymond O'Donnell
On 26/01/2009 21:42, Raymond O'Donnell wrote: Off the top of my head, I have a memory that constraints were Sorry, I meant to say ...foreign key constraints... R. -- Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland

Re: [GENERAL] What is the best plan to upgrade PostgreSQL from an ancient version?

2009-01-26 Thread Steve Crawford
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.

Re: [GENERAL] What is the best plan to upgrade PostgreSQL from an ancient version?

2009-01-26 Thread Tom Lane
Dann Corbit dcor...@connx.com writes: 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

Re: [GENERAL] What is the best plan to upgrade PostgreSQL from an ancient version?

2009-01-26 Thread Steve Atkins
On Jan 26, 2009, at 6:33 PM, Tom Lane wrote: Dann Corbit dcor...@connx.com writes: 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?

Re: [GENERAL] What is the best plan to upgrade PostgreSQL from an ancient version?

2009-01-26 Thread Craig Ringer
Tom Lane wrote: Dann Corbit dcor...@connx.com writes: 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

Re: [GENERAL] What is the best plan to upgrade PostgreSQL from an ancient version?

2009-01-26 Thread marcin mank
On Mon, Jan 26, 2009 at 10:37 PM, Dann Corbit dcor...@connx.com 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

Re: [GENERAL] What is the best plan to upgrade PostgreSQL from an ancient version?

2009-01-26 Thread Joshua D. Drake
On Tue, 2009-01-27 at 04:28 +0100, marcin mank wrote: On Mon, Jan 26, 2009 at 10:37 PM, Dann Corbit dcor...@connx.com 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

Re: [GENERAL] What is the best plan to upgrade PostgreSQL from an ancient version?

2009-01-26 Thread David Fetter
On Mon, Jan 26, 2009 at 06:45:55PM -0800, Steve Atkins wrote: On Jan 26, 2009, at 6:33 PM, Tom Lane wrote: Dann Corbit dcor...@connx.com writes: 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

Re: [GENERAL] What is the best plan to upgrade PostgreSQL from an ancient version?

2009-01-26 Thread Tom Lane
David Fetter da...@fetter.org writes: I think you may be thinking of the situation where foreign keys were implemented as visible triggers, and the contrib/adddepend script, which was removed (IIRC) in 8.2. We replaced it with some hacks in CREATE TRIGGER, so theoretically that conversion