Heroku | Database import / export

On the surface, PGBackups provides a way to capture regular backups of your Heroku Postgres database. However, because of its general-purpose architecture and use of standard PostgreSQL utilities, it’s also a useful tool capable of exporting to or importing from external PostgreSQL databases. An alternative to using the dump and restore method of import/export if you have a Postgres instance on yo

[YassLab]

“Generate a signed URL using the AWS console: $ aws s3 presign s3://your-bucket-address/your-object ... / Use the raw file URL in the pg:backups restore command: $ heroku pg:backups:restore '<SIGNED URL>' DATABASE_URL --app example-app ”

[niseissa]

dbのリストアはこちら