How To Install postgresql-10-cron on Ubuntu 18.04
Introduction
In this tutorial we learn how to install postgresql-10-cron on Ubuntu 18.04.
What is postgresql-10-cron
postgresql-10-cron is:
pg_cron is a simple cron-based job scheduler for PostgreSQL (9.5 or higher) that runs inside the database as an extension. It uses the same syntax as regular cron, but it allows you to schedule PostgreSQL commands directly from the database. pg_cron can run multiple jobs in parallel, but it runs at most one instance of a job at a time. If a second run is supposed to start before the first one finishes, then the second run is queued and started as soon as the first run completes.
There are three methods to install postgresql-10-cron on Ubuntu 18.04. We can use apt-get, apt and aptitude. In the following sections we will describe each method. You can choose one of them.
Install postgresql-10-cron Using apt-get
Update apt database with apt-get using the following command.
sudo apt-get update
After updating apt database, We can install postgresql-10-cron using apt-get by running the following command:
sudo apt-get -y install postgresql-10-cron
Install postgresql-10-cron Using apt
Update apt database with apt using the following command.
sudo apt update
After updating apt database, We can install postgresql-10-cron using apt by running the following command:
sudo apt -y install postgresql-10-cron
Install postgresql-10-cron Using aptitude
If you want to follow this method, you might need to install aptitude first since aptitude is usually not installed by default on Ubuntu. Update apt database with aptitude using the following command.
sudo aptitude update
After updating apt database, We can install postgresql-10-cron using aptitude by running the following command:
sudo aptitude -y install postgresql-10-cron
How To Uninstall postgresql-10-cron on Ubuntu 18.04
To uninstall only the postgresql-10-cron package we can use the following command:
sudo apt-get remove postgresql-10-cron
Uninstall postgresql-10-cron And Its Dependencies
To uninstall postgresql-10-cron and its dependencies that are no longer needed by Ubuntu 18.04, we can use the command below:
sudo apt-get -y autoremove postgresql-10-cron
Remove postgresql-10-cron Configurations and Data
To remove postgresql-10-cron configuration and data from Ubuntu 18.04 we can use the following command:
sudo apt-get -y purge postgresql-10-cron
Remove postgresql-10-cron configuration, data, and all of its dependencies
We can use the following command to remove postgresql-10-cron configurations, data and all of its dependencies, we can use the following command:
sudo apt-get -y autoremove --purge postgresql-10-cron
References
Summary
In this tutorial we learn how to install postgresql-10-cron package on Ubuntu 18.04 using different package management tools: apt, apt-get and aptitude.
