No permissions for restoring psql dump

[kuriwaki]

Hi, I'm having trouble loading these files. After some failed attempts, I've managed to go to the PostgreSQL shell on pgAdmin and run

\i <PATH TO DOWNLOADED precints20.sql

as suggested in https://stackoverflow.com/a/75131834.

This attempts a reload but in I error out with

psql:<PATH>/precincts20.sql:9910036: ERROR:  role "sbaltz" does not exist
psql:<PATH>/precincts20.sql:9910037: ERROR:  role "reader" does not exist

(where I've hidden my own paths with PATH).

This seems to be due to the last few lines in the postgresql dump:

GRANT SELECT ON TABLE public.precincts20 TO sbaltz;
GRANT SELECT ON TABLE public.precincts20 TO reader;

[kuriwaki]

Because most of this postgres dump was a single table formatted in tsv format, I ended up just reading the plain-text file instead of relying on SQL. In case of interest:

ret_all <- read_tsv(
  file = "precincts20.sql", 
  skip = 62, 
  n_max = 9909966,
  col_names = c("precinct", "office", "party_detailed", "party_simplified", "mode", 
                "votes", "county_name", "county_fips", "jurisdiction_name", 
                "jurisdiction_fips", "candidate", "district",
                "dataverse", "year", "stage", "state", "special", "writein", 
                "state_po", "state_fips", "state_cen", "state_ic", "date", 
                "readme_check", "magnitude"), 
  col_types = "ccccciciciccciccllciiidli")

this took about 17seconds for about 10 million rows