Hi Ron, Am 20.10.22 um 02:58 schrieb Ron:
RDS Postgresql 12.11Backed 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
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.
