kofno

2009-05-07 14:04:43 EDT NOTICE:  schema "trisano" does not exist
2009-05-07 14:04:43 EDT ERROR:  language "plpgsql" already exists
2009-05-07 14:04:43 EDT STATEMENT:  CREATE LANGUAGE plpgsql;
2009-05-07 14:04:44 EDT NOTICE:  Preparing for ETL process by creating staging schema
2009-05-07 14:04:44 EDT NOTICE:  schema "staging" does not exist, skipping
2009-05-07 14:04:44 EDT CONTEXT:  SQL statement "DROP SCHEMA IF EXISTS staging CASCADE"
	PL/pgSQL function "prepare_etl" line 3 at EXECUTE statement
2009-05-07 14:04:44 EDT NOTICE:  schema "bucardo" does not exist, skipping
2009-05-07 14:04:44 EDT FATAL:  password authentication failed for user "nedss"
2009-05-07 14:04:44 EDT FATAL:  password authentication failed for user "nedss"

kofno

(in /home/ryan/projects/trisano/distro)
Installing the data warehouse
CREATE DATABASE trisano_dw ENCODING='UTF8'
CREATE DATABASE
ALTER SCHEMA
CREATE ROLE
NOTICE:  schema "trisano" does not exist
ALTER ROLE
CREATE SCHEMA
ALTER SCHEMA

kofno

--
-- PostgreSQL database cluster dump
--

\connect postgres

SET client_encoding = 'UTF8';
SET standard_conforming_strings = off;
SET escape_string_warning = 'off';

kofno

# Database administrative login by UNIX sockets
local   all         postgres                          ident sameuser

# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD

# "local" is for Unix domain socket connections only
local   all         ryan                              ident sameuser
local   all         invoicer                          md5
local   all         ftime                             md5
local   all         nedss                             md5

kofno

# Database administrative login by UNIX sockets
local   all         postgres                          ident sameuser

# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD

# "local" is for Unix domain socket connections only
local   all         ryan                              ident sameuser
local   all         nedss                             trust
# IPv4 local connections:
host    all         all         127.0.0.1/32          md5

kofno

Password for user trisano_su: 
Temporarily quieting PostgreSQL
Password for user trisano_su: 
ALTER ROLE
Preparing for ETL process
Password for user trisano_su: 
 prepare_etl 
-------------
 t
(1 row)

kofno

postgres@shikigami:/home/ryan/bi_bits/warehouse$ ./etl.sh 
Temporarily quieting PostgreSQL
ALTER ROLE
Preparing for ETL process
 prepare_etl 
-------------
 t
(1 row)

Dumping database:

kofno

ERROR:  relation "formbuilder_pneumococcal_disease_invasive_corrupt_form_1_event_" already exists
CONTEXT:  SQL statement "CREATE INDEX formbuilder_pneumococcal_disease_invasive_corrupt_form_1_event_type_ix ON formbuilder_pneumococcal_disease_invasive_corrupt_form_1 (type)"
PL/pgSQL function "build_form_tables" line 197 at EXECUTE statement
SQL statement "SELECT  trisano.build_form_tables()"
PL/pgSQL function "swap_schemas" line 30 at PERFORM

kofno

    /**
     * @param ownerType the type of ACL owner : user or role
     * @param ownerName the name or the user or role
     * @param rights
     */
    public SecurityOwner(int ownerType, String ownerName, int rights)
    {
        this.ownerType = ownerType;
        this.ownerName = ownerName;
    }

kofno

 SELECT "events"."id" AS t0_r0, "events"."imported_from_id" AS t0_r1, "events"."state_case_status_id" AS t0_r2, "events"."event_name" AS t0_r3, "events"."event_onset_date" AS t0_r4, "events"."created_at" AS t0_r5, "events"."updated_at" AS t0_r6, "events"."outbreak_associated_id" AS t0_r7, "events"."outbreak_name" AS t0_r8, "events"."investigation_LHD_status_id" AS t0_r9, "events"."investigation_started_date" AS t0_r10, "events"."investigation_completed_LHD_date" AS t0_r11, "events"."review_completed_by_state_date" AS t0_r12, "events"."first_reported_PH_date" AS t0_r13, "events"."results_reported_to_clinician_date" AS t0_r14, "events"."record_number" AS t0_r15, "events"."MMWR_week" AS t0_r16, "events"."MMWR_year" AS t0_r17, "events"."lhd_case_status_id" AS t0_r18, "events"."type" AS t0_r19, "events"."event_queue_id" AS t0_r20, "events"."sent_to_cdc" AS t0_r21, "events"."age_at_onset" AS t0_r22, "events"."age_type_id" AS t0_r23, "events"."investigator_id" AS t0_r24, "events"."sent_to_ibis" AS t0_r25, "events"."