When you go thru regular database maintenance you might need to drop some objects. In some cases this objects have dependencies, this is the case of Sequences. So this is the error you get when you try to drop a sequence and that sequences is used in...

Continue reading

Migrate one Schema fast and dirty from one Vertica Cluster to another. This approach is used when : you don't have Vertica Cluster configuration the same in both Clusters and copy cluster won't work. no INBOUND access is available to the source Vertica Database(Production security needs...

Continue reading

Google Cloud SDK (gcloud)contains tools and libraries that enable you to easily create and manage resources on Google Cloud Platform. Installing Google Cloud SDK(gcloud) is quite simple and Google does all the work for you. you will need to run the following command logged as root user. [crayon-595293c8180d1575323871/] Restart...

Continue reading

In this article we will see how we can install the AWS client using two simple shell scripts. The scripts are: conf_vars.sh will hold your AWS account credentials and your region data. installAWSClient.sh will download, install and configure your AWS client. Lets see the content of the scripts: conf_vars.sh [crayon-595293c81a3bf727341511/] edit...

Continue reading