Kamis, 12 Agustus 2021

postgresql12 odoo12

 create databse postgres for odoo12

postgresql12

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

# TYPE  DATABASE        USER            ADDRESS                 METHOD

# odoo14 custom conf

local   all             odoo14                                  md5

sudo service postgresql restart

sudo su postgres

psql

CREATE USER <user> WITH ENCRYPTED PASSWORD '<password>';

ALTER USER <user> SUPERUSER;




install pgadmin4 di ubuntu

 sudo apt install curl


sudo apt install curl

# Install the public key for the repository (if not done previously):
sudo curl https://www.pgadmin.org/static/packages_pgadmin_org.pub | sudo apt-key add

# Create the repository configuration file:
sudo sh -c 'echo "deb https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/$(lsb_release -cs) pgadmin4 main" > /etc/apt/sources.list.d/pgadmin4.list && apt update'

#
# Install pgAdmin
#

# Install for both desktop and web modes:
sudo apt install pgadmin4

# Install for desktop mode only:
sudo apt install pgadmin4-desktop

# Install for web mode only: 
sudo apt install pgadmin4-web 

# Configure the webserver, if you installed pgadmin4-web:
sudo /usr/pgadmin4/bin/setup-web.sh

install postgresql 12 ubuntu 18.04

wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
 
echo "deb http://apt.postgresql.org/pub/repos/apt/ `lsb_release -cs`-pgdg main" |sudo tee  /etc/apt/sources.list.d/pgdg.list
  
sudo apt update
 
sudo apt -y install postgresql-12 postgresql-client-12

flutter firebase notification