Permissions pg_dump / import - Mailing list pgsql-general

From Patrick B
Subject Permissions pg_dump / import
Date
Msg-id CAJNY3iuO9xF0C-OWLpbd+bAZsouT11_ops2uN+Gxt8HUHUhGXw@mail.gmail.com
Whole thread Raw
Responses Re: Permissions pg_dump / import  (Steve Crawford <scrawford@pinpointresearch.com>)
Re: Permissions pg_dump / import  ("Ilya Kazakevich" <Ilya.Kazakevich@JetBrains.com>)
List pgsql-general
Hi guys,

I'm running a pg_dump and then importing the dump into a test server. I'm using PostgreSQL 9.5.

pg_dump:
pg_dump --dbname=prod1 --host= servername --port=5432 --username=user1 -v -f test1_NEW.sql

Steps into the new database (test1):

CREATE SCHEMA public;
GRANT ALL ON SCHEMA public TO user1;
psql -h servername -U master --port=5432 --dbname=test1 -f test1_NEW.sql


I get lots of errors like:

psql:test1_NEW.sql:212: ERROR:  must be owner of relation accounts_id_seq

prod1=> \d+ accounts_id_seq
            Sequence "public.accounts_id_seq"
    Column     |  Type   |        Value        | Storage 
---------------+---------+---------------------+---------
 sequence_name | name    | accounts_id_seq     | plain
 last_value    | bigint  | 33                  | plain
 start_value   | bigint  | 1                   | plain
 increment_by  | bigint  | 1                   | plain
 max_value     | bigint  | 9223372036854775807 | plain
 min_value     | bigint  | 1                   | plain
 cache_value   | bigint  | 1                   | plain
 log_cnt       | bigint  | 32                  | plain
 is_cycled     | boolean | f                   | plain
 is_called     | boolean | t                   | plain
Owned by: public.accounts.id 

What do I have to do? Should I revoke the permissions on the prod1 database before performing the dump?

Cheers;
Patrick 

pgsql-general by date:

Previous
From: gilad905
Date:
Subject: Re: Easiest way to compare the results of two queries row by row and column by column
Next
From: Steve Crawford
Date:
Subject: Re: Permissions pg_dump / import