Installing Postgresql on Windows
Posted by Martin Homik | Posted in Windows | Posted on 03-12-2007
0
This post is to remind myself how to install Postgreslq. Although an installer is provided, the setup can still get a bit of work. Here are the steps:
- If the installer complains that libeay32.ddl and ssleay32.ddl have an old version, then install a new openssl version. Probably you have to do that in secured mode (press F8 when booting). Otherwise, you won’t be able to overwrite the ddl files.
- The installer will ask if it should start Postgres as service. To do that, it suggests a user ‘postgres’. For security reasons this is a good idea, though it does not make much sense when you run the service locally on your machine just for testing. Anyway, Postgresql will complain and certainly not allow to run the service as admin user. So create a new user ‘postgres’ with limited rights.
- Now, you have good chances to run the installer without complains.
Good luck!

