Redeployment on Dokku with imported database backup fails
A clean development instance, based on the last code version of scriptum (Budapest release) is to be deployed and access given to @mladen and Katya, Daria and Thies.
Unfortunately the database dump from the old instance will have the database name and user name hardcoded, which needs to be changed according to the new configuration, i.e. with sed -i, before importing it in to the new database.
Activity
mentioned in issue #199 (closed)
While an import of the database into the new Dokku environment succeeded, it threw few errors which may have been to design differences with the previous Dokku-Alt environment:
$ dokku postgres:connect degrowth2018_dev < 20170605_degrowth_dump.sql SET SET SET SET SET CREATE EXTENSION COMMENT SET SET SET CREATE TABLE ERROR: role "dbp2016-live" does not exist CREATE SEQUENCE ERROR: role "dbp2016-live" does not exist ALTER SEQUENCE CREATE TABLE ERROR: role "dbp2016-live" does not exist CREATE SEQUENCE ERROR: role "dbp2016-live" does not exist ALTER SEQUENCE CREATE TABLE ERROR: role "dbp2016-live" does not exist CREATE SEQUENCE ERROR: role "dbp2016-live" does not exist ALTER SEQUENCE CREATE TABLE ERROR: role "dbp2016-live" does not exist CREATE SEQUENCE ERROR: role "dbp2016-live" does not exist ALTER SEQUENCE CREATE TABLE ERROR: role "dbp2016-live" does not exist CREATE SEQUENCE ERROR: role "dbp2016-live" does not exist ALTER SEQUENCE CREATE TABLE ERROR: role "dbp2016-live" does not exist CREATE SEQUENCE ERROR: role "dbp2016-live" does not exist ALTER SEQUENCE CREATE TABLE ERROR: role "dbp2016-live" does not exist CREATE SEQUENCE ERROR: role "dbp2016-live" does not exist ALTER SEQUENCE CREATE TABLE ERROR: role "dbp2016-live" does not exist CREATE SEQUENCE ERROR: role "dbp2016-live" does not exist ALTER SEQUENCE CREATE TABLE ERROR: role "dbp2016-live" does not exist CREATE SEQUENCE ERROR: role "dbp2016-live" does not exist ALTER SEQUENCE CREATE TABLE ERROR: role "dbp2016-live" does not exist CREATE SEQUENCE ERROR: role "dbp2016-live" does not exist ALTER SEQUENCE CREATE TABLE ERROR: role "dbp2016-live" does not exist CREATE SEQUENCE ERROR: role "dbp2016-live" does not exist ALTER SEQUENCE CREATE TABLE ERROR: role "dbp2016-live" does not exist CREATE SEQUENCE ERROR: role "dbp2016-live" does not exist ALTER SEQUENCE CREATE TABLE ERROR: role "dbp2016-live" does not exist CREATE SEQUENCE ERROR: role "dbp2016-live" does not exist ALTER SEQUENCE CREATE TABLE ERROR: role "dbp2016-live" does not exist CREATE SEQUENCE ERROR: role "dbp2016-live" does not exist ALTER SEQUENCE CREATE TABLE ERROR: role "dbp2016-live" does not exist CREATE SEQUENCE ERROR: role "dbp2016-live" does not exist ALTER SEQUENCE CREATE TABLE ERROR: role "dbp2016-live" does not exist CREATE SEQUENCE ERROR: role "dbp2016-live" does not exist ALTER SEQUENCE CREATE TABLE ERROR: role "dbp2016-live" does not exist CREATE SEQUENCE ERROR: role "dbp2016-live" does not exist ALTER SEQUENCE CREATE TABLE ERROR: role "dbp2016-live" does not exist CREATE SEQUENCE ERROR: role "dbp2016-live" does not exist ALTER SEQUENCE CREATE TABLE ERROR: role "dbp2016-live" does not exist CREATE SEQUENCE ERROR: role "dbp2016-live" does not exist ALTER SEQUENCE CREATE TABLE ERROR: role "dbp2016-live" does not exist CREATE SEQUENCE ERROR: role "dbp2016-live" does not exist ALTER SEQUENCE CREATE TABLE ERROR: role "dbp2016-live" does not exist CREATE SEQUENCE ERROR: role "dbp2016-live" does not exist ALTER SEQUENCE CREATE TABLE ERROR: role "dbp2016-live" does not exist CREATE SEQUENCE ERROR: role "dbp2016-live" does not exist ALTER SEQUENCE CREATE TABLE ERROR: role "dbp2016-live" does not exist CREATE TABLE ERROR: role "dbp2016-live" does not exist CREATE SEQUENCE ERROR: role "dbp2016-live" does not exist ALTER SEQUENCE CREATE TABLE ERROR: role "dbp2016-live" does not exist CREATE SEQUENCE ERROR: role "dbp2016-live" does not exist ALTER SEQUENCE CREATE TABLE ERROR: role "dbp2016-live" does not exist CREATE SEQUENCE ERROR: role "dbp2016-live" does not exist ALTER SEQUENCE CREATE TABLE ERROR: role "dbp2016-live" does not exist CREATE SEQUENCE ERROR: role "dbp2016-live" does not exist ALTER SEQUENCE CREATE TABLE ERROR: role "dbp2016-live" does not exist CREATE SEQUENCE ERROR: role "dbp2016-live" does not exist ALTER SEQUENCE CREATE TABLE ERROR: role "dbp2016-live" does not exist CREATE SEQUENCE ERROR: role "dbp2016-live" does not exist ALTER SEQUENCE CREATE TABLE ERROR: role "dbp2016-live" does not exist CREATE SEQUENCE ERROR: role "dbp2016-live" does not exist ALTER SEQUENCE CREATE TABLE ERROR: role "dbp2016-live" does not exist CREATE SEQUENCE ERROR: role "dbp2016-live" does not exist ALTER SEQUENCE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE COPY 2030 setval -------- 2055 (1 row) COPY 1 setval -------- 1 (1 row) COPY 1 setval -------- 1 (1 row) COPY 154 setval -------- 162 (1 row) COPY 46 setval -------- 50 (1 row) COPY 1 setval -------- 1 (1 row) COPY 0 setval -------- 2393 (1 row) COPY 5 setval -------- 6 (1 row) COPY 184 setval -------- 234 (1 row) COPY 0 setval -------- 1 (1 row) COPY 1809 setval -------- 2206 (1 row) COPY 1061 setval -------- 1075 (1 row) COPY 433 setval -------- 442 (1 row) COPY 0 setval -------- 1 (1 row) COPY 0 setval -------- 1 (1 row) COPY 326 setval -------- 336 (1 row) COPY 1 setval -------- 1 (1 row) COPY 348 setval -------- 348 (1 row) COPY 1018 setval -------- 1293 (1 row) COPY 0 setval -------- 1 (1 row) COPY 32 setval -------- 1015 (1 row) COPY 18 setval -------- 18 (1 row) COPY 107 COPY 0 setval -------- 1 (1 row) COPY 16 setval -------- 16 (1 row) COPY 0 setval -------- 1 (1 row) COPY 0 setval -------- 1 (1 row) COPY 13 setval -------- 26 (1 row) COPY 858 setval -------- 870 (1 row) COPY 17909 setval -------- 17909 (1 row) COPY 0 setval -------- 1 (1 row) ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX REVOKE REVOKE GRANT GRANTWhere the old database is invoked with access priviledges for different applications using the same Postgres container, in new Dokku each database apparently lives in its own instance: Comparing Dokku-Alt:
root=# \l List of databases Name | Owner | Encoding | Collate | Ctype | Access privileges -----------------+----------+-----------+---------+-------+------------------------- db_dbp2016 | root | SQL_ASCII | C | C | =Tc/root + | | | | | root=CTc/root + | | | | | "dbp2016-live"=CTc/root db_dbp2016_live | root | SQL_ASCII | C | C | =Tc/root + | | | | | root=CTc/root db_frab | root | SQL_ASCII | C | C | =Tc/root + | | | | | root=CTc/root frab-stage | root | SQL_ASCII | C | C | =Tc/root + | | | | | root=CTc/root + | | | | | "frab-stage"=CTc/root postgres | postgres | SQL_ASCII | C | C | root | root | SQL_ASCII | C | C | template0 | postgres | SQL_ASCII | C | C | =c/postgres + | | | | | postgres=CTc/postgres template1 | postgres | SQL_ASCII | C | C | =c/postgres + | | | | | postgres=CTc/postgres testtet | root | SQL_ASCII | C | C | (9 rows)with Dokku
degrowth2018_dev=# \l List of databases Name | Owner | Encoding | Collate | Ctype | Access privileges ------------------+----------+----------+------------+------------+----------------------- degrowth2018_dev | postgres | UTF8 | en_US.utf8 | en_US.utf8 | postgres | postgres | UTF8 | en_US.utf8 | en_US.utf8 | template0 | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =c/postgres + | | | | | postgres=CTc/postgres template1 | postgres | UTF8 | en_US.utf8 | en_US.utf8 | =c/postgres + | | | | | postgres=CTc/postgres (4 rows)it doesn't show access privileges, why this error may be omitted.
Or this:
$ dokku postgres:logs degrowth2018_dev ERROR: role "degrowth2018-dev" does not exist STATEMENT: ALTER TABLE public.conflicts OWNER TO "degrowth2018-dev"; ERROR: role "degrowth2018-dev" does not exist STATEMENT: ALTER TABLE public.conflicts_id_seq OWNER TO "degrowth2018-dev"; ERROR: role "degrowth2018-dev" does not exist STATEMENT: ALTER TABLE public.days OWNER TO "degrowth2018-dev"; ERROR: role "degrowth2018-dev" does not exist STATEMENT: ALTER TABLE public.days_id_seq OWNER TO "degrowth2018-dev"; ERROR: role "degrowth2018-dev" does not exist STATEMENT: ALTER TABLE public.event_attachments OWNER TO "degrowth2018-dev"; ERROR: role "degrowth2018-dev" does not exist STATEMENT: ALTER TABLE public.event_attachments_id_seq OWNER TO "degrowth2018-dev"; ERROR: role "degrowth2018-dev" does not exist STATEMENT: ALTER TABLE public.event_feedbacks OWNER TO "degrowth2018-dev"; ERROR: role "degrowth2018-dev" does not exist STATEMENT: ALTER TABLE public.event_feedbacks_id_seq OWNER TO "degrowth2018-dev"; ERROR: role "degrowth2018-dev" does not exist STATEMENT: ALTER TABLE public.event_people OWNER TO "degrowth2018-dev"; ERROR: role "degrowth2018-dev" does not exist STATEMENT: ALTER TABLE public.event_people_id_seq OWNER TO "degrowth2018-dev"; ERROR: role "degrowth2018-dev" does not exist STATEMENT: ALTER TABLE public.event_ratings OWNER TO "degrowth2018-dev"; ERROR: role "degrowth2018-dev" does not exist STATEMENT: ALTER TABLE public.event_ratings_id_seq OWNER TO "degrowth2018-dev"; ERROR: role "degrowth2018-dev" does not exist STATEMENT: ALTER TABLE public.events OWNER TO "degrowth2018-dev"; ERROR: role "degrowth2018-dev" does not exist STATEMENT: ALTER TABLE public.events_id_seq OWNER TO "degrowth2018-dev"; ERROR: role "degrowth2018-dev" does not exist STATEMENT: ALTER TABLE public.im_accounts OWNER TO "degrowth2018-dev"; ERROR: role "degrowth2018-dev" does not exist STATEMENT: ALTER TABLE public.im_accounts_id_seq OWNER TO "degrowth2018-dev"; ERROR: role "degrowth2018-dev" does not exist STATEMENT: ALTER TABLE public.languages OWNER TO "degrowth2018-dev"; ERROR: role "degrowth2018-dev" does not exist STATEMENT: ALTER TABLE public.languages_id_seq OWNER TO "degrowth2018-dev"; ERROR: role "degrowth2018-dev" does not exist STATEMENT: ALTER TABLE public.links OWNER TO "degrowth2018-dev"; ERROR: role "degrowth2018-dev" does not exist STATEMENT: ALTER TABLE public.links_id_seq OWNER TO "degrowth2018-dev"; ERROR: role "degrowth2018-dev" does not exist STATEMENT: ALTER TABLE public.notifications OWNER TO "degrowth2018-dev"; ERROR: role "degrowth2018-dev" does not exist STATEMENT: ALTER TABLE public.notifications_id_seq OWNER TO "degrowth2018-dev"; ERROR: role "degrowth2018-dev" does not exist STATEMENT: ALTER TABLE public.payments OWNER TO "degrowth2018-dev"; ERROR: role "degrowth2018-dev" does not exist STATEMENT: ALTER TABLE public.payments_id_seq OWNER TO "degrowth2018-dev"; ERROR: role "degrowth2018-dev" does not exist STATEMENT: ALTER TABLE public.people OWNER TO "degrowth2018-dev"; ERROR: role "degrowth2018-dev" does not exist STATEMENT: ALTER TABLE public.people_id_seq OWNER TO "degrowth2018-dev"; ERROR: role "degrowth2018-dev" does not exist STATEMENT: ALTER TABLE public.phone_numbers OWNER TO "degrowth2018-dev"; ERROR: role "degrowth2018-dev" does not exist STATEMENT: ALTER TABLE public.phone_numbers_id_seq OWNER TO "degrowth2018-dev"; ERROR: role "degrowth2018-dev" does not exist STATEMENT: ALTER TABLE public.review_reservations OWNER TO "degrowth2018-dev"; ERROR: role "degrowth2018-dev" does not exist STATEMENT: ALTER TABLE public.review_reservations_id_seq OWNER TO "degrowth2018-dev"; ERROR: role "degrowth2018-dev" does not exist STATEMENT: ALTER TABLE public.rooms OWNER TO "degrowth2018-dev"; ERROR: role "degrowth2018-dev" does not exist STATEMENT: ALTER TABLE public.rooms_id_seq OWNER TO "degrowth2018-dev"; ERROR: role "degrowth2018-dev" does not exist STATEMENT: ALTER TABLE public.schema_migrations OWNER TO "degrowth2018-dev"; ERROR: role "degrowth2018-dev" does not exist STATEMENT: ALTER TABLE public.sessions OWNER TO "degrowth2018-dev"; ERROR: role "degrowth2018-dev" does not exist STATEMENT: ALTER TABLE public.sessions_id_seq OWNER TO "degrowth2018-dev"; ERROR: role "degrowth2018-dev" does not exist STATEMENT: ALTER TABLE public.subcategories OWNER TO "degrowth2018-dev"; ERROR: role "degrowth2018-dev" does not exist STATEMENT: ALTER TABLE public.subcategories_id_seq OWNER TO "degrowth2018-dev"; ERROR: role "degrowth2018-dev" does not exist STATEMENT: ALTER TABLE public.ticket_servers OWNER TO "degrowth2018-dev"; ERROR: role "degrowth2018-dev" does not exist STATEMENT: ALTER TABLE public.ticket_servers_id_seq OWNER TO "degrowth2018-dev"; ERROR: role "degrowth2018-dev" does not exist STATEMENT: ALTER TABLE public.tickets OWNER TO "degrowth2018-dev"; ERROR: role "degrowth2018-dev" does not exist STATEMENT: ALTER TABLE public.tickets_id_seq OWNER TO "degrowth2018-dev"; ERROR: role "degrowth2018-dev" does not exist STATEMENT: ALTER TABLE public.tracks OWNER TO "degrowth2018-dev"; ERROR: role "degrowth2018-dev" does not exist STATEMENT: ALTER TABLE public.tracks_id_seq OWNER TO "degrowth2018-dev"; ERROR: role "degrowth2018-dev" does not exist STATEMENT: ALTER TABLE public.users OWNER TO "degrowth2018-dev"; ERROR: role "degrowth2018-dev" does not exist STATEMENT: ALTER TABLE public.users_id_seq OWNER TO "degrowth2018-dev"; ERROR: role "degrowth2018-dev" does not exist STATEMENT: ALTER TABLE public.versions OWNER TO "degrowth2018-dev"; ERROR: role "degrowth2018-dev" does not exist STATEMENT: ALTER TABLE public.versions_id_seq OWNER TO "degrowth2018-dev"; ERROR: role "degrowth2018-dev" does not exist STATEMENT: ALTER TABLE public.videos OWNER TO "degrowth2018-dev"; ERROR: role "degrowth2018-dev" does not exist STATEMENT: ALTER TABLE public.videos_id_seq OWNER TO "degrowth2018-dev"; ERROR: syntax error at or near "use" at character 1 STATEMENT: use postgres; Connection to apps.allmende.io closed.
Please register or sign in to reply