[GENERAL] 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] 8.3.7 Windows Update Error
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: jdr...@jabber.postgresql.org Consulting, Development, Support, Training 503-667-4564 - http://www.commandprompt.com/ The PostgreSQL Company, serving since 1997 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] 8.3.7 Windows Update Error
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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] 8.3.7 Windows Update Error
On Wed, Mar 25, 2009 at 5:59 PM, Joshua D. Drake j...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] 8.3.7 Windows Update Error
On Wed, Mar 25, 2009 at 11:00 AM, Magnus Hagander mag...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] 8.3.7 Windows Update Error
On Wed, Mar 25, 2009 at 7:04 PM, Richard Broersma richard.broer...@gmail.com wrote: On Wed, Mar 25, 2009 at 11:00 AM, Magnus Hagander mag...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] 8.3.7 Windows Update Error
Magnus Hagander mag...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general