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

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(at)iol(dot)ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------