Hi team, to restore a migrated backup (from on premises to cloud), consider this:
The command depicted on https://cloud.ibm.com/docs/netezza?topic=netezza-migrating-onprem-cloud
./nzrestore -v -db <> -npshost <> -streams AUTO -connector s3 -connectorArgs BUCKET_URL=<>:UNIQUE_ID=<>:ACCESS_KEY_ID=<>:SECRET_ACCESS_KEY=<>:DEFAULT_REGION=<>
does not work, and the one that works has this structure:
./nzrestore -v -db <database> -host <Netezza API Server> -streams AUTO -connector s3 -connectorArgs BUCKET_URL=<BUCKETNAME>:UNIQUE_ID=<ID OF THE TAKEN BACKUP, APPEARS ON THE BACKUP DIRECTORY STRUCTURE AS A PARENT OF Netezza>:ACCESS_KEY_ID=<XXXX>:SECRET_ACCESS_KEY=<XXXX>:DEFAULT_REGION=<XXXX>:ENDPOINT=<XXXX> -u admin -pw <XXXX> -npshost <NPS HOSTNAME THAT APPEARS ON THE BACKUP DIRECTORY STRUCTURE AS A CHILD OF Netezza>
It would be nice if somebody could test this and if documentation is wrong, to correct it.
Thanks
Hi team, to restore a migrated backup (from on premises to cloud), consider this:
The command depicted on https://cloud.ibm.com/docs/netezza?topic=netezza-migrating-onprem-cloud
./nzrestore -v -db <> -npshost <> -streams AUTO -connector s3 -connectorArgs BUCKET_URL=<>:UNIQUE_ID=<>:ACCESS_KEY_ID=<>:SECRET_ACCESS_KEY=<>:DEFAULT_REGION=<>does not work, and the one that works has this structure:
./nzrestore -v -db <database> -host <Netezza API Server> -streams AUTO -connector s3 -connectorArgs BUCKET_URL=<BUCKETNAME>:UNIQUE_ID=<ID OF THE TAKEN BACKUP, APPEARS ON THE BACKUP DIRECTORY STRUCTURE AS A PARENT OF Netezza>:ACCESS_KEY_ID=<XXXX>:SECRET_ACCESS_KEY=<XXXX>:DEFAULT_REGION=<XXXX>:ENDPOINT=<XXXX> -u admin -pw <XXXX> -npshost <NPS HOSTNAME THAT APPEARS ON THE BACKUP DIRECTORY STRUCTURE AS A CHILD OF Netezza>It would be nice if somebody could test this and if documentation is wrong, to correct it.
Thanks