. Download the ZIP file from. Unzip the archive into a directory of your choice (the archive is created such that unzipping it, it will create a directory pgsql with everything else below that). Run initdb (this can be found in the subdirectory pgsql bin) initdb -D c: Users Arhtur pgdata -U postgres -W -E UTF8 -A md5 This will create the postgres 'data directory' (aka the 'cluster') in c: Users Arhtur pgdata. You need to make sure that the user running this command has full read/write privileges on that directory.U postgres creates the superuser as postgres, -W will prompt you for the password of the superuser, -E UTF8 will create the database with UTF-8 encoding and -A md5 enables the password authentication.
To start Postgres, run: pgctl -D c: Users Arhtur pgdata start this has(!) to be done as the user who ran initdb to avoid any problems with the access to the data directory. To shutdown Postgres, run: pgctl -D c: Users Arhtur pgdata stop. psql.exe (the command line client) and pgAdmin3.exe are both located in the bin directory.