*shell*

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
psql:../bi/scripts/warehouse_init_to_run.sql:20: ERROR:  language "plpgsql" already exists
ALTER SCHEMA
GRANT
CREATE TABLE
TRUNCATE TABLE
INSERT 0 1
CREATE TABLE
INSERT 0 1
CREATE FUNCTION
CREATE FUNCTION
Running the DW ETL script
Temporarily quieting PostgreSQL
ALTER ROLE
Preparing for ETL process
 prepare_etl 
-------------
 t
(1 row)

Dumping database localhost:5432/trisano_development to localhost:5432/trisano_dw
   Dropping bucardo schema in warehouse, if exists
   Checking for bucardo schema in source
psql: FATAL:  password authentication failed for user "nedss"
   Doing main dump
pg_dump: [archiver (db)] connection to database "trisano_development" failed: FATAL:  password authentication failed for user "nedss"
Performing ETL data manipulation


psql:../bi/scripts/dw.sql:177: ERROR:  relation "people" does not exist
psql:../bi/scripts/dw.sql:323: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:../bi/scripts/dw.sql:452: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:../bi/scripts/dw.sql:480: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:../bi/scripts/dw.sql:508: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:../bi/scripts/dw.sql:545: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:../bi/scripts/dw.sql:587: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:../bi/scripts/dw.sql:589: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:../bi/scripts/dw.sql:602: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:../bi/scripts/dw.sql:629: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:../bi/scripts/dw.sql:657: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:../bi/scripts/dw.sql:681: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:../bi/scripts/dw.sql:704: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:../bi/scripts/dw.sql:727: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:../bi/scripts/dw.sql:751: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:../bi/scripts/dw.sql:774: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:../bi/scripts/dw.sql:789: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:../bi/scripts/dw.sql:804: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:../bi/scripts/dw.sql:819: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:../bi/scripts/dw.sql:821: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:../bi/scripts/dw.sql:822: ERROR:  current transaction is aborted, commands ignored until end of transaction block
Swapping schemas
ERROR:  Last ETL process was, apparently, not valid. Not swapping schemas. See table trisano.etl_success.
Fixing PostgreSQL verbosity
ALTER ROLE
psql: FATAL:  database "ryan" does not exist
rake aborted!
failed to create Pentaho repository