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