Skip to main content

Change owner of database postgres

ALTER DATABASE target_database OWNER TO new_onwer;


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:

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 Add the Kubernetes  apt  repository: echo "deb [signed-by=/usr/share/keyrings/kubernetes-archive-keyring.gpg] kubernete