Jumat, 10 September 2021

openldap and pgadmin authentication in Ubuntu

 install postgresql:

  • sudo apt update
  • sudo apt -y install vim bash-completion wget
  • 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
  • systemctl status postgresql.service
  • systemctl status postgresql@12-main.service
  • sudo su - postgres
  • psql -c "alter user postgres with password 'StrongAdminP@ssw0rd'"
  • psql

source: https://computingforgeeks.com/install-postgresql-12-on-ubuntu/