linux

Debian 11 Linux Installation

|

Oracle Enterprise Linux, Centos Scientific Linux editions are based on Redhat. The RPMpackages, commands etc. they use are commands mostly similar.Ubuntu and Mint are Debian-based Linux systems. Commands etc. are mostly similar. You can use any virtualization platform (VirtualBox, VMware workstation/ESX, Proxmoxetc.) for installation. The manual will use VirtualBox (you can download and install it … Debian 11 Linux Installation

Crontab

|

Since Postgresql does not have an embedded scheduler, this need is solved with pg_cron and pgagent extensions or with crontab at the operating system level. SQL to be executed, function procedure etc. The codes can be written in Linux bashscript and scheduled with crontab, the embedded scheduler of the Linux operatingsystem. Example Script vim /var/lib/postgresql/scripts/instest.sh … Crontab