On Sat, Feb 20, 2010 at 10:42 PM, Andrzej Zawadzki <zawadaa@gmail.com> wrote:
> Downgrade to 7.4
> Dump
> Upgrade
> Restore
>
Actually that's not the best way.
The best way is to install 7.4 and 8.1.19 (not 8.1.11 which has known
bugs) at the same time.
Use the pg_dump *from* *8.1.19* to connect to the 7.4 server and dump
the database.
Then shut down 7.4 and start up 8.1.19 and use pg_restore to restore
the database.
--
greg