DB backup Restore PostgresSql

Backup:

pg_dump dbname > dbname.bak

Restore:

psql test < dbname.bak

Comments

Set the time zone on an Amazon EC2 instance

We can set the timezone on an Amazon EC2 instance to CST by using following steps: Login to your EC2 instance. Execute the command: “sudo su” to become a root user. Execute the command: “timedatectl” to know the current timezone details. Execute the command: “rm /etc/localtime” ( Press Enter). For confirmation type “Y” and Press Enter. Execute the command: “cd /usr/share/zoneinfo” (Press Enter). Execute the command: “ln -s /usr/share/zoneinfo/Asia/Kolkata /etc/localtime” (Press Enter). Now check the timezone by using “timedatectl” command. That’s it. Timezone changed to CST successfully.(No need to reboot) Reference: https://www.quora.com/How-do-I-set-the-time-zone-on-an-Amazon-EC2-instance-to-CST https://stackoverflow.com/questions/11931566/how-to-set-the-time-zone-in-amazon-ec2

Kubernetes cluster installation using kubeadm

On Both Master and Slave Nodes Install docker following Official Docker Installation Guide Switch to root user sudo su - Change docker cgroup driver cat > /etc/docker/daemon.json <<EOF { "exec-opts": ["native.cgroupdriver=systemd"], "log-driver": "json-file", "log-opts": { "max-size": "100m" }, "storage-driver": "overlay2" } EOF systemctl daemon-reload systemctl restart docker Update the apt package index and install packages needed to use the Kubernetes apt repository: sudo apt-get update sudo apt-get install -y apt-transport-https ca-certificates curl Download the Google Cloud public signing key: sudo curl -fsSLo /usr/share/keyrings/kubernetes-archive-keyring.gpg https://packages.cloud.google.com/apt/doc/apt-key.gpg Add the Kubernetes apt repository: echo "deb [signed-by=/usr/share/keyrings/kubernetes-archive-keyring.gpg] https://apt.kubernetes.io/ kubernete

Shadab Shamsi's Blog

Search This Blog