Creating external Postgres cluster

Install postgres

sudo apt-get install postgresql


Check postgres is running or not

pgrep -u postgres -fa -- -D


config_file=/etc/postgresql/12/main/postgresql.conf


Run database cluster

pg_ctlcluster 12 main start


Run from service

systemctl start postgresql

systemctl status postgresql


Check running port for postgres

sed -n 4p /var/lib/postgresql/12/main/postmaster.pid


Creating a new postgres database

sudo su - postgres  (Login as postgres user)

psql -c "create database db-test-01;"

create database db_test_02;


Create new user for database access

create user dbadmin02 with encrypted password 'whitecat';


Change password if forgot

psql

ALTER USER dbadmin02 WITH PASSWORD 'whitecat';


Grant the user to access to that database

grant all privileges on database db_test_02 to dbadmin02;


Setting up firewall


sudo ufw allow 22

sudo ufw allow 5432

sudo ufw enable


//Allow to connect from anywhere

nano /etc/postgresql/12/main/postgresql.conf

listen_addresses = '*'


//Edit pg_hba.conf file

nano /etc/postgresql/12//main/pg_hba.conf

host    all             all             0.0.0.0/0               md5


sudo service postgresql restart


Comments

Post a Comment

Popular posts from this blog

Setting up Odoo 13 on Digital Ocean's ubuntu

Create a new VPS server in Digital Ocean.  Login using Any SSH Client (Eg: Putty or Bitwise Client) =============================================== Open a terminal and run the following commands These steps are specifically for Ubuntu Version 18.  Before proceed, please check your OS version using command  ======================== lsb_release -a  STEP 1: - Get list of updates and install them ============================================== sudo apt update && sudo apt upgrade STEP 2 - install PIP and other Dependencies ============================================ sudo apt install git python3-pip build-essential wget python3-dev python3-venv python3-wheel libxslt-dev libzip-dev libldap2-dev libsasl2-dev python3-setuptools node-less libxml2-dev STEP 3 - Create System user odoo13 with home directory /opt/odoo13  =============================================== sudo useradd -m -d /opt/odoo13 -U -r -s /bin/bash odoo13 And setup password for the new user sudo pas...
Read more

Working with docker images

Installing Docker Reference from :  https://docs.docker.com/engine/install/ubuntu/ sudo apt-get remove docker docker-engine docker.io containerd runc sudo apt-get update sudo apt-get install \     apt-transport-https \     ca-certificates \     curl \     gnupg-agent \     software-properties-common Add Docker’s official GPG key: curl -fsSL https://download.docker.com/linux/ubuntu/gpg | sudo apt-key add - Verify fingerprint sudo apt-key fingerprint 0EBFCD88 Add repo sudo add-apt-repository \    "deb [arch=amd64] https://download.docker.com/linux/ubuntu \    $(lsb_release -cs) \    stable"     Update repo and Install docker engine sudo apt-get update sudo apt-get install docker-ce docker-ce-cli containerd.io Check docker is running ps ax|grep docker Test HelloWorld package sudo docker run hello-world Install docker on windows after instllation, restar tthe PC If the Linux kernel is not update...
Read more

Install Odoo13 on ubuntu

Update the system sudo apt-get update sudo apt-get upgrade Install pip3: sudo apt-get install -y python3-pip sudo apt-get install python-dev python3-dev libxml2-dev libxslt1-dev zlib1g-dev libsasl2-dev libldap2-dev build-essential libssl-dev libffi-dev libmysqlclient-dev libjpeg-dev libpq-dev libjpeg8-dev liblcms2-dev libblas-dev libatlas-base-dev  Install web dependencies sudo apt-get install -y npm sudo ln -s /usr/bin/nodejs /usr/bin/node sudo npm install -g less less-plugin-clean-css sudo apt-get install -y node-less Install wkhtmltopdf to print PDF reports sudo wget https://github.com/wkhtmltopdf/wkhtmltopdf/releases/download/0.12.5/wkhtmltox_0.12.5-1.bionic_amd64.deb sudo apt install -f sudo dpkg -i wkhtmltox_0.12.5-1.bionic_amd64.deb List of users in the system getent passwd Install PostgreSQL sudo apt-get install postgresql Login to admin postgresql user sudo su - postgres Create a new postgres user to access the database from odoo createuser --createdb --username postgres -...
Read more