Integracao do PostgreSQL 9.1 ao Pentaho BI Server CE 3.10.0Pessoal,Neste post sera mostrado como integrar o PostgreSQL 9.1 ao Pentaho BI Server CE 3.10.0. Podemos atribuir a referida integracao, um nivel de dificuldade medio, porem, sera necessario uma atencao especial para edicao dos arquivos, pois uma "tag" que nao for fechada, ou a falta da declaracao de um driver ou um driver escrito incorretamente, podem comprometer o resultado final.A integracao consiste na migracao dos bancos de dados "hibernate" e "quartz" do SGDB HSQLDB, que acompanha o pacote original do Pentaho BI, para o PostgreSQL. No entanto, o HSQLDB vai continuar funcionando no ambiente para prover suporte ao Data Warehouse (DW) SampleData, para mostragem dos testes dos projetos "Steel Wheels" e "BI Developer". Para voce que tem interesse em colocar o Pentaho BI em producao, sem os projetos de testes, vamos mostrar em outra oportunidade, aqui no Sob Demanda, como desabilitar o "start" do HSQLDB e desinstalar os projetos de testes do ambiente.Entao, vamos iniciar.Instalacao SGDB PostgreSQL Se voce nao estiver com o PostgreSQL instalado, utilize o post Instalacao PostgreSQL 9.1 32 bits em distro Debian ou Ubuntu para faze-lo. O objetivo e integrar o PostgreSQL 9.1 ao Pentaho Bi, mas se voce ja tiver outra versao instalada, os procedimentos podem ser realizados sem problemas, lembrando que apenas o driver jdbc deve corresponder a versao de sua instalacao.Certifique que o servico do postgres esteja em "up".ps U postgres PID TTY STAT TIME COMMAND 6915 pts/0 S 0:00 /opt/postgresql-9.1.0/bin/postmaster -D /opt/postgresql-9.1.0/pgdata 6923 ? Ss 0:00 postgres: logger process 6925 ? Ss 0:00 postgres: writer process 6926 ? Ss 0:00 postgres: wal writer process 6927 ? Ss 0:00 postgres: autovacuum launcher process 6928 ? Ss 0:00 postgres: stats collector processInstalacao dos bancos de dados Crie a estrutura basica para o Pentaho BI no SGDB.su - postgrespsql -p 5432 -f /opt/pentaho/biserver-ce/data/postgresql/create_repository_postgresql.sqlpsql:/opt/pentaho/biserver-ce/data/postgresql/create_repository_postgresql.sql:7: NOTICE: database "hibernate" does not exist, skippingDROP DATABASEpsql:/opt/pentaho/biserver-ce/data/postgresql/create_repository_postgresql.sql:8: NOTICE: role "hibuser" does not exist, skippingDROP ROLECREATE ROLECREATE DATABASEGRANTYou are now connected to database "hibernate" as user "hibuser".BEGINpsql:/opt/pentaho/biserver-ce/data/postgresql/create_repository_postgresql.sql:20: NOTICE: table "datasource" does not exist, skippingDROP TABLEpsql:/opt/pentaho/biserver-ce/data/postgresql/create_repository_postgresql.sql:22: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "datasource_pkey" for table "datasource"CREATE TABLECOMMIT$ psql -p 5432 -f /opt/pentaho/biserver-ce/data/postgresql/create_quartz_postgresql.sqlpsql:/opt/pentaho/biserver-ce/data/postgresql/create_quartz_postgresql.sql:7: NOTICE: database "quartz" does not exist, skippingDROP DATABASEpsql:/opt/pentaho/biserver-ce/data/postgresql/create_quartz_postgresql.sql:8: NOTICE: role "pentaho_user" does not exist, skippingDROP ROLECREATE ROLECREATE DATABASEGRANTYou are now connected to database "quartz" as user "pentaho_user".BEGINpsql:/opt/pentaho/biserver-ce/data/postgresql/create_quartz_postgresql.sql:20: NOTICE: table "qrtz_job_listeners" does not exist, skippingDROP TABLEpsql:/opt/pentaho/biserver-ce/data/postgresql/create_quartz_postgresql.sql:21: NOTICE: table "qrtz_trigger_listeners" does not exist, skippingDROP TABLEpsql:/opt/pentaho/biserver-ce/data/postgresql/create_quartz_postgresql.sql:22: NOTICE: table "qrtz_fired_triggers" does not exist, skippingDROP TABLEpsql:/opt/pentaho/biserver-ce/data/postgresql/create_quartz_postgresql.sql:23: NOTICE: table "qrtz_paused_trigger_grps" does not exist, skippingDROP TABLEpsql:/opt/pentaho/biserver-ce/data/postgresql/create_quartz_postgresql.sql:24: NOTICE: table "qrtz_scheduler_state" does not exist, skippingDROP TABLEpsql:/opt/pentaho/biserver-ce/data/postgresql/create_quartz_postgresql.sql:25: NOTICE: table "qrtz_locks" does not exist, skippingDROP TABLEpsql:/opt/pentaho/biserver-ce/data/postgresql/create_quartz_postgresql.sql:26: NOTICE: table "qrtz_simple_triggers" does not exist, skippingDROP TABLEpsql:/opt/pentaho/biserver-ce/data/postgresql/create_quartz_postgresql.sql:27: NOTICE: table "qrtz_cron_triggers" does not exist, skippingDROP TABLEpsql:/opt/pentaho/biserver-ce/data/postgresql/create_quartz_postgresql.sql:28: NOTICE: table "qrtz_blob_triggers" does not exist, skippingDROP TABLEpsql:/opt/pentaho/biserver-ce/data/postgresql/create_quartz_postgresql.sql:29: NOTICE: table "qrtz_triggers" does not exist, skippingDROP TABLEpsql:/opt/pentaho/biserver-ce/data/postgresql/create_quartz_postgresql.sql:30: NOTICE: table "qrtz_job_details" does not exist, skippingDROP TABLEpsql:/opt/pentaho/biserver-ce/data/postgresql/create_quartz_postgresql.sql:31: NOTICE: table "qrtz_calendars" does not exist, skippingDROP TABLEpsql:/opt/pentaho/biserver-ce/data/postgresql/create_quartz_postgresql.sql:45: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "qrtz_job_details_pkey" for table "qrtz_job_details"CREATE TABLEpsql:/opt/pentaho/biserver-ce/data/postgresql/create_quartz_postgresql.sql:55: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "qrtz_job_listeners_pkey" for