Posts

Showing posts from September, 2018

Create Cockroach DB database and user

Image
Cockroach DB useful commands. Here are some useful cockroach DB commands and steps to create a cockroach DB database and uses of cockroach DB database. Create CockroachDB database : CREATE DATABASE cockroachdb; Create CockroachDB Database User : CREATE USER cockroachdb WITH PASSWORD 'vishal'; Grant Privileges on CockroachDB Databases : GRANT ALL ON DATABASE cockroachdb TO cockroachuser; GRANT ALL ON TABLE cockroachdb.* TO cockroachuser; Change cockroach db user password : ALTER USER vishal WITH PASSWORD 'newpassword'; Login to kubernetes deploy cockroach : psql 'postgresql://username@ip:26257?sslmode=allow' Import Cockroach db Dump : psql -p 26257 -h host -d database -U vishal < database.sql How to rename Cockroach database : ALTER DATABASE olddbname RENAME TO newdbname; Privilege Levels ALL Database, Table CREATE Database, Table DROP Database, Table GRANT Database, Table SELECT Table INSERT Table DELETE Ta

Install Helm On Ubuntu

Image
Helm is a tool for managing Kubernetes charts. Charts are packages of pre-configured Kubernetes resources. Here is the steps to install helm in Ubuntu 16.04 machine. Download helm :  $ wget https://storage.googleapis.com/kubernetes-helm/helm-v2.11.0-linux-amd64.tar.gz Untar the package :  $ tar -xvf helm-v2.11.0-linux-amd64.tar.gz Find "helm" from the directory and move it to given path. $ mv linux-amd64/helm /usr/local/bin/helm Verify helm version :  $ helm version Client: &version.Version{SemVer:"v2.11.0", GitCommit:"2e55dbe1fdb5fdb96b75ff144a339489417b146b", GitTreeState:"clean"}