

To stop the service, run the command below: $ sudo systemctl stop rvice If you want to stop this service, issue the command below: $ sudo systemctl stop rvice To start your PostgreSQL service, execute the command below: $ sudo systemctl start rvice This will give you an output similar to the one below: psql (PostgreSQL) 9.6.10 PostgreSQL 9.6.10onx86_64-pc-linux-gnu, compiledbygcc (Debian 6.3.0-18+deb9u1) 6.3.0 20170516, 64-bitĪlternatively, you can issue the command below to check the version of PostgreSQL you have installed: $ sudo psql -version This will use the psql utility to connect to a PostgreSQL server and deliver the output below showing the database server version. To check if the service was installed correctly, execute the command below: $ sudo -u postgres psql -c "SELECTversion() " The PostgreSQL application will start automatically once the two packages are installed. $ sudo apt install postgresql postgresql-contrib These packages provide extra features for your PostgreSQL database. Next, run the command below to install PostgreSQL contrib and PostgreSQL server. First, log in to your Debian 9 server and issue the following command to update the local package index: $ sudo apt update
