· 8 years ago · Mar 04, 2018, 10:12 AM
1Installing the data warehouse
2CREATE DATABASE trisano_dw ENCODING='UTF8'
3CREATE DATABASE
4ALTER SCHEMA
5CREATE ROLE
6NOTICE: schema "trisano" does not exist
7ALTER ROLE
8CREATE SCHEMA
9ALTER SCHEMA
10psql:../bi/scripts/warehouse_init_to_run.sql:20: ERROR: language "plpgsql" already exists
11ALTER SCHEMA
12GRANT
13CREATE TABLE
14TRUNCATE TABLE
15INSERT 0 1
16CREATE TABLE
17INSERT 0 1
18CREATE FUNCTION
19CREATE FUNCTION
20Running the DW ETL script
21Temporarily quieting PostgreSQL
22ALTER ROLE
23Preparing for ETL process
24 prepare_etl
25-------------
26 t
27(1 row)
28
29Dumping database localhost:5432/trisano_development to localhost:5432/trisano_dw
30 Dropping bucardo schema in warehouse, if exists
31 Checking for bucardo schema in source
32psql: FATAL: password authentication failed for user "nedss"
33 Doing main dump
34pg_dump: [archiver (db)] connection to database "trisano_development" failed: FATAL: password authentication failed for user "nedss"
35Performing ETL data manipulation
36
37
38psql:../bi/scripts/dw.sql:177: ERROR: relation "people" does not exist
39psql:../bi/scripts/dw.sql:323: ERROR: current transaction is aborted, commands ignored until end of transaction block
40psql:../bi/scripts/dw.sql:452: ERROR: current transaction is aborted, commands ignored until end of transaction block
41psql:../bi/scripts/dw.sql:480: ERROR: current transaction is aborted, commands ignored until end of transaction block
42psql:../bi/scripts/dw.sql:508: ERROR: current transaction is aborted, commands ignored until end of transaction block
43psql:../bi/scripts/dw.sql:545: ERROR: current transaction is aborted, commands ignored until end of transaction block
44psql:../bi/scripts/dw.sql:587: ERROR: current transaction is aborted, commands ignored until end of transaction block
45psql:../bi/scripts/dw.sql:589: ERROR: current transaction is aborted, commands ignored until end of transaction block
46psql:../bi/scripts/dw.sql:602: ERROR: current transaction is aborted, commands ignored until end of transaction block
47psql:../bi/scripts/dw.sql:629: ERROR: current transaction is aborted, commands ignored until end of transaction block
48psql:../bi/scripts/dw.sql:657: ERROR: current transaction is aborted, commands ignored until end of transaction block
49psql:../bi/scripts/dw.sql:681: ERROR: current transaction is aborted, commands ignored until end of transaction block
50psql:../bi/scripts/dw.sql:704: ERROR: current transaction is aborted, commands ignored until end of transaction block
51psql:../bi/scripts/dw.sql:727: ERROR: current transaction is aborted, commands ignored until end of transaction block
52psql:../bi/scripts/dw.sql:751: ERROR: current transaction is aborted, commands ignored until end of transaction block
53psql:../bi/scripts/dw.sql:774: ERROR: current transaction is aborted, commands ignored until end of transaction block
54psql:../bi/scripts/dw.sql:789: ERROR: current transaction is aborted, commands ignored until end of transaction block
55psql:../bi/scripts/dw.sql:804: ERROR: current transaction is aborted, commands ignored until end of transaction block
56psql:../bi/scripts/dw.sql:819: ERROR: current transaction is aborted, commands ignored until end of transaction block
57psql:../bi/scripts/dw.sql:821: ERROR: current transaction is aborted, commands ignored until end of transaction block
58psql:../bi/scripts/dw.sql:822: ERROR: current transaction is aborted, commands ignored until end of transaction block
59Swapping schemas
60ERROR: Last ETL process was, apparently, not valid. Not swapping schemas. See table trisano.etl_success.
61Fixing PostgreSQL verbosity
62ALTER ROLE
63psql: FATAL: database "ryan" does not exist
64rake aborted!
65failed to create Pentaho repository