How do I connect to PostgreSQL Database?

View some of the Frequently Asked Questions to our support staff. Included are some tips and tricks making this forum ideal for users getting started with GoAnywhere Director. Note: Users can reply to existing topics but only our support staff can add new topics to this forum.

How do I connect to PostgreSQL Database?

Postby Support_Sai » Thu Aug 13, 2009 11:34 am

Follow the instructions below to connect to a PostgreSQL database from GoAnywhere Director:

  • Download the JDBC driver for PostgreSQL database from http://jdbc.postgresql.org. Make sure to download a driver that is compatible with the version of your database server. Also, make sure to download a JDBC 3.0 compliant driver. DO NOT download JDBC 4.0 driver.
  • Copy the downloaded driver jar file to the system where GoAnywhere Director is installed. The location to copy is [INSTALL_DIR]/WebRoot/WEB-INF/lib. Where [INSTALL_DIR] is the directory where GoAnywhere Director is installed.
  • Restart GoAnywhere Director subsystem/service for the new driver to be recognized
  • Create a new Database Resource with your PostgreSQL database server information -
    • For the JDBC Driver, type org.postgresql.Driver.
    • For the JDBC URL, type jdbc:postgresql://[host]:[port]/[database], where [host] is the host name or IP address of the system where the database is installed, [port] is the port number on which the database server is listening and [database] is the name of the database you would like to connect to. The default port number is 5432.
    • Specify the user name and password for logging into the database and click Test to test the connection.
  • Save the resource and create a project using this resource to access data from the PostgreSQL database.
Support_Sai
 

Return to Knowledge Center

Who is online

Users browsing this forum: No registered users and 1 guest