This article is a legacy article. It applies to previous versions of the Liferay product. While the article is no longer maintained, the information may still be applicable.
This article will explain how to create a database in PostgreSQL and configure a Liferay bundle to connect to it. If PostgresSQL hasn't been installed yet, download the relevant file here: http://www.postgresql.org/download/windows/
For detailed setup instructions, visit: Running & Installing PostgreSQL On Native Windows
Resolution
Setting Up a Database
- Click start-> PostgreSQL 9.0-> pgAdmin III
- In the object browser on the left, double-click the "PostgreSQL 9.0 (localhost:5432)" server.
- If a password is requested, enter the password when installing Postgres.
- In the object browser, right-click "Databases" and select "New Database"
- Select the name for the database, leaving everything else default. Click OK.
Installing Liferay and connecting the database
-
Create the portal-ext.properties. Enter the following:
jdbc.default.driverClassName=org.postgresql.Driver
jdbc.default.url=jdbc:postgresql://{IP Address}:5432/${database name}
jdbc.default.username=postgres
jdbc.default.password=${password}
Liferay should populate the PostgresSQL database with Liferay data. The console should display that Postgres is the database engine.