This guide will show how to create a database for Openfire, but the same commands can be used for creating any user and database you want.
Step 1
Providing that PostgreSQL is installed, start SQL Shell from the Start Menu
This is a very basic guide in installing and PostgreSQL on a Windows platform. The following guides will involve creating a user and a database, and ultimately install and configure Openfire!
Go to http://www.enterprisedb.com/products-services-training/pgdownload and download the latest version for your architecture