Installing PostgreSQL Clients

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 11 and works with Postgres Community, Amazon RDS, & Amazon Aurora databases.

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.
    
    

    Open

    

     

• 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.