Dallinger: Can't export data on `master`

(dallinger) ➜  wikiresearch git:(master) ✗ dallinger export --app 6560aa13-6891-44ff-b7aa-f7013813212f

    ____        ____
   / __ \____ _/ / (_)___  ____ ____  _____
  / / / / __ `/ / / / __ \/ __ `/ _ \/ ___/
 / /_/ / /_/ / / / / / / / /_/ /  __/ /
/_____/\__,_/_/_/_/_/ /_/\__, /\___/_/
                        /____/
                                   v3.4.0

                Laboratory automation for
       the behavioral and social sciences.

Preparing to export the data...
heroku-cli: Pulling postgresql-opaque-48028 ---> dlgr-6560aa13
pg_dump: last built-in OID is 16383
pg_dump: reading extensions
pg_dump: identifying extension members
pg_dump: reading schemas
pg_dump: reading user-defined tables
pg_dump: reading user-defined functions
pg_dump: reading user-defined types
pg_dump: reading procedural languages
pg_dump: reading user-defined aggregate functions
pg_dump: reading user-defined operators
pg_dump: reading user-defined access methods
pg_dump: reading user-defined operator classes
pg_dump: reading user-defined operator families
pg_dump: reading user-defined text search parsers
pg_dump: reading user-defined text search templates
pg_dump: reading user-defined text search dictionaries
pg_dump: reading user-defined text search configurations
pg_dump: reading user-defined foreign-data wrappers
pg_dump: reading user-defined foreign servers
pg_dump: reading default privileges
pg_dump: reading user-defined collations
pg_dump: reading user-defined conversions
pg_dump: reading type casts
pg_dump: reading transforms
pg_dump: reading table inheritance information
pg_dump: reading event triggers
pg_dump: finding extension tables
pg_dump: finding inheritance relationships
pg_dump: reading column info for interesting tables
pg_dump: finding the columns and types of table "public.pg_stat_statements"
pg_dump: finding the columns and types of table "public.network"
pg_dump: finding default expressions of table "public.network"
pg_dump: finding the columns and types of table "public.notification"
pg_dump: finding default expressions of table "public.notification"
pg_dump: finding the columns and types of table "public.participant"
pg_dump: finding default expressions of table "public.participant"
pg_dump: finding the columns and types of table "public.question"
pg_dump: finding default expressions of table "public.question"
pg_dump: finding the columns and types of table "public.node"
pg_dump: finding default expressions of table "public.node"
pg_dump: finding the columns and types of table "public.info"
pg_dump: finding default expressions of table "public.info"
pg_dump: finding the columns and types of table "public.vector"
pg_dump: finding default expressions of table "public.vector"
pg_dump: finding the columns and types of table "public.transformation"
pg_dump: finding default expressions of table "public.transformation"
pg_dump: finding the columns and types of table "public.transmission"
pg_dump: finding default expressions of table "public.transmission"
pg_dump: flagging inherited columns in subtables
pg_dump: reading indexes
pg_dump: reading indexes for table "public.network"
pg_dump: reading indexes for table "public.notification"
pg_dump: reading indexes for table "public.participant"
pg_dump: reading indexes for table "public.question"
pg_dump: reading indexes for table "public.node"
pg_dump: reading indexes for table "public.info"
pg_dump: reading indexes for table "public.vector"
pg_dump: reading indexes for table "public.transformation"
pg_dump: reading indexes for table "public.transmission"
pg_dump: reading constraints
pg_dump: reading foreign key constraints for table "public.network"
pg_dump: reading foreign key constraints for table "public.participant"
pg_dump: reading foreign key constraints for table "public.question"
pg_dump: reading foreign key constraints for table "public.node"
pg_dump: reading foreign key constraints for table "public.info"
pg_dump: reading foreign key constraints for table "public.vector"
pg_dump: reading foreign key constraints for table "public.transformation"
pg_dump: reading foreign key constraints for table "public.transmission"
pg_dump: reading triggers
pg_dump: reading triggers for table "public.network"
pg_dump: reading triggers for table "public.participant"
pg_dump: reading triggers for table "public.question"
pg_dump: reading triggers for table "public.node"
pg_dump: reading triggers for table "public.info"
pg_dump: reading triggers for table "public.vector"
pg_dump: reading triggers for table "public.transformation"
pg_dump: reading triggers for table "public.transmission"
pg_dump: reading rewrite rules
pg_dump: reading policies
pg_dump: reading row security enabled for table "public.pg_stat_statements"
pg_dump: reading policies for table "public.pg_stat_statements"
pg_dump: reading row security enabled for table "public.network_id_seq"
pg_dump: reading policies for table "public.network_id_seq"
pg_dump: reading row security enabled for table "public.network"
pg_dump: reading policies for table "public.network"
pg_dump: reading row security enabled for table "public.notification_id_seq"
pg_dump: reading policies for table "public.notification_id_seq"
pg_dump: reading row security enabled for table "public.notification"
pg_dump: reading policies for table "public.notification"
pg_dump: reading row security enabled for table "public.participant_id_seq"
pg_dump: reading policies for table "public.participant_id_seq"
pg_dump: reading row security enabled for table "public.participant"
pg_dump: reading policies for table "public.participant"
pg_dump: reading row security enabled for table "public.question_id_seq"
pg_dump: reading policies for table "public.question_id_seq"
pg_dump: reading row security enabled for table "public.question"
pg_dump: reading policies for table "public.question"
pg_dump: reading row security enabled for table "public.node_id_seq"
pg_dump: reading policies for table "public.node_id_seq"
pg_dump: reading row security enabled for table "public.node"
pg_dump: reading policies for table "public.node"
pg_dump: reading row security enabled for table "public.info_id_seq"
pg_dump: reading policies for table "public.info_id_seq"
pg_dump: reading row security enabled for table "public.info"
pg_dump: reading policies for table "public.info"
pg_dump: reading row security enabled for table "public.vector_id_seq"
pg_dump: reading policies for table "public.vector_id_seq"
pg_dump: reading row security enabled for table "public.vector"
pg_dump: reading policies for table "public.vector"
pg_dump: reading row security enabled for table "public.transformation_id_seq"
pg_dump: reading policies for table "public.transformation_id_seq"
pg_dump: reading row security enabled for table "public.transformation"
pg_dump: reading policies for table "public.transformation"
pg_dump: reading row security enabled for table "public.transmission_id_seq"
pg_dump: reading policies for table "public.transmission_id_seq"
pg_dump: reading row security enabled for table "public.transmission"
pg_dump: reading policies for table "public.transmission"
pg_dump: reading large objects
pg_dump: reading dependency data
pg_dump: saving encoding = UTF8
pg_dump: saving standard_conforming_strings = on
pg_dump: saving database definition
pg_dump: dumping contents of table "public.info"
pg_dump: dumping contents of table "public.network"
pg_restore: connecting to database for restore
pg_restore: creating SCHEMA "public"
pg_restore: creating COMMENT "SCHEMA public"
pg_restore: creating EXTENSION "plpgsql"
pg_restore: creating COMMENT "EXTENSION plpgsql"
pg_restore: creating EXTENSION "pg_stat_statements"
pg_restore: creating COMMENT "EXTENSION pg_stat_statements"
pg_restore: creating TYPE "public.participant_status"
pg_restore: creating TYPE "public.transmission_status"
pg_restore: creating TABLE "public.info"
pg_restore: creating SEQUENCE "public.info_id_seq"
pg_restore: creating SEQUENCE OWNED BY "public.info_id_seq"
pg_restore: creating TABLE "public.network"
pg_restore: creating SEQUENCE "public.network_id_seq"
pg_restore: creating SEQUENCE OWNED BY "public.network_id_seq"
pg_restore: creating TABLE "public.node"
pg_restore: creating SEQUENCE "public.node_id_seq"
pg_restore: creating SEQUENCE OWNED BY "public.node_id_seq"
pg_restore: creating TABLE "public.notification"
pg_restore: creating SEQUENCE "public.notification_id_seq"
pg_restore: creating SEQUENCE OWNED BY "public.notification_id_seq"
pg_restore: creating TABLE "public.participant"
pg_restore: creating SEQUENCE "public.participant_id_seq"
pg_restore: creating SEQUENCE OWNED BY "public.participant_id_seq"
pg_restore: creating TABLE "public.question"
pg_restore: creating SEQUENCE "public.question_id_seq"
pg_restore: creating SEQUENCE OWNED BY "public.question_id_seq"
pg_restore: creating TABLE "public.transformation"
pg_restore: pg_dump: dumping contents of table "public.node"
creating SEQUENCE "public.transformation_id_seq"
pg_restore: creating SEQUENCE OWNED BY "public.transformation_id_seq"
pg_restore: creating TABLE "public.transmission"
pg_restore: creating SEQUENCE "public.transmission_id_seq"
pg_restore: creating SEQUENCE OWNED BY "public.transmission_id_seq"
pg_restore: creating TABLE "public.vector"
pg_restore: creating SEQUENCE "public.vector_id_seq"
pg_restore: creating SEQUENCE OWNED BY "public.vector_id_seq"
pg_restore: creating DEFAULT "public.info id"
pg_restore: creating DEFAULT "public.network id"
pg_restore: creating DEFAULT "public.node id"
pg_restore: creating DEFAULT "public.notification id"
pg_restore: creating DEFAULT "public.participant id"
pg_restore: creating DEFAULT "public.question id"
pg_restore: creating DEFAULT "public.transformation id"
pg_restore: creating DEFAULT "public.transmission id"
pg_restore: creating DEFAULT "public.vector id"
pg_restore: processing data for table "public.info"
pg_dump: dumping contents of table "public.notification"
pg_dump: dumping contents of table "public.participant"
pg_dump: dumping contents of table "public.question"
pg_dump: dumping contents of table "public.transformation"
pg_dump: dumping contents of table "public.transmission"
pg_dump: dumping contents of table "public.vector"
pg_restore: executing SEQUENCE SET info_id_seq
pg_restore: processing data for table "public.network"
pg_restore: executing SEQUENCE SET network_id_seq
pg_restore: processing data for table "public.node"
pg_restore: executing SEQUENCE SET node_id_seq
pg_restore: processing data for table "public.notification"
pg_restore: executing SEQUENCE SET notification_id_seq
pg_restore: processing data for table "public.participant"
pg_restore: executing SEQUENCE SET participant_id_seq
pg_restore: processing data for table "public.question"
pg_restore: executing SEQUENCE SET question_id_seq
pg_restore: processing data for table "public.transformation"
pg_restore: executing SEQUENCE SET transformation_id_seq
pg_restore: processing data for table "public.transmission"
pg_restore: executing SEQUENCE SET transmission_id_seq
pg_restore: processing data for table "public.vector"
pg_restore: executing SEQUENCE SET vector_id_seq
pg_restore: creating CONSTRAINT "public.info info_pkey"
pg_restore: creating CONSTRAINT "public.network network_pkey"
pg_restore: creating CONSTRAINT "public.node node_pkey"
pg_restore: creating CONSTRAINT "public.notification notification_pkey"
pg_restore: creating CONSTRAINT "public.participant participant_pkey"
pg_restore: creating CONSTRAINT "public.question question_pkey"
pg_restore: creating CONSTRAINT "public.transformation transformation_pkey"
pg_restore: creating CONSTRAINT "public.transmission transmission_pkey"
pg_restore: creating CONSTRAINT "public.vector vector_pkey"
pg_restore: creating INDEX "public.ix_info_failed"
pg_restore: creating INDEX "public.ix_info_id"
pg_restore: creating INDEX "public.ix_info_network_id"
pg_restore: creating INDEX "public.ix_info_origin_id"
pg_restore: creating INDEX "public.ix_network_failed"
pg_restore: creating INDEX "public.ix_network_full"
pg_restore: creating INDEX "public.ix_network_id"
pg_restore: creating INDEX "public.ix_network_role"
pg_restore: creating INDEX "public.ix_node_failed"
pg_restore: creating INDEX "public.ix_node_id"
pg_restore: creating INDEX "public.ix_node_network_id"
pg_restore: creating INDEX "public.ix_node_participant_id"
pg_restore: creating INDEX "public.ix_notification_failed"
pg_restore: creating INDEX "public.ix_notification_id"
pg_restore: creating INDEX "public.ix_participant_assignment_id"
pg_restore: creating INDEX "public.ix_participant_failed"
pg_restore: creating INDEX "public.ix_participant_id"
pg_restore: creating INDEX "public.ix_participant_status"
pg_restore: creating INDEX "public.ix_participant_unique_id"
pg_restore: creating INDEX "public.ix_question_failed"
pg_restore: creating INDEX "public.ix_question_id"
pg_restore: creating INDEX "public.ix_transformation_failed"
pg_restore: creating INDEX "public.ix_transformation_id"
pg_restore: creating INDEX "public.ix_transformation_info_in_id"
pg_restore: creating INDEX "public.ix_transformation_info_out_id"
pg_restore: creating INDEX "public.ix_transformation_network_id"
pg_restore: creating INDEX "public.ix_transformation_node_id"
pg_restore: creating INDEX "public.ix_transmission_destination_id"
pg_restore: creating INDEX "public.ix_transmission_failed"
pg_restore: creating INDEX "public.ix_transmission_id"
pg_restore: creating INDEX "public.ix_transmission_info_id"
pg_restore: creating INDEX "public.ix_transmission_network_id"
pg_restore: creating INDEX "public.ix_transmission_origin_id"
pg_restore: creating INDEX "public.ix_transmission_status"
pg_restore: creating INDEX "public.ix_transmission_vector_id"
pg_restore: creating INDEX "public.ix_vector_destination_id"
pg_restore: creating INDEX "public.ix_vector_failed"
pg_restore: creating INDEX "public.ix_vector_id"
pg_restore: creating INDEX "public.ix_vector_network_id"
pg_restore: creating INDEX "public.ix_vector_origin_id"
pg_restore: creating FK CONSTRAINT "public.info info_network_id_fkey"
pg_restore: creating FK CONSTRAINT "public.info info_origin_id_fkey"
pg_restore: creating FK CONSTRAINT "public.node node_network_id_fkey"
pg_restore: creating FK CONSTRAINT "public.node node_participant_id_fkey"
pg_restore: creating FK CONSTRAINT "public.question question_participant_id_fkey"
pg_restore: creating FK CONSTRAINT "public.transformation transformation_info_in_id_fkey"
pg_restore: creating FK CONSTRAINT "public.transformation transformation_info_out_id_fkey"
pg_restore: creating FK CONSTRAINT "public.transformation transformation_network_id_fkey"
pg_restore: creating FK CONSTRAINT "public.transformation transformation_node_id_fkey"
pg_restore: creating FK CONSTRAINT "public.transmission transmission_destination_id_fkey"
pg_restore: creating FK CONSTRAINT "public.transmission transmission_info_id_fkey"
pg_restore: creating FK CONSTRAINT "public.transmission transmission_network_id_fkey"
pg_restore: creating FK CONSTRAINT "public.transmission transmission_origin_id_fkey"
pg_restore: creating FK CONSTRAINT "public.transmission transmission_vector_id_fkey"
pg_restore: creating FK CONSTRAINT "public.vector vector_destination_id_fkey"
pg_restore: creating FK CONSTRAINT "public.vector vector_network_id_fkey"
pg_restore: creating FK CONSTRAINT "public.vector vector_origin_id_fkey"
pg_restore: setting owner and privileges for DATABASE "d5e07lbkr3qik5"
pg_restore: setting owner and privileges for SCHEMA "public"
pg_restore: setting owner and privileges for COMMENT "SCHEMA public"
pg_restore: setting owner and privileges for EXTENSION "plpgsql"
pg_restore: setting owner and privileges for COMMENT "EXTENSION plpgsql"
pg_restore: setting owner and privileges for EXTENSION "pg_stat_statements"
pg_restore: setting owner and privileges for COMMENT "EXTENSION pg_stat_statements"
pg_restore: setting owner and privileges for TYPE "public.participant_status"
pg_restore: setting owner and privileges for TYPE "public.transmission_status"
pg_restore: setting owner and privileges for TABLE "public.info"
pg_restore: setting owner and privileges for SEQUENCE "public.info_id_seq"
pg_restore: setting owner and privileges for SEQUENCE OWNED BY "public.info_id_seq"
pg_restore: setting owner and privileges for TABLE "public.network"
pg_restore: setting owner and privileges for SEQUENCE "public.network_id_seq"
pg_restore: setting owner and privileges for SEQUENCE OWNED BY "public.network_id_seq"
pg_restore: setting owner and privileges for TABLE "public.node"
pg_restore: setting owner and privileges for SEQUENCE "public.node_id_seq"
pg_restore: setting owner and privileges for SEQUENCE OWNED BY "public.node_id_seq"
pg_restore: setting owner and privileges for TABLE "public.notification"
pg_restore: setting owner and privileges for SEQUENCE "public.notification_id_seq"
pg_restore: setting owner and privileges for SEQUENCE OWNED BY "public.notification_id_seq"
pg_restore: setting owner and privileges for TABLE "public.participant"
pg_restore: setting owner and privileges for SEQUENCE "public.participant_id_seq"
pg_restore: setting owner and privileges for SEQUENCE OWNED BY "public.participant_id_seq"
pg_restore: setting owner and privileges for TABLE "public.question"
pg_restore: setting owner and privileges for SEQUENCE "public.question_id_seq"
pg_restore: setting owner and privileges for SEQUENCE OWNED BY "public.question_id_seq"
pg_restore: setting owner and privileges for TABLE "public.transformation"
pg_restore: setting owner and privileges for SEQUENCE "public.transformation_id_seq"
pg_restore: setting owner and privileges for SEQUENCE OWNED BY "public.transformation_id_seq"
pg_restore: setting owner and privileges for TABLE "public.transmission"
pg_restore: setting owner and privileges for SEQUENCE "public.transmission_id_seq"
pg_restore: setting owner and privileges for SEQUENCE OWNED BY "public.transmission_id_seq"
pg_restore: setting owner and privileges for TABLE "public.vector"
pg_restore: setting owner and privileges for SEQUENCE "public.vector_id_seq"
pg_restore: setting owner and privileges for SEQUENCE OWNED BY "public.vector_id_seq"
pg_restore: setting owner and privileges for DEFAULT "public.info id"
pg_restore: setting owner and privileges for DEFAULT "public.network id"
pg_restore: setting owner and privileges for DEFAULT "public.node id"
pg_restore: setting owner and privileges for DEFAULT "public.notification id"
pg_restore: setting owner and privileges for DEFAULT "public.participant id"
pg_restore: setting owner and privileges for DEFAULT "public.question id"
pg_restore: setting owner and privileges for DEFAULT "public.transformation id"
pg_restore: setting owner and privileges for DEFAULT "public.transmission id"
pg_restore: setting owner and privileges for DEFAULT "public.vector id"
pg_restore: setting owner and privileges for TABLE DATA "public.info"
pg_restore: setting owner and privileges for SEQUENCE SET "public.info_id_seq"
pg_restore: setting owner and privileges for TABLE DATA "public.network"
pg_restore: setting owner and privileges for SEQUENCE SET "public.network_id_seq"
pg_restore: setting owner and privileges for TABLE DATA "public.node"
pg_restore: setting owner and privileges for SEQUENCE SET "public.node_id_seq"
pg_restore: setting owner and privileges for TABLE DATA "public.notification"
pg_restore: setting owner and privileges for SEQUENCE SET "public.notification_id_seq"
pg_restore: setting owner and privileges for TABLE DATA "public.participant"
pg_restore: setting owner and privileges for SEQUENCE SET "public.participant_id_seq"
pg_restore: setting owner and privileges for TABLE DATA "public.question"
pg_restore: setting owner and privileges for SEQUENCE SET "public.question_id_seq"
pg_restore: setting owner and privileges for TABLE DATA "public.transformation"
pg_restore: setting owner and privileges for SEQUENCE SET "public.transformation_id_seq"
pg_restore: setting owner and privileges for TABLE DATA "public.transmission"
pg_restore: setting owner and privileges for SEQUENCE SET "public.transmission_id_seq"
pg_restore: setting owner and privileges for TABLE DATA "public.vector"
pg_restore: setting owner and privileges for SEQUENCE SET "public.vector_id_seq"
pg_restore: setting owner and privileges for CONSTRAINT "public.info info_pkey"
pg_restore: setting owner and privileges for CONSTRAINT "public.network network_pkey"
pg_restore: setting owner and privileges for CONSTRAINT "public.node node_pkey"
pg_restore: setting owner and privileges for CONSTRAINT "public.notification notification_pkey"
pg_restore: setting owner and privileges for CONSTRAINT "public.participant participant_pkey"
pg_restore: setting owner and privileges for CONSTRAINT "public.question question_pkey"
pg_restore: setting owner and privileges for CONSTRAINT "public.transformation transformation_pkey"
pg_restore: setting owner and privileges for CONSTRAINT "public.transmission transmission_pkey"
pg_restore: setting owner and privileges for CONSTRAINT "public.vector vector_pkey"
pg_restore: setting owner and privileges for INDEX "public.ix_info_failed"
pg_restore: setting owner and privileges for INDEX "public.ix_info_id"
pg_restore: setting owner and privileges for INDEX "public.ix_info_network_id"
pg_restore: setting owner and privileges for INDEX "public.ix_info_origin_id"
pg_restore: setting owner and privileges for INDEX "public.ix_network_failed"
pg_restore: setting owner and privileges for INDEX "public.ix_network_full"
pg_restore: setting owner and privileges for INDEX "public.ix_network_id"
pg_restore: setting owner and privileges for INDEX "public.ix_network_role"
pg_restore: setting owner and privileges for INDEX "public.ix_node_failed"
pg_restore: setting owner and privileges for INDEX "public.ix_node_id"
pg_restore: setting owner and privileges for INDEX "public.ix_node_network_id"
pg_restore: setting owner and privileges for INDEX "public.ix_node_participant_id"
pg_restore: setting owner and privileges for INDEX "public.ix_notification_failed"
pg_restore: setting owner and privileges for INDEX "public.ix_notification_id"
pg_restore: setting owner and privileges for INDEX "public.ix_participant_assignment_id"
pg_restore: setting owner and privileges for INDEX "public.ix_participant_failed"
pg_restore: setting owner and privileges for INDEX "public.ix_participant_id"
pg_restore: setting owner and privileges for INDEX "public.ix_participant_status"
pg_restore: setting owner and privileges for INDEX "public.ix_participant_unique_id"
pg_restore: setting owner and privileges for INDEX "public.ix_question_failed"
pg_restore: setting owner and privileges for INDEX "public.ix_question_id"
pg_restore: setting owner and privileges for INDEX "public.ix_transformation_failed"
pg_restore: setting owner and privileges for INDEX "public.ix_transformation_id"
pg_restore: setting owner and privileges for INDEX "public.ix_transformation_info_in_id"
pg_restore: setting owner and privileges for INDEX "public.ix_transformation_info_out_id"
pg_restore: setting owner and privileges for INDEX "public.ix_transformation_network_id"
pg_restore: setting owner and privileges for INDEX "public.ix_transformation_node_id"
pg_restore: setting owner and privileges for INDEX "public.ix_transmission_destination_id"
pg_restore: setting owner and privileges for INDEX "public.ix_transmission_failed"
pg_restore: setting owner and privileges for INDEX "public.ix_transmission_id"
pg_restore: setting owner and privileges for INDEX "public.ix_transmission_info_id"
pg_restore: setting owner and privileges for INDEX "public.ix_transmission_network_id"
pg_restore: setting owner and privileges for INDEX "public.ix_transmission_origin_id"
pg_restore: setting owner and privileges for INDEX "public.ix_transmission_status"
pg_restore: setting owner and privileges for INDEX "public.ix_transmission_vector_id"
pg_restore: setting owner and privileges for INDEX "public.ix_vector_destination_id"
pg_restore: setting owner and privileges for INDEX "public.ix_vector_failed"
pg_restore: setting owner and privileges for INDEX "public.ix_vector_id"
pg_restore: setting owner and privileges for INDEX "public.ix_vector_network_id"
pg_restore: setting owner and privileges for INDEX "public.ix_vector_origin_id"
pg_restore: setting owner and privileges for FK CONSTRAINT "public.info info_network_id_fkey"
pg_restore: setting owner and privileges for FK CONSTRAINT "public.info info_origin_id_fkey"
pg_restore: setting owner and privileges for FK CONSTRAINT "public.node node_network_id_fkey"
pg_restore: setting owner and privileges for FK CONSTRAINT "public.node node_participant_id_fkey"
pg_restore: setting owner and privileges for FK CONSTRAINT "public.question question_participant_id_fkey"
pg_restore: setting owner and privileges for FK CONSTRAINT "public.transformation transformation_info_in_id_fkey"
pg_restore: setting owner and privileges for FK CONSTRAINT "public.transformation transformation_info_out_id_fkey"
pg_restore: setting owner and privileges for FK CONSTRAINT "public.transformation transformation_network_id_fkey"
pg_restore: setting owner and privileges for FK CONSTRAINT "public.transformation transformation_node_id_fkey"
pg_restore: setting owner and privileges for FK CONSTRAINT "public.transmission transmission_destination_id_fkey"
pg_restore: setting owner and privileges for FK CONSTRAINT "public.transmission transmission_info_id_fkey"
pg_restore: setting owner and privileges for FK CONSTRAINT "public.transmission transmission_network_id_fkey"
pg_restore: setting owner and privileges for FK CONSTRAINT "public.transmission transmission_origin_id_fkey"
pg_restore: setting owner and privileges for FK CONSTRAINT "public.transmission transmission_vector_id_fkey"
pg_restore: setting owner and privileges for FK CONSTRAINT "public.vector vector_destination_id_fkey"
pg_restore: setting owner and privileges for FK CONSTRAINT "public.vector vector_network_id_fkey"
pg_restore: setting owner and privileges for FK CONSTRAINT "public.vector vector_origin_id_fkey"
heroku-cli: Pulling complete.
Traceback (most recent call last):
  File "/usr/local/bin/dallinger", line 11, in <module>
    load_entry_point('dallinger', 'console_scripts', 'dallinger')()
  File "/usr/local/lib/python2.7/site-packages/click/core.py", line 722, in __call__
    return self.main(*args, **kwargs)
  File "/usr/local/lib/python2.7/site-packages/click/core.py", line 697, in main
    rv = self.invoke(ctx)
  File "/usr/local/lib/python2.7/site-packages/click/core.py", line 1066, in invoke
    return _process_result(sub_ctx.command.invoke(sub_ctx))
  File "/usr/local/lib/python2.7/site-packages/click/core.py", line 895, in invoke
    return ctx.invoke(self.callback, **ctx.params)
  File "/usr/local/lib/python2.7/site-packages/click/core.py", line 535, in invoke
    return callback(*args, **kwargs)
  File "/Users/jordansuchow/Dropbox/Berkeley/Projects/Current/Dallinger/dallinger/command_line.py", line 700, in export
    data.export(str(app), local=local, scrub_pii=(not no_scrub))
  File "/Users/jordansuchow/Dropbox/Berkeley/Projects/Current/Dallinger/dallinger/data.py", line 228, in export
    copy_local_to_csv(local_db, subdata_path, scrub_pii=scrub_pii)
  File "/Users/jordansuchow/Dropbox/Berkeley/Projects/Current/Dallinger/dallinger/data.py", line 182, in copy_local_to_csv
    cur.copy_expert(sql, f)
psycopg2.ProgrammingError: permission denied for relation info

About this issue

Original URL
State: closed
Created 7 years ago
Comments: 16 (8 by maintainers)

Most upvoted comments

I think on balance I’d be more comfortable with:

createuser dallinger --createdb

than --superuser. This appears to be sufficient.

It looks like we don’t have any documentation on pg:pull just yet, but we should mention that on some systems you might also need PGHOST=localhost as a environment variable. On Linux if a host isn’t specified an AF_UNIX socket is used to connect to the server, which defaults to the peer authentication method. This doesn’t allow the user to specify the password, only to log in as a user that is named identically to their system user.

Running the command you gave above gives me the following output locally:

(venv) ubuntu@ubuntu-xenial:/vagrant/demos/dlgr/demos/bartlett1932$ PGUSER=dallinger PGPASSWORD=dallinger heroku pg:pull DATABASE_URL dlgr-6560aa13 --app dlgr-6560aa13
▸    heroku-cli: update available from 6.13.18 to 6.14.20-737bba7
heroku-cli: Pulling postgresql-opaque-48028 ---> dlgr-6560aa13
createdb: could not connect to database template1: FATAL:  Peer authentication failed for user "dallinger"

but it’s fixed if I run:

(venv) ubuntu@ubuntu-xenial:/vagrant/demos/dlgr/demos/bartlett1932$ PGHOST=127.0.0.1 PGUSER=dallinger PGPASSWORD=dallinger heroku pg:pull DATABASE_URL dlgr-6560aa13 --app dlgr-6560aa13

MatthewWilkes on Sep 11, 2017