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&--><img src='@theme_images_path@/emotions/sad.gif' border='0' style='vertical-align:middle' alt='sad.gif' /><!--endemo-->

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.

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

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 />

<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 />

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 />

Can you send me details for installing liferay with postgresql on Solaris. My mail adres is sarkg@yahoo.com. Thanks

Ali try following these instructions: http://www.liferay.com/documentation/liferay-portal/6.0/administration/-/ai/initial-setup-4

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