Thread: 8.3.7 Windows Update Error
Using the following links to get to the PostgreSQL 8.3.7 (Windows) one-click installer: http://www.postgresql.org/download/windows http://www.enterprisedb.com/products/pgdownload.do#windows and then running the update utility, I get the following error message: "[Error] The existing data directory (Date/time setting: floating-point numbers) is not compatible with this server (Date/time setting: 64-bit integers)." Q1) Will a fresh install with dump and reload work? Q2) Is integer timestamps becoming the new default from the previous floating point data type? -- Regards, Richard Broersma Jr. Visit the Los Angeles PostgreSQL Users Group (LAPUG) http://pugs.postgresql.org/lapug
On Wed, 2009-03-25 at 10:25 -0700, Richard Broersma wrote: > Using the following links to get to the PostgreSQL 8.3.7 (Windows) > one-click installer: > > http://www.postgresql.org/download/windows > http://www.enterprisedb.com/products/pgdownload.do#windows > > and then running the update utility, I get the following error message: > > "[Error] > The existing data directory (Date/time setting: floating-point > numbers) is not compatible with this server (Date/time setting: 64-bit > integers)." > > > Q1) Will a fresh install with dump and reload work? Yes. > Q2) Is integer timestamps becoming the new default from the previous > floating point data type? > In 8.4 yes. Not sure why the windows installer does that now. Joshua D. Drake -- PostgreSQL - XMPP: jdrake@jabber.postgresql.org Consulting, Development, Support, Training 503-667-4564 - http://www.commandprompt.com/ The PostgreSQL Company, serving since 1997
Richard Broersma wrote: > Using the following links to get to the PostgreSQL 8.3.7 (Windows) > one-click installer: > > http://www.postgresql.org/download/windows > http://www.enterprisedb.com/products/pgdownload.do#windows > > and then running the update utility, I get the following error message: > > "[Error] > The existing data directory (Date/time setting: floating-point > numbers) is not compatible with this server (Date/time setting: 64-bit > integers)." > > > Q1) Will a fresh install with dump and reload work? Yes. > Q2) Is integer timestamps becoming the new default from the previous > floating point data type? My guess is that your previous install was from the community MSI installer, and not the one-click one. Could that be it? (and yes, it's becoming the new default I believe - but it doesn't (shouldn't) change between minor versions) //Magnus
On Wed, Mar 25, 2009 at 5:59 PM, Joshua D. Drake <jd@commandprompt.com> wrote: > >> Q2) Is integer timestamps becoming the new default from the previous >> floating point data type? >> > > In 8.4 yes. Not sure why the windows installer does that now. An error on my part - the one-click installer was originally released with integer datetimes when it shouldn't have been. Obviously I can't fix that now without breaking upgrades for users of just that package :-( So for 8.3 you *must* stick with one installer - though that is generally recommended anyway. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com
On Wed, Mar 25, 2009 at 11:00 AM, Magnus Hagander <magnus@hagander.net> wrote: >> Q2) Is integer timestamps becoming the new default from the previous >> floating point data type? > > My guess is that your previous install was from the community MSI > installer, and not the one-click one. Could that be it? Thanks guys! Yes this is correct. I am now downloading the community version. I am curious why the community version isn't the first choice listed in the PostgreSQL download page. (Not that it really matters which version is listed first.) -- Regards, Richard Broersma Jr. Visit the Los Angeles PostgreSQL Users Group (LAPUG) http://pugs.postgresql.org/lapug
On Wed, Mar 25, 2009 at 7:04 PM, Richard Broersma <richard.broersma@gmail.com> wrote: > On Wed, Mar 25, 2009 at 11:00 AM, Magnus Hagander <magnus@hagander.net> wrote: > >>> Q2) Is integer timestamps becoming the new default from the previous >>> floating point data type? >> >> My guess is that your previous install was from the community MSI >> installer, and not the one-click one. Could that be it? > > Thanks guys! > > Yes this is correct. I am now downloading the community version. I > am curious why the community version isn't the first choice listed in > the PostgreSQL download page. (Not that it really matters which > version is listed first.) They're both packaged by exactly the same community member. The one-click installer is listed first because it's easier to use and shields the user from many of the more advanced features in the MSI installer that some people find confusing. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com
Magnus Hagander <magnus@hagander.net> writes: > Richard Broersma wrote: >> Q2) Is integer timestamps becoming the new default from the previous >> floating point data type? > My guess is that your previous install was from the community MSI > installer, and not the one-click one. Could that be it? > (and yes, it's becoming the new default I believe - but it doesn't > (shouldn't) change between minor versions) Right, but in 8.3 and even before, different people have been putting out binary builds with different choices :-(. I'm not sure it's going to magically get better in 8.4. If Bruce gets anywhere with pg_migrator before 8.4 final, there will be a very strong temptation to stick with whatever one was using before, so as to avoid forcing a dump/reload... regards, tom lane