PostgreSQL Dump to Samba Share

pg-dump-to-smb can be used to create a backup of a Postgres database and upload the backup to an Samba server. The backup file will be in tar.gz format, with the format {database name}-backup-YYYY_MM_DD_HH_MI_AM.tar.gz and will be uploaded to the smb share specified.

It can be used to back up databases in AWS RDS to Azure Storage using AWS Batch. The following links may be of use

Creating and use an Azure file share https://learn.microsoft.com/en-us/azure/storage/files/storage-how-to-use-files-portal?tabs=azure-portal

Create and connect to a PostgreSQL database with Amazon RDS https://aws.amazon.com/getting-started/hands-on/create-connect-postgresql-db/

The following variables are requied:

Variable	Description
PGHOST	PostgreSQL DB host
PGDATABASE	PostgreSQL DB database name
PGPORT	PostgreSQL DB Port
PGUSER	PostgreSQL DB user
PGPASSWORD	PostgreSQL DB password
SHARE	Samba share
USER	Samba user
PASSWD	Samba password

When building the the image for AWS do so for the linux/amd64 architecture otherwise you will get an "exec format error"

pg-dump-to-smb % docker build --platform=linux/amd64  -t  "khetho/pg-dump-to-smb" .

Testing the Backup

To test a backup dbname-backup-YYYY_MM_DD_HH_MI_AM.tar.gz first gunzip it to get the tar file which you can use as input to pg_restore

gunzip dbname-backup-YYYY_MM_DD_HH_MI_AM.tar.gz
pg_restore -h host -p 5432 -U user -d dbname -OcC dbname-backup-YYYY_MM_DD_HH_MI_AM.tar

Docker can be used to create a temporary PostgreSQL database for testing as per below

docker run  --name dbname  -p 5432:5432 -e POSTGRES_USER=user -e POSTGRES_PASSWORD=password -e POSTGRES_DB=dbname -d postgres

Make sure to specify parameters as per your requirements.