On Apr 26, 2007, at 20:09 , CAJ CAJ wrote:
> Upgrading large postgres databases (100GB+) takes awfully long time
> when doing dump/restore. I was wondering if this process can be
> optimized by directly dumping to a new version of Pg database
> directly on another server without having to dump to the filesystem
> and then restore it.
From the fine documentation in the section entitled "Migration
Between Releases"
http://www.postgresql.org/docs/8.2/interactive/migration.html
> The least downtime can be achieved by installing the new server in
> a different directory and running both the old and the new servers
> in parallel, on different ports. Then you can use something like
>
> pg_dumpall -p 5432 | psql -d postgres -p 6543
>
> to transfer your data.
Hope that helps.
Michael Glaesemann
grzm seespotcode net
