destaque.Arquivo: "./tomcat/webapps/pentaho/META-INF/context.xml".<?xml version="1.0" encoding="UTF-8"?><Context path="/pentaho" docbase="webapps/pentaho/"><Resource name="jdbc/Hibernate" auth="Container" type="javax.sql.DataSource" factory="org.apache.commons.dbcp.BasicDataSourceFactory" maxActive="20" maxIdle="5" maxWait="10000" username="hibuser" password="password" driverClassName="org.postgresql.Driver" url="jdbc:postgresql://localhost:5432/hibernate" validationQuery="select 1"/><Resource name="jdbc/Quartz" auth="Container" type="javax.sql.DataSource" factory="org.apache.commons.dbcp.BasicDataSourceFactory" maxActive="20" maxIdle="5" maxWait="10000" username="pentaho_user" password="password" driverClassName="org.postgresql.Driver" url="jdbc:postgresql://localhost:5432/quartz" validationQuery="select 1"/></Context> Exclua este Arquivo: "./tomcat/conf/Catalina/localhost/pentaho.xml".~# sudo rm -rf ./tomcat/conf/Catalina/localhost/pentaho.xmlArquivo: "./pentaho-solutions/system/dialects/postgresql/applicationContext-spring-security-hibernate.properties". jdbc.driver=org.postgresql.Driverjdbc.url=jdbc:postgresql://localhost:5432/hibernatejdbc.username=hibuserjdbc.password=passwordhibernate.dialect=org.hibernate.dialect.PostgreSQLDialectArquivo: "./pentaho-solutions/system/applicationContext-spring-security-hibernate.properties". jdbc.driver=org.postgresql.Driverjdbc.url=jdbc:postgresql://localhost:5432/hibernatejdbc.username=hibuserjdbc.password=passwordhibernate.dialect=org.hibernate.dialect.PostgreSQLDialect Arquivo: "./pentaho-solutions/system/hibernate/hibernate-settings.xml".<config-file>system/hibernate/postgresql.hibernate.cfg.xml</config-file>Arquivo: "./pentaho-solutions/system/hibernate/postgresql.hibernate.cfg.xml".<property name="connection.driver_class">org.postgresql.Driver</property><property name="connection.url">jdbc:postgresql://localhost:5432/hibernate</property><property name="dialect">org.hibernate.dialect.PostgreSQLDialect</property><property name="connection.username">hibuser</property><property name="connection.password">password</property>Arquivo: "./pentaho-solutions/system/jackrabbit/repository.xml".Neste arquivo, e necessario a correcao em varios parametros. Utilize o nome da classe como referencia, para certificar que todas as modificacoes foram realizadas. Observe que as configuracoes referentes ao banco h2 sao comentadas e as do PostgreSQL descomnClasse: "org.apache.jackrabbit.core.fs.local.LocalFileSystem".--> <FileSystem class="org.apache.jackrabbit.core.fs.db.DbFileSystem"> <param name="driver" value="org.postgresql.Driver"/> <param name="url" value="jdbc:postgresql://localhost:5432/jackrabbit"/> <param name="user" value="jcr_user"/> <param name="password" value="password"/> <param name="schema" value="postgresql"/> <param name="schemaObjectPrefix" value="fs_repos_"/></FileSystem><!-- <FileSystem class="org.apache.jackrabbit.core.fs.local.LocalFileSystem"> <param name="path" value="${rep.home}/repository"/></FileSystem>-->Classe: "org.apache.jackrabbit.core.data.db.DbDataStore".--> <DataStore class="org.apache.jackrabbit.core.data.db.DbDataStore"> <param name="url" value="jdbc:postgresql://localhost:5432/jackrabbit"/> <param name="driver" value="org.postgresql.Driver"/> <param name="user" value="jcr_user"/> <param name="password" value="password"/> <param name="databaseType" value="postgresql"/> <param name="minRecordLength" value="1024"/> <param name="maxConnections" value="3"/> <param name="copyWhenReading" value="true"/> <param name="tablePrefix" value=""/> <param name="schemaObjectPrefix" value="ds_repos_"/></DataStore><!--<DataStore class="org.apache.jackrabbit.core.data.FileDataStore"/>--> Classe: "org.apache.jackrabbit.core.fs.db.DbFileSystem".--> <FileSystem class="org.apache.jackrabbit.core.fs.db.DbFileSystem"> <param name="driver" value="org.postgresql.Driver"/> <param name="url" value="jdbc:postgresql://localhost:5432/jackrabbit"/> <param name="user" value="jcr_user"/> <param name="password" value="password"/> <param name="schema" value="postgresql"/> <param name="schemaObjectPrefix" value="fs_ws_"/></FileSystem><!--<FileSystem class="org.apache.jackrabbit.core.fs.local.LocalFileSystem"> <param name="path" value="${wsp.home}"/></FileSystem>-->Classe: "org.apache.jackrabbit.core.persistence.bundle.PostgreSQLPersistenceManager".--><PersistenceManager class="org.apache.jackrabbit.core.persistence.bundle.PostgreSQLPersistenceManager"> <param name="url" value="jdbc:postgresql://localhost:5432/jackrabbit"/> <param name="driver" value="org.postgresql.Driver"/> <param name="user" value="jcr_user"/> <param name="password" value="password"/> <param name="schema" value="postgresql"/> <param name="schemaObjectPrefix" value="${wsp.name}_pm_ws_"/></PersistenceManager><!--<PersistenceManager class="org.apache.jackrabbit.core.persistence.pool.H2PersistenceManager"> <param name="url" value="jdbc:h2:${wsp.home}/db"/> <param name="schemaObjectPrefix" value="${wsp.name}_"/></PersistenceManager>-->Classe: "org.apache.jackrabbit.core.fs.db.DbFileSystem".--> <FileSystem class="org.apache.jackrabbit.core.fs.db.DbFileSystem"> <param name="driver" value="org.postgresql.Driver"/> <param name="url" value="jdbc:postgresql://localhost:5432/jackrabbit"/> <param name="user" value="jcr_user"/> <param name="password" value="password"/> <param name="schema" value="postgresql"/> <param name="schemaObjectPrefix" value="fs_ver_"/> </FileSystem><!-- <FileSystem class="org.apache.jackrabbit.core.fs.local.LocalFileSystem"> <param name="path" value="${rep.home}/version" /> </FileSystem>-->Classe: "org.apache.jackrabbit.core.persistence.bundle.PostgreSQLPersistenceManager".--><PersistenceManager class="org.apache.jackrabbit.core.persistence.bundle.PostgreSQLPersistenceManager"> <param name="url" value="jdbc:postgresql://localhost:5432/jackrabbit"/> <param name="driver" value="org.postgresql.Driver"/> <param name="user" value="jcr_user"/> <param name="password" value="password"/> <param name="schema" value="postgresql"/> <param name="schemaObjectPrefix" value="pm_ver_"/></PersistenceManager><!--<PersistenceManager class="org.apache.jackrabbit.core.persistence.pool.H2PersistenceManager"> <param name="url" value="jdbc:h2:${rep.home}/version/db"/> <param name="schemaObjectPrefix" value="version_"/></PersistenceManager>-->Arquivo: "./tomcat/webapps/pentaho/WEB-INF/web.xml".Comente as linhas referentes a inicializacao do SGBD HSQLDB, uma vez que este servico nao mais sera utilizado.<!-- [BEGIN HSQLDB DATABASES]<context-param> <param-name>hsqldb-databases</param-name> <param-value>sampledata@../../data/hsqldb/sampledata,hibernate@../../data/hsqldb/hibernate,quartz@../../data/hsqldb/quartz</param-value></context-param>[END HSQLDB DATABASES] --><!-- [BEGIN HSQLDB STARTER]<listener> <listener-class>org.pentaho.platform.web.http.context.HsqldbStartupListener</listener-class></listener>[END HSQLDB STARTER] -->Arquivo: "./pentaho-solutions/system/pentaho-spring-beans.xml".Comente a linha referente a inicializacao do SGBD H2, uma vez que este servico nao mais sera utilizado.<!-- <import resource="GettingStartedDB-spring.xml" /> Remove this line to unhook the Getting Started DB -->Com atencao, exclua os arquivos conforme o exemplo a seguir:~# rm -rf ./tomcat/work/*~# rm -rf ./tomcat/temp/* ~# rm -rf ./pentaho-solutions/system/jackrabbit/repository/repository~# rm -rf ./pentaho-solutions/system/jackrabbit/repository/workspacesConcluido as configuracoes, Inicie o servico do PUC.Em caso de problemas na inicializacao, reveja as configuracoes, observando a bertura e fechamento de tags, nomes de usuarios, senhas, drivers configurados nos arquivos, ip's e portas dos bancos, que sao os principais problema ocorridos.Utilize o log do tomcat como suporte para esta tarefa, em "./tomcat/logs/catalina.out".Veja tambem:- Inicializar o HSQLDB independente do Pentaho BA