Skip site navigation (1) Skip section navigation (2)

Re: PostgreSQL upgrade server A -> server B

From: Hannes Dorbath <light(at)theendofthetunnel(dot)de>
To: CAJ CAJ <pguser(at)gmail(dot)com>
Subject: Re: PostgreSQL upgrade server A -> server B
Date: 2007-04-27 07:33:20
Message-ID: 4631A740.60601@theendofthetunnel.de (view raw or flat)
Thread:
Lists: pgsql-general
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 database directly on another server
> without having to dump to the filesystem and then restore it.
> 
> pg_dump on new server might look something like,
> pg_dump <options> -h <old server> -h <new_server> dbname
> 
> or can it be used as-is by piping it?
> 
> pg_dump <options> -h <old server> dbname | pg_restore


Maybe consider using slony to get your data over as well..


-- 
Regards,
Hannes Dorbath

In response to

pgsql-general by date

Next:From: Richard HuxtonDate: 2007-04-27 07:40:22
Subject: Re: binary representation of date and numeric
Previous:From: Felix KaterDate: 2007-04-27 07:22:47
Subject: binary representation of date and numeric

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group