Re: pg_restore 12 "permission denied for schema" errors

[Frank Gard]

Hi Ron,

Am 20.10.22 um 02:58 schrieb Ron:

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


What database do you want to restore your data into? As far as I know your 
pg_restore command would import the data into template1, right? pg_restore's 
manpage says:


[…]

> -ddbname
> --dbname=dbname
>  Connect to database dbnameand restore directly into the database. 
The dbnamecan be a connection string. If so, connection string parameters will 
override any conflicting command line options.
> […] ^^

And I'm wondering, if it's what you want. Possibly your errors could come from 
there…

Cheers,
Frank.

Re: pg_restore 12 "permission denied for schema" errors

[Frank Gard]

Hi Tom,

Am 20.10.22 um 07:12 schrieb Tom Lane:

Frank Gard  writes:

Am 20.10.22 um 02:58 schrieb Ron:

pg_restore -v --create --clean --jobs=`nproc` -Fd --dbname=template1 $DB

What database do you want to restore your data into? As far as I know your 
pg_restore command would import the data into template1, right?

No --- my ears went up about that too, but he's using --create.
So template1 is just the springboard for the initial connection
in which CREATE DATABASE will be issued.

you're right, of course. Overseen that detail. I've to learn to read more 
carefully before answering. Sorry.

Frank.