Thursday, March 14, 2013

Upgrading Postgres 9.1 to 9.2

Had PostgreSQL 9.1 installed
Installed PostgreSQL 9.2, disint application and data directory.

Changed postgres instance password in pgAdminIII,  then couldn't log in.
        Set connection Method to trust in pg_hba.conf
        Connect with pgAdmin
        Right Click Login Roles >> postgres
        Uncheck Account expires


Tried to run pg_upgrade:

C:\Users\mmuller\PostgreSQL>"C:\Program Files\PostgreSQL\9.2\bin\pg_upgrade.exe"  --old-datadir data --new-datadir 9.2/data --old-bindir "C:\Program Files\PostgreSQL\9.1\bin" --new-bindir "C:\Program Files\PostgreSQL\9.2\bin" -u postgres

Many problems.  Solutions:

      Grant Firewall permission to PostgreSQL server (windows control panel)
      Set connection Method to trust in pg_hba.conf (both old and new data directories)
      Be sure to set -u postgres

No comments:

Post a Comment