PostgreSQL Connection

PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows. It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It includes most SQL:2008 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP. It also supports storage of binary large objects, including pictures, sounds, or video.

In order to create a PostgreSQL connection, the following steps should be followed:

  • In the Name Text Box type in a new name for the connection you are about to create
  • Type in the host name
  • Select a Database name from the drop down List
  • Select appropriate connection port default is 5432
  • Fill in Username/Password for the database you wish to connect to
  • Click Test Connection to ensure the details you have provided are correct
  • Click OK to close the connection properties window

Working with Greenplum

For more technologies supported by our ETL Software see Advanced ETL Processor Versions and Visual Importer ETL Versions

Confused? Ask question on our ETL Forum

  • vimpe/connections/database/postgresql.txt
  • Last modified: 17/09/2018 10:33
  • by admin