Re: pg_restore 12 "permission denied for schema" errors

2022-10-20 Thread 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

Re: pg_restore 12 "permission denied for schema" errors

2022-10-19 Thread 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}.x