There will be no output but if you check the status of the service there will be minor changes from the previous output. Main PID: 793 (code=exited, status=0/SUCCESS)Īug 08 12:59:50 vps systemd: Starting PostgreSQL RDBMS.Īug 08 12:59:50 vps systemd: Finished PostgreSQL RDBMS. Process: 793 ExecStart=/bin/true (code=exited, status=0/SUCCESS) Loaded: loaded (/lib/systemd/system/rvice enabled vendor preset: enabled)Īctive: active (exited) since Sun 12:59:50 UTC 1min 5s ago The output should be similar to the output below: #sudo service postgresql status To check the status of the PostgreSQL service: sudo service postgresql status Here are some basic commands on how to manage the PostgreSQL services like status, starting, stopping, and restarting. Manage PostgreSQL 9.6 service on Ubuntu 20.04 Once everything is installed and prepared we can go to the next step, and that step is how to manage the PostgreSQL service. If you want to check and verify that the correct version is installed, please execute: sudo psql -version We can see that the Postgres service is running on port 5432 successfully. The output should be: sudo netstat -tunlp | grep 5432 To check this you can execute the command below: sudo netstat -tunlp | grep 5432 Check and verify the Installationįirst of all, you need to know that PostgreSQL is working on port 5432. The command above will completely install the PostgreSQL database server and other required database modules and tools. Now the GPG key and the repo are added and we are ready to install PostgreSQL 9.6 on our Ubuntu 20.04 sudo apt-get install postgresql-9.6 Once the repository is added update the system. echo 'deb $(lsb_release -cs)-pgdg main' | sudo tee /etc/apt//postgresql-pgdg.list > /dev/null Add PostgreSQL 9.6 repositoryīy default, Ubuntu 20.04 does not have the PostgreSQL repo and we need to add it manually so we can install it later. The signing GPG key can be added with the following command: wget -quiet -O - | sudo apt-key add - Step 3. sudo apt-get update -y & sudo apt-get upgrade -yĪfter executing the command it will take some time for the system to get the latest information.

Since this is a fresh install of Ubuntu 20.04 we need to update the system to its latest version and be sure the software is up to date. User privileges: root or non-root user with sudo privileges.Configuration of PostgreSQL 9.6 and console

Postgresql 9.6 download