8XFYN7Xz

1jacob@ubuntu:~/Documents/g2a-loot$ docker exec loot_database pg_restore -c -d loot -U postgres /loot.dump
2pg_restore: [archiver (db)] Error while PROCESSING TOC:
3pg_restore: [archiver (db)] Error from TOC entry 2771; 2606 128052 CONSTRAINT users users_pkey lootadmin
4pg_restore: [archiver (db)] could not execute query: ERROR:  cannot drop constraint users_pkey on table users because other objects depend on it
5DETAIL:  constraint reflinks_referring_user_id_fkey on table reflinks depends on index users_pkey
6constraint reflinks_referred_user_id_fkey on table reflinks depends on index users_pkey
7HINT:  Use DROP ... CASCADE to drop the dependent objects too.
8    Command was: ALTER TABLE ONLY public.users DROP CONSTRAINT users_pkey;
9
10pg_restore: [archiver (db)] Error from TOC entry 229; 1259 116329 TABLE users lootadmin
11pg_restore: [archiver (db)] could not execute query: ERROR:  cannot drop table users because other objects depend on it
12DETAIL:  constraint reflinks_referring_user_id_fkey on table reflinks depends on table users
13constraint reflinks_referred_user_id_fkey on table reflinks depends on table users
14HINT:  Use DROP ... CASCADE to drop the dependent objects too.
15    Command was: DROP TABLE public.users;
16
17pg_restore: [archiver (db)] Error from TOC entry 349; 1255 116141 FUNCTION commons_update_modtime_function() lootadmin
18pg_restore: [archiver (db)] could not execute query: ERROR:  cannot drop function commons_update_modtime_function() because other objects depend on it
19DETAIL:  trigger reflinks_update_modtime_trigger on table reflinks depends on function commons_update_modtime_function()
20HINT:  Use DROP ... CASCADE to drop the dependent objects too.
21    Command was: DROP FUNCTION public.commons_update_modtime_function();
22
23pg_restore: [archiver (db)] Error from TOC entry 729; 1247 116076 TYPE draw_boost_enum lootadmin
24pg_restore: [archiver (db)] could not execute query: ERROR:  cannot drop type draw_boost_enum because other objects depend on it
25DETAIL:  table users column boost depends on type draw_boost_enum
26HINT:  Use DROP ... CASCADE to drop the dependent objects too.
27    Command was: DROP TYPE public.draw_boost_enum;
28
29pg_restore: [archiver (db)] Error from TOC entry 2; 3079 116034 EXTENSION uuid-ossp 
30pg_restore: [archiver (db)] could not execute query: ERROR:  extension "uuid-ossp" does not exist
31    Command was: DROP EXTENSION "uuid-ossp";
32
33pg_restore: [archiver (db)] Error from TOC entry 3; 3079 115911 EXTENSION hstore 
34pg_restore: [archiver (db)] could not execute query: ERROR:  extension "hstore" does not exist
35    Command was: DROP EXTENSION hstore;
36
37pg_restore: [archiver (db)] Error from TOC entry 4; 3079 115827 EXTENSION citext 
38pg_restore: [archiver (db)] could not execute query: ERROR:  extension "citext" does not exist
39    Command was: DROP EXTENSION citext;
40
41pg_restore: [archiver (db)] Error from TOC entry 1; 3079 12655 EXTENSION plpgsql 
42pg_restore: [archiver (db)] could not execute query: ERROR:  cannot drop extension plpgsql because other objects depend on it
43DETAIL:  function commons_update_modtime_function() depends on language plpgsql
44trigger reflinks_update_modtime_trigger on table reflinks depends on function commons_update_modtime_function()
45function active_reflinks_unique_constraint_function() depends on language plpgsql
46trigger active_reflinks_unique_constraint_trigger on table reflinks depends on function active_reflinks_unique_constraint_function()
47function create_unique_ref_code_function() depends on language plpgsql
48trigger users_create_unique_ref_code_trigger on table users depends on function create_unique_ref_code_function()
49HINT:  Use DROP ... CASCADE to drop the dependent objects too.
50    Command was: DROP EXTENSION plpgsql;
51
52pg_restore: [archiver (db)] Error from TOC entry 6; 2615 2200 SCHEMA public postgres
53pg_restore: [archiver (db)] could not execute query: ERROR:  cannot drop schema public because other objects depend on it
54DETAIL:  extension pgcrypto depends on schema public
55function commons_update_modtime_function() depends on schema public
56table users depends on schema public
57type draw_boost_enum depends on schema public
58table users column boost depends on type draw_boost_enum
59table reflinks depends on schema public
60function active_reflinks_unique_constraint_function() depends on schema public
61type referring_bonus_enum depends on schema public
62table users column referring_bonus depends on type referring_bonus_enum
63type referred_bonus_enum depends on schema public
64table users column referred_bonus depends on type referred_bonus_enum
65function create_unique_ref_code_function() depends on schema public
66HINT:  Use DROP ... CASCADE to drop the dependent objects too.
67    Command was: DROP SCHEMA public;
68
69pg_restore: [archiver (db)] could not execute query: ERROR:  schema "public" already exists
70    Command was: CREATE SCHEMA public;
71
72
73
74pg_restore: [archiver (db)] Error from TOC entry 723; 1247 116046 TYPE activation_status_enum lootadmin
75pg_restore: [archiver (db)] could not execute query: ERROR:  role "lootadmin" does not exist
76    Command was: ALTER TYPE activation_status_enum OWNER TO lootadmin;
77
78
79pg_restore: [archiver (db)] Error from TOC entry 726; 1247 116058 TYPE deposits_status_enum lootadmin
80pg_restore: [archiver (db)] could not execute query: ERROR:  role "lootadmin" does not exist
81    Command was: ALTER TYPE deposits_status_enum OWNER TO lootadmin;
82
83
84pg_restore: [archiver (db)] Error from TOC entry 729; 1247 116076 TYPE draw_boost_enum lootadmin
85pg_restore: [archiver (db)] could not execute query: ERROR:  type "draw_boost_enum" already exists
86    Command was: CREATE TYPE draw_boost_enum AS ENUM (
87    'none',
88    'small',
89    'medium',
90    'large',
91    'very_large'
92);
93
94
95
96pg_restore: [archiver (db)] could not execute query: ERROR:  role "lootadmin" does not exist
97    Command was: ALTER TYPE draw_boost_enum OWNER TO lootadmin;
98
99
100pg_restore: [archiver (db)] Error from TOC entry 732; 1247 116088 TYPE keys_status_enum lootadmin
101pg_restore: [archiver (db)] could not execute query: ERROR:  role "lootadmin" does not exist
102    Command was: ALTER TYPE keys_status_enum OWNER TO lootadmin;
103
104
105pg_restore: [archiver (db)] Error from TOC entry 735; 1247 116102 TYPE status_enum lootadmin
106pg_restore: [archiver (db)] could not execute query: ERROR:  role "lootadmin" does not exist
107    Command was: ALTER TYPE status_enum OWNER TO lootadmin;
108
109
110pg_restore: [archiver (db)] Error from TOC entry 738; 1247 116124 TYPE transaction_type_enum lootadmin
111pg_restore: [archiver (db)] could not execute query: ERROR:  role "lootadmin" does not exist
112    Command was: ALTER TYPE transaction_type_enum OWNER TO lootadmin;
113
114
115pg_restore: [archiver (db)] Error from TOC entry 347; 1255 116139 FUNCTION case_items_prevent_game_change_function() lootadmin
116pg_restore: [archiver (db)] could not execute query: ERROR:  role "lootadmin" does not exist
117    Command was: ALTER FUNCTION public.case_items_prevent_game_change_function() OWNER TO lootadmin;
118
119
120pg_restore: [archiver (db)] Error from TOC entry 348; 1255 116140 FUNCTION cases_readonly_constraint_function() lootadmin
121pg_restore: [archiver (db)] could not execute query: ERROR:  role "lootadmin" does not exist
122    Command was: ALTER FUNCTION public.cases_readonly_constraint_function() OWNER TO lootadmin;
123
124
125pg_restore: [archiver (db)] Error from TOC entry 349; 1255 116141 FUNCTION commons_update_modtime_function() lootadmin
126pg_restore: [archiver (db)] could not execute query: ERROR:  function "commons_update_modtime_function" already exists with same argument types
127    Command was: CREATE FUNCTION commons_update_modtime_function() RETURNS trigger
128    LANGUAGE plpgsql
129    AS $$
130BEGIN
131    IF (TG_OP = 'INSE...
132pg_restore: [archiver (db)] could not execute query: ERROR:  role "lootadmin" does not exist
133    Command was: ALTER FUNCTION public.commons_update_modtime_function() OWNER TO lootadmin;
134
135
136pg_restore: [archiver (db)] Error from TOC entry 350; 1255 116142 FUNCTION keys_readonly_constraint_function() lootadmin
137pg_restore: [archiver (db)] could not execute query: ERROR:  role "lootadmin" does not exist
138    Command was: ALTER FUNCTION public.keys_readonly_constraint_function() OWNER TO lootadmin;
139
140
141pg_restore: [archiver (db)] Error from TOC entry 351; 1255 116143 FUNCTION keys_update_purchases_count_function() lootadmin
142pg_restore: [archiver (db)] could not execute query: ERROR:  role "lootadmin" does not exist
143    Command was: ALTER FUNCTION public.keys_update_purchases_count_function() OWNER TO lootadmin;
144
145
146pg_restore: [archiver (db)] Error from TOC entry 352; 1255 116144 FUNCTION keys_update_status_function() lootadmin
147pg_restore: [archiver (db)] could not execute query: ERROR:  role "lootadmin" does not exist
148    Command was: ALTER FUNCTION public.keys_update_status_function() OWNER TO lootadmin;
149
150
151pg_restore: [archiver (db)] Error from TOC entry 353; 1255 116145 FUNCTION transactions_update_cache_fields_function() lootadmin
152pg_restore: [archiver (db)] could not execute query: ERROR:  role "lootadmin" does not exist
153    Command was: ALTER FUNCTION public.transactions_update_cache_fields_function() OWNER TO lootadmin;
154
155
156pg_restore: [archiver (db)] Error from TOC entry 354; 1255 116146 FUNCTION users_readonly_constraint_function() lootadmin
157pg_restore: [archiver (db)] could not execute query: ERROR:  role "lootadmin" does not exist
158    Command was: ALTER FUNCTION public.users_readonly_constraint_function() OWNER TO lootadmin;
159
160
161pg_restore: [archiver (db)] Error from TOC entry 188; 1259 116147 TABLE activation_outcomes lootadmin
162pg_restore: [archiver (db)] could not execute query: ERROR:  role "lootadmin" does not exist
163    Command was: ALTER TABLE activation_outcomes OWNER TO lootadmin;
164
165
166pg_restore: [archiver (db)] Error from TOC entry 189; 1259 116154 SEQUENCE activation_outcomes_id_seq lootadmin
167pg_restore: [archiver (db)] could not execute query: ERROR:  role "lootadmin" does not exist
168    Command was: ALTER TABLE activation_outcomes_id_seq OWNER TO lootadmin;
169
170
171pg_restore: [archiver (db)] Error from TOC entry 190; 1259 116156 TABLE audit lootadmin
172pg_restore: [archiver (db)] could not execute query: ERROR:  role "lootadmin" does not exist
173    Command was: ALTER TABLE audit OWNER TO lootadmin;
174
175
176pg_restore: [archiver (db)] Error from TOC entry 191; 1259 116164 SEQUENCE audit_id_seq lootadmin
177pg_restore: [archiver (db)] could not execute query: ERROR:  role "lootadmin" does not exist
178    Command was: ALTER TABLE audit_id_seq OWNER TO lootadmin;
179
180
181pg_restore: [archiver (db)] Error from TOC entry 192; 1259 116166 TABLE auth_group lootadmin
182pg_restore: [archiver (db)] could not execute query: ERROR:  role "lootadmin" does not exist
183    Command was: ALTER TABLE auth_group OWNER TO lootadmin;
184
185
186pg_restore: [archiver (db)] Error from TOC entry 193; 1259 116169 SEQUENCE auth_group_id_seq lootadmin
187pg_restore: [archiver (db)] could not execute query: ERROR:  role "lootadmin" does not exist
188    Command was: ALTER TABLE auth_group_id_seq OWNER TO lootadmin;
189
190
191pg_restore: [archiver (db)] Error from TOC entry 194; 1259 116171 TABLE auth_group_permissions lootadmin
192pg_restore: [archiver (db)] could not execute query: ERROR:  role "lootadmin" does not exist
193    Command was: ALTER TABLE auth_group_permissions OWNER TO lootadmin;
194
195
196pg_restore: [archiver (db)] Error from TOC entry 195; 1259 116174 SEQUENCE auth_group_permissions_id_seq lootadmin
197pg_restore: [archiver (db)] could not execute query: ERROR:  role "lootadmin" does not exist
198    Command was: ALTER TABLE auth_group_permissions_id_seq OWNER TO lootadmin;
199
200
201pg_restore: [archiver (db)] Error from TOC entry 196; 1259 116176 TABLE auth_permission lootadmin
202pg_restore: [archiver (db)] could not execute query: ERROR:  role "lootadmin" does not exist
203    Command was: ALTER TABLE auth_permission OWNER TO lootadmin;
204
205
206pg_restore: [archiver (db)] Error from TOC entry 197; 1259 116179 SEQUENCE auth_permission_id_seq lootadmin
207pg_restore: [archiver (db)] could not execute query: ERROR:  role "lootadmin" does not exist
208    Command was: ALTER TABLE auth_permission_id_seq OWNER TO lootadmin;
209
210
211pg_restore: [archiver (db)] Error from TOC entry 198; 1259 116181 TABLE auth_user lootadmin
212pg_restore: [archiver (db)] could not execute query: ERROR:  role "lootadmin" does not exist
213    Command was: ALTER TABLE auth_user OWNER TO lootadmin;
214
215
216pg_restore: [archiver (db)] Error from TOC entry 199; 1259 116187 TABLE auth_user_groups lootadmin
217pg_restore: [archiver (db)] could not execute query: ERROR:  role "lootadmin" does not exist
218    Command was: ALTER TABLE auth_user_groups OWNER TO lootadmin;
219
220
221pg_restore: [archiver (db)] Error from TOC entry 200; 1259 116190 SEQUENCE auth_user_groups_id_seq lootadmin
222pg_restore: [archiver (db)] could not execute query: ERROR:  role "lootadmin" does not exist
223    Command was: ALTER TABLE auth_user_groups_id_seq OWNER TO lootadmin;
224
225
226pg_restore: [archiver (db)] Error from TOC entry 201; 1259 116192 SEQUENCE auth_user_id_seq lootadmin
227pg_restore: [archiver (db)] could not execute query: ERROR:  role "lootadmin" does not exist
228    Command was: ALTER TABLE auth_user_id_seq OWNER TO lootadmin;
229
230
231pg_restore: [archiver (db)] Error from TOC entry 202; 1259 116194 TABLE auth_user_user_permissions lootadmin
232pg_restore: [archiver (db)] could not execute query: ERROR:  role "lootadmin" does not exist
233    Command was: ALTER TABLE auth_user_user_permissions OWNER TO lootadmin;
234
235
236pg_restore: [archiver (db)] Error from TOC entry 203; 1259 116197 SEQUENCE auth_user_user_permissions_id_seq lootadmin
237pg_restore: [archiver (db)] could not execute query: ERROR:  role "lootadmin" does not exist
238    Command was: ALTER TABLE auth_user_user_permissions_id_seq OWNER TO lootadmin;
239
240
241pg_restore: [archiver (db)] Error from TOC entry 204; 1259 116199 TABLE case_images lootadmin
242pg_restore: [archiver (db)] could not execute query: ERROR:  role "lootadmin" does not exist
243    Command was: ALTER TABLE case_images OWNER TO lootadmin;
244
245
246pg_restore: [archiver (db)] Error from TOC entry 205; 1259 116204 SEQUENCE case_images_id_seq lootadmin
247pg_restore: [archiver (db)] could not execute query: ERROR:  role "lootadmin" does not exist
248    Command was: ALTER TABLE case_images_id_seq OWNER TO lootadmin;
249
250
251pg_restore: [archiver (db)] Error from TOC entry 206; 1259 116206 TABLE case_items lootadmin
252pg_restore: [archiver (db)] could not execute query: ERROR:  role "lootadmin" does not exist
253    Command was: ALTER TABLE case_items OWNER TO lootadmin;
254
255
256pg_restore: [archiver (db)] Error from TOC entry 207; 1259 116213 SEQUENCE case_items_id_seq lootadmin
257pg_restore: [archiver (db)] could not execute query: ERROR:  role "lootadmin" does not exist
258    Command was: ALTER TABLE case_items_id_seq OWNER TO lootadmin;
259
260
261pg_restore: [archiver (db)] Error from TOC entry 208; 1259 116215 TABLE cases lootadmin
262pg_restore: [archiver (db)] could not execute query: ERROR:  role "lootadmin" does not exist
263    Command was: ALTER TABLE cases OWNER TO lootadmin;
264
265
266pg_restore: [archiver (db)] Error from TOC entry 209; 1259 116231 SEQUENCE cases_id_seq lootadmin
267pg_restore: [archiver (db)] could not execute query: ERROR:  role "lootadmin" does not exist
268    Command was: ALTER TABLE cases_id_seq OWNER TO lootadmin;
269
270
271pg_restore: [archiver (db)] Error from TOC entry 210; 1259 116233 TABLE configuration lootadmin
272pg_restore: [archiver (db)] could not execute query: ERROR:  role "lootadmin" does not exist
273    Command was: ALTER TABLE configuration OWNER TO lootadmin;
274
275
276pg_restore: [archiver (db)] Error from TOC entry 211; 1259 116239 TABLE deposits lootadmin
277pg_restore: [archiver (db)] could not execute query: ERROR:  role "lootadmin" does not exist
278    Command was: ALTER TABLE deposits OWNER TO lootadmin;
279
280
281pg_restore: [archiver (db)] Error from TOC entry 212; 1259 116246 SEQUENCE deposits_id_seq lootadmin
282pg_restore: [archiver (db)] could not execute query: ERROR:  role "lootadmin" does not exist
283    Command was: ALTER TABLE deposits_id_seq OWNER TO lootadmin;
284
285
286pg_restore: [archiver (db)] Error from TOC entry 213; 1259 116248 TABLE django_admin_log lootadmin
287pg_restore: [archiver (db)] could not execute query: ERROR:  role "lootadmin" does not exist
288    Command was: ALTER TABLE django_admin_log OWNER TO lootadmin;
289
290
291pg_restore: [archiver (db)] Error from TOC entry 214; 1259 116255 SEQUENCE django_admin_log_id_seq lootadmin
292pg_restore: [archiver (db)] could not execute query: ERROR:  role "lootadmin" does not exist
293    Command was: ALTER TABLE django_admin_log_id_seq OWNER TO lootadmin;
294
295
296pg_restore: [archiver (db)] Error from TOC entry 215; 1259 116257 TABLE django_content_type lootadmin
297pg_restore: [archiver (db)] could not execute query: ERROR:  role "lootadmin" does not exist
298    Command was: ALTER TABLE django_content_type OWNER TO lootadmin;
299
300
301pg_restore: [archiver (db)] Error from TOC entry 216; 1259 116260 SEQUENCE django_content_type_id_seq lootadmin
302pg_restore: [archiver (db)] could not execute query: ERROR:  role "lootadmin" does not exist
303    Command was: ALTER TABLE django_content_type_id_seq OWNER TO lootadmin;
304
305
306pg_restore: [archiver (db)] Error from TOC entry 217; 1259 116262 TABLE django_migrations lootadmin
307pg_restore: [archiver (db)] could not execute query: ERROR:  role "lootadmin" does not exist
308    Command was: ALTER TABLE django_migrations OWNER TO lootadmin;
309
310
311pg_restore: [archiver (db)] Error from TOC entry 218; 1259 116268 SEQUENCE django_migrations_id_seq lootadmin
312pg_restore: [archiver (db)] could not execute query: ERROR:  role "lootadmin" does not exist
313    Command was: ALTER TABLE django_migrations_id_seq OWNER TO lootadmin;
314
315
316pg_restore: [archiver (db)] Error from TOC entry 219; 1259 116270 TABLE django_session lootadmin
317pg_restore: [archiver (db)] could not execute query: ERROR:  role "lootadmin" does not exist
318    Command was: ALTER TABLE django_session OWNER TO lootadmin;
319
320
321pg_restore: [archiver (db)] Error from TOC entry 220; 1259 116276 TABLE games lootadmin
322pg_restore: [archiver (db)] could not execute query: ERROR:  role "lootadmin" does not exist
323    Command was: ALTER TABLE games OWNER TO lootadmin;
324
325
326pg_restore: [archiver (db)] Error from TOC entry 221; 1259 116288 SEQUENCE games_id_seq lootadmin
327pg_restore: [archiver (db)] could not execute query: ERROR:  role "lootadmin" does not exist
328    Command was: ALTER TABLE games_id_seq OWNER TO lootadmin;
329
330
331pg_restore: [archiver (db)] Error from TOC entry 222; 1259 116290 TABLE keys lootadmin
332pg_restore: [archiver (db)] could not execute query: ERROR:  role "lootadmin" does not exist
333    Command was: ALTER TABLE keys OWNER TO lootadmin;
334
335
336pg_restore: [archiver (db)] Error from TOC entry 223; 1259 116300 SEQUENCE keys_id_seq lootadmin
337pg_restore: [archiver (db)] could not execute query: ERROR:  role "lootadmin" does not exist
338    Command was: ALTER TABLE keys_id_seq OWNER TO lootadmin;
339
340
341pg_restore: [archiver (db)] Error from TOC entry 224; 1259 116302 TABLE migrations lootadmin
342pg_restore: [archiver (db)] could not execute query: ERROR:  role "lootadmin" does not exist
343    Command was: ALTER TABLE migrations OWNER TO lootadmin;
344
345
346pg_restore: [archiver (db)] Error from TOC entry 225; 1259 116308 TABLE orders lootadmin
347pg_restore: [archiver (db)] could not execute query: ERROR:  role "lootadmin" does not exist
348    Command was: ALTER TABLE orders OWNER TO lootadmin;
349
350
351pg_restore: [archiver (db)] Error from TOC entry 226; 1259 116317 SEQUENCE orders_id_seq lootadmin
352pg_restore: [archiver (db)] could not execute query: ERROR:  role "lootadmin" does not exist
353    Command was: ALTER TABLE orders_id_seq OWNER TO lootadmin;
354
355
356pg_restore: [archiver (db)] Error from TOC entry 227; 1259 116319 TABLE transactions lootadmin
357pg_restore: [archiver (db)] could not execute query: ERROR:  role "lootadmin" does not exist
358    Command was: ALTER TABLE transactions OWNER TO lootadmin;
359
360
361pg_restore: [archiver (db)] Error from TOC entry 228; 1259 116327 SEQUENCE transactions_id_seq lootadmin
362pg_restore: [archiver (db)] could not execute query: ERROR:  role "lootadmin" does not exist
363    Command was: ALTER TABLE transactions_id_seq OWNER TO lootadmin;
364
365
366pg_restore: [archiver (db)] Error from TOC entry 229; 1259 116329 TABLE users lootadmin
367pg_restore: [archiver (db)] could not execute query: ERROR:  relation "users" already exists
368    Command was: CREATE TABLE users (
369    id bigint NOT NULL,
370    created_at timestamp without time zone,
371    modified_at timestamp without t...
372pg_restore: [archiver (db)] could not execute query: ERROR:  role "lootadmin" does not exist
373    Command was: ALTER TABLE users OWNER TO lootadmin;
374
375
376pg_restore: [archiver (db)] Error from TOC entry 230; 1259 116341 SEQUENCE users_id_seq lootadmin
377pg_restore: [archiver (db)] could not execute query: ERROR:  role "lootadmin" does not exist
378    Command was: ALTER TABLE users_id_seq OWNER TO lootadmin;
379
380
381pg_restore: [archiver (db)] Error from TOC entry 3168; 0 0 SEQUENCE OWNED BY users_id_seq lootadmin
382pg_restore: [archiver (db)] could not execute query: ERROR:  sequence must have same owner as table it is linked to
383    Command was: ALTER SEQUENCE users_id_seq OWNED BY users.id;