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