pg_restore 12 "permission denied for schema" errors

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: pg_restore 12 "permission denied for schema" errors
Date: 2022-10-20 00:58:44
Message-ID: 287717df-88e2-a4a5-2025-260c39662bca@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

RDS Postgresql 12.11

Backed up a database from one RDS instance, and now am trying to restore it
to a new instance.  (If you're wondering why, it's to restore in an instance
with less disk space.)

Here are the commands:

export PGHOST=${RDSENV}.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com
cd /migrate/TASK001793786/2022-10-19b
DB=sides
pg_restore -v --create --clean --jobs=`nproc` -Fd --dbname=template1 $DB

Attached are log file extracts showing the errors.  The errors are only on
partitioned child tables, the list of which is also attached.  However, some
(but not many)

Some of the erroring tables are owned by sides_owner and some are owned by
"stransuser".

"\z" on a child with errors looks exactly like a child without errors.

What could be the problem?

--
Angular momentum makes the world go 'round.

Attachment Content-Type Size
pg_restore errors 1.log text/x-log 4.1 KB
pg_restore errors 2.log text/x-log 1.6 KB
all partitioned tables.txt text/plain 9.8 KB

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lists 2022-10-20 03:13:28 PG RPMS for RHEL 9 on aarch64?
Previous Message Tom Lane 2022-10-19 23:59:52 Re: Postgres 15 upgrades and template1 public schema