Installing Liferay 6.2 CE with PostgreSQL on Ubuntu

Liferay is a collaboration and online portal. We can download the community edition from the Liferay website (https://www.liferay.com/downloads/liferay-portal/available-releases). I downloaded the version with Tomcat bundled.

Once downloaded, extract the downloaded version to your selected folder. Navigate to the Tomcat /bin folder and execute ./startup.sh command as shown below.

Now open a browser and access the localhost on the port Tomcat is setup on.. This will show the following setup page. First thing to do is to define the Administrator user.

The default database is hypersonic. We would like to change this to PostgreSQL. Click on Change. First thing, I did was created a new user called "sa", who had privileges to create a database.

Next thing was to create a database called lportal with sa as the owner of the database.

Finally, in Liferay, I changed the database to PostgreSQL, and changed the user as "sa" with the password I had created. Default database name is lportal, which I left as is.

This creates the database structure in the lportal database, and we can see the tables populated.

Now, we will be prompted to provide a password for the admin user.

We will also be asked to specify a question and answer for reminding the password.

That's it. We will now be able to configure the sites and pages we want.

We are now ready to work on Liferay, the way we want.