Re: [GENERAL] PostgreSQL upgrade server A -> server B

2007-04-27 Thread Hannes Dorbath
On 27.04.2007 03:09, CAJ CAJ wrote: Forgive me if this has been discussed before (or if it sounds absurd) 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 datab

Re: [GENERAL] PostgreSQL upgrade server A -> server B

2007-04-26 Thread CAJ CAJ
> 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

Re: [GENERAL] PostgreSQL upgrade server A -> server B

2007-04-26 Thread Michael Glaesemann
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