About Postgres driver download
This is a post on how to create a Linked Server to a PostgreSQL database. In my previous post, I created a Linked Server to another SQL Server instance. This time, it’s a link to a Postgres database. I recommend checking out my other post for pre-requisite information including testing connectivity to the remote database server. Follow these steps to create a Linked Server to a Postgres server: 1. Create Linked Server Login on Postgres.2. Install the Postgres ODBC Driver.3. Configure ODBC Data Source Settings.4. Create Linked Server to a Postgres Database.1. Create Linked Server Login on PostgresWe first need to create a login for the Linked Server on Postgres: For this example I’m making the user in Postgres a Superuser. This is not ideal, we should be configuring it with the least permissions it requires. This is just a demo though. For demo purposes, I’m also showing how this would be done using a terminal: 2. Install Postgres ODBC DriverThe ODBC driver must be installed on both ends. This step is a reminder to ensure you have this installed. You can use Stack Builder to install it, or download the Postgres ODBC driver package on its own: We need to install this: Accept License stuff.Specify directory & we don’t need the documentation.It’s a straight-forward install: 3. Configure ODBC Data Source SettingsOn our SQL Server, we need to configure the ODBC driver for the Postgres database. To do this, open ODBC Data Sources as Administrator: Click the System DSN tab and click Add.Select the PostgreSQL Unicode driver: Enter all details required, In this example I created a ‘sales’ database which I’m connecting to: Finally, we should test the connection to verify all is good: 4. Create Linked Server to a Postgres DatabaseTo create a Linked Server to Postgres: 1. Expand
Key features of the Postgres driver download that are enabled through these drivers include:
- OpenLink Lite ODBC Drivers for Postgres for Mac - CNET Download
- Prompted to download Postgres driver every time start DBeaver
- postgresql - Using ODBC drivers to connect to Postgres
- postgresql - Postgres ODBC driver versions - Database
- Thread: ODBC Driver for PostgreSQL : Postgres Professional
- Postgres Odbc Driver Install Windows - Restackio
- Asynchronous connection to postgres using ODBC driver
If the zip file for installing Java should be removed. Press y to clean up and close the script.8. Download the PostgreSQL JDBC plugin manually. Navigate to the PostgreSQL JDBC driver download page and download the latest version.Place the driver in a secure location. No installation is required, but SQL Workbench/J will not work without it.9. Start the SQL Workbench. Navigate to the folder with the executable files and run the SQLWorkbench or SQLWorkbench64 application, depending on your system build.10. Create a connection profile. Give the profile a name and choose the PostgreSQL driver from the dropdown (provide the path if prompted). Fill in the connection details (server URL, username, and password).The URL is in the following format:jdbc:postgresql://[server_IP]:[port_number]/Connection details are visible in Postgres with the /conn meta-command. Install SQL Workbench for Postgres on MacTo install SQL Workbench for Postgres on Mac, do the following:1. Open the terminal and use the following curl command to download SQL Workbench:curl -O command downloads the package from the official SQL Workbench website.2. Unzip the downloaded package to a specific directory. For example:unzip Workbench-Build131-with-optional-libs.zip -d ~/Desktop/WorkbenchThe package is in ~/Desktop/Workbench.Note: If the unzip command is unavailable, install it with: brew install unzip.3. Navigate to the directory and list its contents:cd ~/Desktop/Workbench && ls -lThe directory contains files that will be used in the following steps to complete the installation and start the program (download_jre.sh and sqlworkbench.jar).4. Run the following shell script to download the latest available JRE version:sudo ./download_jre.shSQL Workbench requires JRE to work.5. Create a directory to store the PostgresJDBC driver:mkdir -p ~/Desktop/PostgresJDBCThe driver is required to connect the SQL Workbench to the PostgreSQL server.6. Download the latest driver with:curl -o ~/Desktop/PostgresJDBC/postgresql-42.7.4.jar command downloads the driver and saves it in the directory created in the previous step.7. Start the SQL Workbench:java -jar ~/Desktop/Workbench/sqlworkbench.jarThe command opens the program to create a connection profile.8. Create the connection profile. Give the connection a name and provide the database connection details. Select the PostgreSQL driver (browse for the file if prompted), and fill out the database connection details (URL, username, and password).Use the following URL format:jdbc:postgresql://[server_IP]:[port_number]/The /conn meta-command in PostgreSQL shows the connection details required for the URL.ConclusionThis guide showed how to install and set up SQL Workbench/J for PostgreSQL. The process requires installing SQL Workbench and adding the appropriate PostgreSQL driver to connect.Next, learn more about PostgreSQL data types or create a database in Postgres.Was this article
