pgInstaller is not being maintained for PostgreSQL 8.4

[raster846]

Hi,
I am attempting to upgrade to PostgreSQL version 8.4, but have run across a problem. The pgInstaller distribution of PostgreSQL for Windows is not being maintainedfor PostgreSQL 8.4 and above.

so the only option available is the One click installer on the postgresql.org website. Clicking on the download option takes you to another website, "EnterpriseDB.com. You then select the Windows vdoersion of Postgresql 8.4.1.1. Is this the correct or recommended method for installing 8.4?

If so, can you update your documentation for updating to postgresql version 8.4?

Thanks

[WhiteRider]

You should not use the one-click Enterprise installer as it causes problems.
I will pass this on to our postgres expert - I'm not sure what the status is of the postgres 8.4 installer.

[brainslicer]

There are new versions of PostgreSQL now that fixes a lot of security issues: http://www.securityfocus.com/bid/36314

Its not good to use one-click version for neither versions (8.3.x, 8.4.x) ?

Im running 8.3.6 now and i guess i have to go 8.3.8-1 pgInstaller version...?

Some other questions, i have moved pg_data and pg_xlog folders to other hdd:s for better performance using your guide, anything to worry about before i update?

Edit:
Hmmm, I cant remember if i installed PostgreSQL from the PT3 isntallation or had it installed already, i think the later, but not sure. Any way to know since updater says:

This file will upgrade your PostgreSQL installation.

You must have PostgreSQL 8.3.x installed from the official
MSI installation to use this upgrade path.

If the PostgreSQL server or any client applications are running,
a reboot will be required once the upgrade is completed.

[WhiteRider]

I'll let Kraada get back to you about this when he comes on later - he knows more about this stuff than I do.

[brainslicer]

I'll let Kraada get back to you about this when he comes on later - he knows more about this stuff than I do.

I probably should have made a new thread since those security updates are not just only for 8.4 main versions.

Anyway: Since i was almost sure i had my postrgeSQL installation from original installation package(not installed with PT3) i went with the UPGRADE.bat(postgresql-8.3.8-1) and it worked ok.

[brainslicer]

I am about to do the same thing for a friend now: but he has postgreSQL(8.3.4) installed with PT3.

Anyone knows if it is ok to use "UPGRADE.bat" anyway since its not the official MSI installation?

[WhiteRider]

For reference: 8.4 is fine and the 8.4 one-click installer works without issue.

The problem with the one-click installer is that if you are running on a 64bit machine and previously installed via the pginstaller it would have installed the database as 32bit. The one click installer automatically installs the database as 64bit which is incompatible with the 32bit database. Therefore you would need to backup the 32-bit database before upgrading and restore it as 64bit in the new version.

I am about to do the same thing for a friend now: but he has postgreSQL(8.3.4) installed with PT3.
Anyone knows if it is ok to use "UPGRADE.bat" anyway since its not the official MSI installation?

I'm pretty sure this will be OK but if you want to wait a little while Kraada should be on in the next 30-60 minutes.

[kraada]

That should work fine as far as I'm aware.

[brainslicer]

Hmm, well... his computer got very laggy after that. No errors but just opening stuff takes forever.
PT opens in about 5 minutes...

[kraada]

You're now running PostgreSQL 8.4, yes? Which version of PostgreSQL were you running previously?