Versions Compared

Old Version 2

changes.mady.by.user Former user

Saved on

compared with

New Version Current

changes.mady.by.user Amber Williams

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Datical uses the following Postgres Command Line Utilities:

  • psql

  • pg_dump

  • pg_restore

To set them up:

...

Ensure that the desired version of the above are installed on the Datical DB host.

...

Ensure that the installation directories are in the PATH

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:

      Code Block
      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.

      Image Added

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