Configure PostgreSQLīy default, the PostgreSQL server will listen on localhost. May 19 04:39:03 ubuntu-20 systemd: Finished PostgreSQL RDBMS. May 19 04:39:03 ubuntu-20 systemd: Starting PostgreSQL RDBMS. Main PID: 137654 (code=exited, status=0/SUCCESS) Loaded: loaded (/lib/systemd/system/rvice enabled vendor preset: enabled)Īctive: active (exited) since Tue 04:39:03 CEST 25 minutes ago It will show you the status systemctl status postgresql Once installed, the service will automatically be started, you can check the status with this command: # systemctl status postgresql # apt install postgresql postgresql-client postgresql-client-common postgresql-common postgresql-contrib -y Let’s run the following command to install PostgreSQL server. When writing this tutorial, the default PostgreSQL version in the repository is PostgreSQL 12.

Then, run the following command to make sure that all installed packages on the server are updated to the latest available version.

You should get this output: Distributor ID: Ubuntu Once logged in, you can check whether you have the proper Ubuntu version installed on your server with the following command: # lsb_release -a Make sure to replace “IP_Address” and “Port_number” with your server’s actual IP address and SSH port number. Log in to your Ubuntu 20.04 VPS ssh -p Port_number SSH root access or a non-root user with sudo privileges.

Download phpmyadmin postgresql