Обсуждение: HELP!! upgrade from 8.3.2 to 8.3.5 caused "FATAL: database files are incompatible with server"
Opearting System :XP Upgrade from 8.3.2 to 8.3.5 was done, by stopping the server first, followed the wizard(one-click installer). Please help. Getting this error in eventviewer. 2009-01-29 14:22:14 IST FATAL: database files are incompatible with server 2009-01-29 14:22:14 IST DETAIL: The database cluster was initialized without HAVE_INT64_TIMESTAMP but the server was compiled with HAVE_INT64_TIMESTAMP. 2009-01-29 14:22:14 IST HINT: It looks like you need to recompile or initdb. -- View this message in context: http://www.nabble.com/HELP%21%21-upgrade-from-8.3.2-to-8.3.5-caused-%22FATAL%3A--database-files-are-incompatible-with-server%22-tp21722897p21722897.html Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.
Re: HELP!! upgrade from 8.3.2 to 8.3.5 caused "FATAL: database files are incompatible with server"
От
Raymond O'Donnell
Дата:
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? In any case, it might be better to post to the main pgsql_general list - this one is for pgAdmin, whereas your question is about PostgreSQL itself. You'll have a much wider audience there also. Ray. ------------------------------------------------------------------ Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod@iol.ie Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------
This is entirely the wrong list for this question but... On Thu, Jan 29, 2009 at 9:09 AM, vhgupta <vishal.g@pinelabs.com> wrote: > > Opearting System :XP > > Upgrade from 8.3.2 to 8.3.5 was done, by stopping the server first, followed > the wizard(one-click installer). > Please help. 'Upgrades' from the community installer to the one-click installer are not supported. You should use the newer community installer to upgrade. Take a backup to be safe, then uninstall the server software. Then reinstall the correct installer, using the existing data directory. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com
Yes that's the case, is that the root cause? Thanks, Vishal B-34/1, Sector 59, Noida - 201301, India Tel :- +91 120 406 3059| Mobile :- +91 9910991635 | Fax : +91 120 258 5721 www.pinelabs.com -----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? In any case, it might be better to post to the main pgsql_general list - this one is for pgAdmin, whereas your question is about PostgreSQL itself. You'll have a much wider audience there also. Ray. ------------------------------------------------------------------ Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod@iol.ie Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------
Re: HELP!! upgrade from 8.3.2 to 8.3.5 caused "FATAL: database files are incompatible with server"
От
Raymond O'Donnell
Дата:
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 ------------------------------------------------------------------
Using the pginstaller for the purpose worked, thanks for help and apologies for mistaking the wrong list. -- View this message in context: http://www.nabble.com/HELP%21%21-upgrade-from-8.3.2-to-8.3.5-caused-%22FATAL%3A--database-files-are-incompatible-with-server%22-tp21722897p21724261.html Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.
Re: HELP!! upgrade from 8.3.2 to 8.3.5 caused "FATAL: database files are incompatible with server"
От
Raymond O'Donnell
Дата:
On 29/01/2009 10:29, vhgupta wrote: > Using the pginstaller for the purpose worked, thanks for help and apologies > for mistaking the wrong list. No problem - glad you got sorted. Ray. ------------------------------------------------------------------ Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod@iol.ie Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------