From: | Patrick B <patrickbakerbr(at)gmail(dot)com> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Permissions pg_dump / import |
Date: | 2016-08-17 22:16:37 |
Message-ID: | CAJNY3iuO9xF0C-OWLpbd+bAZsouT11_ops2uN+Gxt8HUHUhGXw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Steve Crawford | 2016-08-17 22:30:09 | Re: Permissions pg_dump / import |
Previous Message | Gavin Flower | 2016-08-17 18:14:40 | Re: [GENERAL] C++ port of Postgres |