Forums

Home » Liferay Portal » English » Liferay Legacy

Combination View Flat View Tree View
Threads [ Previous | Next ]
toggle
joaor joaor
How can i install liferay with postgresql??
September 30, 2004 10:11 AM
Answer

joaor joaor

Rank: New Member

Posts: 3

Join Date: September 29, 2004

Recent Posts

Hi people&#33;<br /><br />I need help to instal liferay with postgresql.<br />I already try all the instructions at liferay portal.<br />But it isn&#39;t work.<br /><br /><br />Please HELP&#33;<br /><br />By Jo�o Ricardo <!--emo&emoticon--><img src='@theme_images_path@/emotions/sad.gif' border='0' style='vertical-align:middle' alt='sad.gif' /><!--endemo-->
Brian Chan
How can i install liferay with postgresql??
October 1, 2004 8:50 AM
Answer

Brian Chan

LIFERAY STAFF

Rank: Liferay Master

Posts: 751

Join Date: August 4, 2004

Recent Posts

How does it not work? The instructions on the site require a bit of experience with postgresql. If it&#39;s not working, consult the directions on the postgresql site.
joaor joaor
How can i install liferay with postgresql??
October 5, 2004 7:27 AM
Answer

joaor joaor

Rank: New Member

Posts: 3

Join Date: September 29, 2004

Recent Posts

Brian Chan,<br /><br />Excuse-me if I can&#39;t correctly install Liferay.<br />My intention is to use the Liferay in our company.<br />This decision was taken in view of the excellent evaluation of liferay for our company.<br />However, I have problems to install liferay and postgresql.<br />Perhaps it is using incompatible versions.<br />I discovered an error during the compilation of postgres with jdbc.<br />Presents error in the call of the method: &quot;org.postgresql.jdbc2.opitional.PoolingDataSource&quot;<br />Perhaps,already exists the solution for this problem.<br />I am thankful.<br /><br />By Jo�o Ricardo.<br />jrmello@mre.gov.br<br />CGECon<br />Mystery of Foreign Affairs<br />Brasil
Zaki Alam
How can i install liferay with postgresql??
October 5, 2004 11:15 AM
Answer

Zaki Alam

Rank: New Member

Posts: 5

Join Date: August 23, 2004

Recent Posts

Jo�o<br /><br />If you cannot find a solution, let me know. I have successfully installed PostgreSQL and Liferay on a Solaris as well as Linux server. If you do not resolve the issue, send me an email. I will email you notes on what I did to get the app to run with PostgreSQL.<br /><br />/Zaki<br /><br />
iyaalata iyaalata
How can i install liferay with postgresql??
October 28, 2004 7:52 AM
Answer

iyaalata iyaalata

Rank: New Member

Posts: 1

Join Date: October 27, 2004

Recent Posts

Jo�o<br /><br />If you cannot find a solution, let me know.&nbsp; I have successfully installed PostgreSQL and Liferay on a Solaris as well as Linux server.&nbsp; If you do not resolve the issue, send me an email.&nbsp; I will email you notes on what I did to get the app to run with PostgreSQL.<br /><br />/Zaki<br />

<br />
<br /><br />Hello Zaki,<br /><br />I will be interested in receiving your notes on config of Liferay and PostgreSQL.<br />System OS: RHES3 A.O<br />
Enrique Ruiz
How can i install liferay with postgresql??
October 29, 2004 10:22 AM
Answer

Enrique Ruiz

Rank: Junior Member

Posts: 37

Join Date: August 24, 2004

Recent Posts

Hello, we use the next steps to configure our PostgreSQL:<br /><br />There are some assumptions:<br /><br />* postgresql is installed in &#036;PGSQL_HOME and it is running (see PostgreSQL doc)<br />* liferay-ext is customized in &#036;LEP_EXT directory (see Liferay doc to customize your Liferay Portal)<br /><br /><br />1. Create a user, i.e. &#39;lpuser&#39;, with password, i.e. &#39;lpuser&#39;, in postgresql. Type `createuser -a -d -W -P lpuser`<br /><br />2. Create a database, i.e. &#39;lportal&#39;, in postgresql. Type `createdb -E ISO-8859-1 -U lpuser lportal`<br /><br />3. Change to the folder &#036;LEP_EXT/sql/portal and populate the database schema, type `psql -U lpuser -d lportal -f portal-postgresql.sql`<br /><br />4. Edit &#036;PGSQL_HOME/data/pg_hba.conf and sets the access control rights<br /><br />5. Download the postgresql drivers to the &#036;LEP_EXT/servers/jboss-tomcat/server/default/lib/ext folder. If it doesn&#39;t exist, create it.<br /><br />6. Edit &#036;LEP_EXT/servers/jboss-tomcat/server/default/deploy/liferay-ds.xml as follows:<br /><br />&lt;datasources&gt;<br /> &lt;local-tx-datasource&gt;<br /> &lt;jndi-name&gt;jdbc/LiferayPool&lt;/jndi-name&gt;<br /> &lt;connection-url&gt;<br /> jdbc:postgresql://myhost:5432/lportal<br /> &lt;/connection-url&gt;<br /> &lt;driver-class&gt;org.postgresql.Driver&lt;/driver-class&gt;<br /> &lt;user-name&gt;lpuser&lt;/user-name&gt;<br /> &lt;password&gt;lpuser&lt;/password&gt;<br /> &lt;min-pool-size&gt;5&lt;/min-pool-size&gt;<br /> &lt;/local-tx-datasource&gt;<br />&lt;/datasources&gt;<br /><br />Good luck.<br />
Ali Gorkem Sarkis
RE: How can i install liferay with postgresql??
May 9, 2011 6:51 AM
Answer

Ali Gorkem Sarkis

Rank: New Member

Posts: 1

Join Date: December 15, 2010

Recent Posts

Zaki Alam:
Jo�o<br /><br />If you cannot find a solution, let me know. I have successfully installed PostgreSQL and Liferay on a Solaris as well as Linux server. If you do not resolve the issue, send me an email. I will email you notes on what I did to get the app to run with PostgreSQL.<br /><br />/Zaki<br /><br />


Can you send me details for installing liferay with postgresql on Solaris. My mail adres is sarkg@yahoo.com. Thanks
Mika Koivisto
RE: How can i install liferay with postgresql??
May 9, 2011 12:01 PM
Answer

Mika Koivisto

Rank: Liferay Legend

Posts: 1518

Join Date: August 7, 2006

Recent Posts

Ali try following these instructions: http://www.liferay.com/documentation/liferay-portal/6.0/administration/-/ai/initial-setup-4
Antonio Musarra
RE: How can i install liferay with postgresql??
January 9, 2012 2:04 PM
Answer

Antonio Musarra

Rank: Junior Member

Posts: 30

Join Date: August 9, 2011

Recent Posts

You can try at URL http://musarra.wordpress.com/2011/06/16/come-configurare-liferay-6-0-per-postgresql/ or http://www.slideshare.net/amusarra/how-toconfigureliferayforpostgresql-it10

Bye,
Antonio