I managed to automate backups of my PostgreSQL database to Amazon’s S3 cloud storage.
For this I used the guide on Gorails: Hourly Production Server Database And File Backups
However, the guide doesn’t tell how to restore these remotely stored backups.
I tried to do a restore with:
sudo su - postgres psql -1 posplus < production_backup
but that doesn’t do anything.
I guess I have to point the pg restore command somehow to the remote file but I have no idea how to do this.
Has anyone else experience with restoring a PostgreSQL backup file from a remote location?
thanks for your help,