Re: Dump/Restore compatibility - Mailing list pgsql-novice

From Steve T
Subject Re: Dump/Restore compatibility
Date
Msg-id 1221042016.3603.63.camel@localhost.localdomain
Whole thread Raw
In response to Dump/Restore compatibility  (Steve T <steve@retsol.co.uk>)
Responses Re: Dump/Restore compatibility
List 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

pgsql-novice by date:

Previous
From: Dev
Date:
Subject: Inherting triggers
Next
From: Tom Lane
Date:
Subject: Re: translation question