Datical uses the following Postgres Command Line Utilities:
psql
pg_dump
pg_restore
The latest version of the Postgres Command Line Utilities is backwards compatible to Postgres 9.6 and works with Postgres Community, Amazon RDS, & Amazon Aurora databases. If using Postgres 9.5 or earlier, ensure your version of Postgres Command Line Utilities matches that of the database
Install the Client Packages
Browse to the PostgreSQL downloads page.
Select the Operating System Type.
For Linux platforms, select the PostgreSQL version and OS platform. Then run the yum commands displayed on the page to install the client packages. Example:
As root: yum install https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm yum install postgresql11
For Windows platforms, download the installer and install the command line tools and pgadmin4.
Add the location of the PostgreSQL binaries to the $PATH of the Linux/Windows automation account.
For Linux systems the binaries are typically located in /bin.