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 |
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 |