Sunday, October 20, 2013

Fix Issue When Installing PostgreSQL on Windows 8 64 Bit Using Installer

This post is the answer for my previous post. After googling hard, finally I found the answer from this link

The steps I followed are:
  1. Download your latest PostgreSQL installer from here and save to C:\Download\
  2. Uninstall your previous installation PostgreSQL if any.
  3. Delete the postgres user if it still exists.
    net user postgres /delete
  4. Create the postgres user with a password you can remember
  5. Add the postgres user to the Administrators group
  6. Add the postgres user to the Power Users group
  7. Run a command window as the postgres user
    runas /user:postgres cmd.exe
  8. Run the installer file from within the command window. C:\Download\postgresql-9.3.1-1-windows-x64.exe
    This should run the installation successfully.
  9. Remove the postgres user from the Administrators group.