Re: pg_restore 12 "permission denied for schema" errors

Frank Gard <frank.von.postgresql.org@xxxxxxxxxxxxxxx> · Thu, 20 Oct 2022 07:03:00 +0200



    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}.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:
    > […]

          >      -d dbname
        

        >      --dbname=dbname
        

        >          Connect to database dbname and restore
          directly into the database. The dbname can 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.