Re: [ADMIN] Problems with upgrading 6.3.1 to 6.4

PostgreSQL root user wrote:
>I've got a problem with converting my old database from version 6.3.1 to
>6.4. I tried pg_dumpall, but in the 6.4 psql cannot import it. It crashes
>with error. Maybe someone knows any other conversion utility? I've got a
>big database (pg_dumpall result is about 50MB), I am running linux 2.0.36.

What error?

If the problem is that pg_dump produces incorrect output, I have created a
backport of pg_dump from 6.4 to use with 6.3.2. This gets round a lot of
bugs I was suffering with 6.3.2 pg_dump. (It still doesn't cope with rules.)

If that would be useful, I'll send you the patch. (If you have already
deleted your old database, it will be of no use to you, because you
will have to install 6.3.2 to use it.)

--
Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight http://www.lfix.co.uk/oliver
PGP key from public servers; key ID 32B8FAA1
========================================
"Behold, happy is the man whom God correcteth.
Therefore despise thou not the chastening of the
Almighty." Job 5:17