· 8 years ago · Mar 04, 2018, 10:22 AM
1mike@mike-laptop:~/projects/trisano/distro$ ./install_data_warehouse.sh
2(in /home/mike/projects/trisano/distro)
3Installing the data warehouse
4CREATE DATABASE trisano_dw ENCODING='UTF8'
5CREATE DATABASE
6ALTER SCHEMA
7CREATE ROLE
8NOTICE: schema "trisano" does not exist
9ALTER ROLE
10CREATE SCHEMA
11ALTER SCHEMA
12CREATE LANGUAGE
13ALTER SCHEMA
14GRANT
15CREATE TABLE
16TRUNCATE TABLE
17INSERT 0 1
18CREATE TABLE
19INSERT 0 1
20CREATE FUNCTION
21CREATE FUNCTION
22Running the DW ETL script
23Temporarily quieting PostgreSQL
24ALTER ROLE
25Preparing for ETL process
26 prepare_etl
27-------------
28 t
29(1 row)
30
31Dumping database localhost:5432/trisano_development to localhost:5432/trisano_dw
32 Dropping bucardo schema in warehouse, if exists
33 Checking for bucardo schema in source
34 Doing main dump
35-[ RECORD 1 ]
36setval | 1
37
38-[ RECORD 1 ]
39setval | 1
40
41-[ RECORD 1 ]
42setval | 1
43
44-[ RECORD 1 ]
45setval | 1
46
47-[ RECORD 1 ]
48setval | 33
49
50-[ RECORD 1 ]
51setval | 119
52
53-[ RECORD 1 ]
54setval | 172
55
56-[ RECORD 1 ]
57setval | 1
58
59-[ RECORD 1 ]
60setval | 1
61
62-[ RECORD 1 ]
63setval | 133
64
65-[ RECORD 1 ]
66setval | 1
67
68-[ RECORD 1 ]
69setval | 1
70
71-[ RECORD 1 ]
72setval | 69
73
74-[ RECORD 1 ]
75setval | 214
76
77-[ RECORD 1 ]
78setval | 1
79
80-[ RECORD 1 ]
81setval | 1
82
83-[ RECORD 1 ]------
84setval | 2009000001
85
86-[ RECORD 1 ]
87setval | 445
88
89-[ RECORD 1 ]
90setval | 1570
91
92-[ RECORD 1 ]
93setval | 9
94
95-[ RECORD 1 ]
96setval | 1
97
98-[ RECORD 1 ]
99setval | 231
100
101-[ RECORD 1 ]
102setval | 1
103
104-[ RECORD 1 ]
105setval | 1
106
107-[ RECORD 1 ]
108setval | 1
109
110-[ RECORD 1 ]
111setval | 1
112
113-[ RECORD 1 ]
114setval | 1
115
116-[ RECORD 1 ]
117setval | 1
118
119-[ RECORD 1 ]
120setval | 1
121
122-[ RECORD 1 ]
123setval | 1
124
125-[ RECORD 1 ]
126setval | 1
127
128-[ RECORD 1 ]
129setval | 1
130
131-[ RECORD 1 ]
132setval | 1
133
134-[ RECORD 1 ]
135setval | 1
136
137-[ RECORD 1 ]
138setval | 1
139
140-[ RECORD 1 ]
141setval | 1
142
143-[ RECORD 1 ]
144setval | 69
145
146-[ RECORD 1 ]
147setval | 12
148
149-[ RECORD 1 ]
150setval | 30
151
152-[ RECORD 1 ]
153setval | 1
154
155-[ RECORD 1 ]
156setval | 90
157
158-[ RECORD 1 ]
159setval | 6
160
161-[ RECORD 1 ]
162setval | 1
163
164-[ RECORD 1 ]
165setval | 1
166
167-[ RECORD 1 ]
168setval | 1
169
170-[ RECORD 1 ]
171setval | 1
172
173-[ RECORD 1 ]
174setval | 6
175
176Performing ETL data manipulation
177
178
179Swapping schemas
180 swap_schemas
181--------------
182 t
183(1 row)
184
185Fixing PostgreSQL verbosity
186ALTER ROLE
187psql: FATAL: database "trisano_admin" does not exist
188rake aborted!
189failed to create Pentaho repository
190
191(See full trace by running task with --trace)
192mike@mike-laptop:~/projects/trisano/distro$