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

Re: Dump/Restore compatibility

From: Steve T <steve(at)retsol(dot)co(dot)uk>
To: PostGreSQL <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Dump/Restore compatibility
Date: 2008-09-10 10:20:16
Message-ID: 1221042016.3603.63.camel@localhost.localdomain (view raw or flat)
Thread:
Lists: pgsql-novice
Does anyone here know about this or should I post this on another list?


On Tue, 2008-08-26 at 08:57 +0100, Steve T wrote:

> I am building a new server that is running PostgreSQL 8.1.11 under
> RHEL5. My current 'live' server is PostgreSQL 8.0.3 under FC4 with an
> FC4 8.0.3 backup server. 
> What I want to do is to swap the RHEL5 (ie 8.1.11) in as the live and
> demote the live to backup and the backup to 'spare'. Currently, the
> live databases are dumped and restored onto the backup box. Can I do
> the same across the releases - ie dump the 8.1.11 and restore that
> dump on 8.0.3?  
> 
> 
> 



Steve Tucknott
ReTSol Ltd

DDI:         01323 488548
Mobile:     0773 671 5772

In response to

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2008-09-10 12:57:06
Subject: Re: translation question
Previous:From: DevDate: 2008-09-10 08:02:34
Subject: Inherting triggers

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