PostgreSQL Connection Help

RazorSQL ships with the JDBC drivers necessary to connect to PostgreSQL databases. There is also an ODBC driver available for PostgreSQL, and if using Windows, users can connect to PostgreSQL with RazorSQL using ODBC assuming an ODBC datasource has been configured for PostgreSQL in the ODBC control panel. However, it is recommended that users use the PostgreSQL JDBC driver that ships with RazorSQL.

Connecting to PostgreSQL via JDBC

To connect to a PostgreSQL database, select the JDBC (PostgreSQL Native Driver) connection type from the connection type list. Enter any login information if applicable, and then enter the host or ip address of the PostgreSQL server, and the port the PostgreSQL server is listening on. The default port is 5432. Next, enter the name of the PostgreSQL database to connect to.

Connecting to PostgreSQL via ODBC

To connect to PostgreSQL via ODBC, the PostgreSQL ODBC driver must be downloaded and installed. Next, an ODBC data source must be set up via the Windows data sources control panel. See the following link for more information:

ODBC Setup

See the following link for more information on obtaining the ODBC driver for PostgreSQL:

http://www.postgresql.org/ftp/odbc/versions/

Manual PostgreSQL JDBC Information

If manually configuring your connection, see the following for JDBC driver class and JDBC URL format. JDBC Information