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
> 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.
grzm seespotcode net
In response to
pgsql-general by date
|Next:||From: CAJ CAJ||Date: 2007-04-27 01:34:36|
|Subject: Re: PostgreSQL upgrade server A -> server B|
|Previous:||From: CAJ CAJ||Date: 2007-04-27 01:09:30|
|Subject: PostgreSQL upgrade server A -> server B|