aissam-en/install_postgresql_ubuntu_server.md

Created August 7, 2024 12:05

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/aissam-en/0c34091cc2c14fd34e0d9eb0a9a47e74.js"></script>
Save aissam-en/0c34091cc2c14fd34e0d9eb0a9a47e74 to your computer and use it in GitHub Desktop.

install postgresql ubuntu server

Raw

    install postgreSQL
sudo apt install postgresql
set password :
     sudo -u postgres psql template1
     ALTER USER postgres with encrypted password 'my_passwordy';
     \q
create a database :
     sudo -i -u postgres
     psql
     CREATE DATABASE my_db;
     \q
     exit
check the version :
    pg_lsclusters
# or :
    sudo -i -u postgres
    psql
    SELECT version();
    \q
# or : 
    dpkg -l | grep postgresql

  