AWS S3, MinIO, and IBM COS backup and restore command examples

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

This section demonstrates and discusses sample commands for backup and restore to AWS S3, MinIO, and IBM COS cloud 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 COS

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.