Upgrading from 8.3.14 to 8.3.16 on Windows

From: jonesd(at)xmission(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: Upgrading from 8.3.14 to 8.3.16 on Windows
Date: 2011-11-18 17:53:26
Message-ID: 20111118105326.73d64o6s0cs04g4o@webmail.xmission.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I just ran the upgrade process for updating my PostgreSQL installation
(running on Windows XP) from 8.3.14 to 8.3.16. I used pgInstaller's
UPGRADE script to conduct the upgrade. It appeared to work without
problems.

When I tried to verify that the upgrade took place, I noticed
something odd. The query "SELECT version();" produced "PostgreSQL
8.3.13, compiled by Visual C++ build 1400" - a different version
number than I was expecting.

I followed up by inspecting the contents of the PostgreSQL directory
on my machine. A number of files show modification dates of
2011-09-22 or 2011-09-23, which seems to indicate that the update took
place. However, I'm concerned over the fact that the version number
is reporting an earlier version. I did use the UPGRADE script to move
from 8.3.13 to 8.3.14 as well.

So, I'm trying to figure out whether the UPGRADE script is not working
for me or whether the version() function is not reporting accurate
information.

Dominic Jones

Browse pgsql-general by date

  From Date Subject
Next Message Gauthier, Dave 2011-11-18 19:55:55 How to use like with a list
Previous Message Steve Crawford 2011-11-18 17:29:51 Re: Huge number of INSERTs