Re: HELP!! upgrade from 8.3.2 to 8.3.5 caused "FATAL: database files are incompatible with server"

On 29/01/2009 09:38, Vishal Gupta wrote:
> Yes that's the case, is that the root cause?
> -----Original Message-----
>> From: Raymond O'Donnell [mailto:rod@iol.ie] 
> Sent: Thursday, January 29, 2009 2:56 PM
> To: Vishal Gupta
> Cc: pgadmin-support@postgresql.org
> Subject: Re: [pgadmin-support] HELP!! upgrade from 8.3.2 to 8.3.5 caused
> "FATAL: database files are incompatible with server"
> 
> On 29/01/2009 09:09, vhgupta wrote:
>> Upgrade from 8.3.2 to 8.3.5 was done, by stopping the server first,
> followed
>> the wizard(one-click installer).
> 
> Only guessing, but did you use a different installer (e.g. the
> pgInstaller) for the installation of 8.3.2?


Yes, that's it - the versions in the two different installers must have
been compiled with slightly different configurations.

As Dave said, you should uninstall the older version (having first
stopped the server and taken a backup for safety - being a
belt-and-braces guy, I'd use pg_dump and take a filesystem backup also),
then install the new version, pointing it at the existing data directory.

Ray.

------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------