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(at)jabber(dot)postgresql(dot)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

Magnus Hagander <magnus(at)hagander(dot)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

On Wed, Mar 25, 2009 at 11:00 AM, Magnus Hagander <magnus(at)hagander(dot)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 5:59 PM, Joshua D. Drake <jd(at)commandprompt(dot)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 7:04 PM, Richard Broersma
<richard(dot)broersma(at)gmail(dot)com> wrote:
> On Wed, Mar 25, 2009 at 11:00 AM, Magnus Hagander <magnus(at)hagander(dot)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