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: 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

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

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 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 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