AWS S3, MinIO, and IBM Cloud Object Storage backup and restore command examples

Deployment options: Netezza Performance Server for Cloud Pak for Data System Netezza Performance Server for Cloud Pak for Data

Learn about the commands that are used for backup and restore to AWS S3, MinIO, and IBM Cloud Object Storage.

AWS S3

Backup to AWS S3
nzbackup -db src_db -connector s3 -connectorArgs UNIQUE_ID=SAMPLEBKUP:ACCESS_KEY_ID=xxxxx:SECRET_ACCESS_KEY=xxxxx:DEFAULT_REGION=us-west-1:BUCKET_URL=my.backup.bucket
Restore from AWS S3
nzrestore -db target_db -sourcedb src_db -connector s3 -connectorArgs UNIQUE_ID=SAMPLEBKUP:ACCESS_KEY_ID=xxxxx:SECRET_ACCESS_KEY=xxxxx:DEFAULT_REGION=us-west-1:BUCKET_URL=my.backup.bucket
Note: ENDPOINT and MULTIPART_SIZE_MB are not mandatory.

MinIO

Backup to MinIO
nzbackup -db src_db -connector minio -connectorArgs UNIQUE_ID=SAMPLEBKUP:ACCESS_KEY_ID=xxxxxx:SECRET_ACCESS_KEY=xxxxxx: DEFAULT_REGION=us-east-1:BUCKET_URL=my.backup.bucket: ENDPOINT=hostname
Restore to MinIO
nzrestore -db target_db -sourcedb src_db -connector minio -connectorArgs UNIQUE_ID=SAMPLEBKUP:ACCESS_KEY_ID=xxxxxx:SECRET_ACCESS_KEY=xxxxxx: DEFAULT_REGION=us-east-1:BUCKET_URL=my.backup.bucket: ENDPOINT=hostname
Note: ENDPOINT is mandatory.

IBM Cloud Object Storage

Backup to IBM COS
$ nzbackup -db src_db -connector ibmcos -connectorArgs UNIQUE_ID=SAMPLEBKUP:ACCESS_KEY_ID=xxxxxx:SECRET_ACCESS_KEY=xxxxx:DEFAULT_REGION=us_geo:BUCKET_URL=my.backup.bucket:ENDPOINT=s3.us-east.cloud-object-storage.appdomain.cloud
Restore from IBM COS
$ nzrestore -db target_db -sourcedb src_db -connector ibmcos -connectorArgs UNIQUE_ID=SAMPLEBKUP:ACCESS_KEY_ID=xxxxxx:SECRET_ACCESS_KEY=xxxxx:DEFAULT_REGION=us_geo:BUCKET_URL=my.backup.bucket:ENDPOINT=s3.us-east.cloud-object-storage.appdomain.cloud
Note: ENDPOINT is mandatory.