Skip to main content

DB backup Restore PostgresSql

Backup:
pg_dump dbname > dbname.bak
Restore:
psql test < dbname.bak

Comments

Popular posts from this blog

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