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.