Branch: master
Find file Copy path
71 lines (49 sloc) 1.83 KB

TDS Foreign data wrapper

  • Author: Geoff Montee
  • Name: tds_fdw
  • File: tds_fdw/

Installing on Ubuntu

This document will show how to install tds_fdw on Ubuntu 14.04. Other Ubuntu distributions should be similar.

Install FreeTDS

The TDS foreign data wrapper requires a library that implements the DB-Library interface, such as FreeTDS.

sudo apt-get install libsybdb5 freetds-dev freetds-common

Install PostgreSQL

If you need to install PostgreSQL, do so by following the apt installation directions. For example, to install PostgreSQL 9.5 on Ubuntu:

sudo bash -c "echo \"deb $(lsb_release -c -s)-pgdg main\" > /etc/apt/sources.list.d/pgdg.list"
wget --quiet -O - | sudo apt-key add -
sudo apt-get update
sudo apt-get upgrade
sudo apt-get install postgresql-9.5 postgresql-client-9.5 postgresql-server-dev-9.5

Install tds_fdw

Build from release package

If you'd like to use one of the release packages, you can download and install them via something like the following:

tar -xvzf v1.0.7.tar.gz
cd tds_fdw-1.0.7
make USE_PGXS=1
sudo make USE_PGXS=1 install

Build from repository

If you would rather use the current development version, you can clone and build the git repository via something like the following:

git clone
cd tds_fdw
make USE_PGXS=1
sudo make USE_PGXS=1 install

Start server

If this is a fresh installation, then start the server:

sudo /etc/init.d/postgresql start

Install extension

psql -U postgres
postgres=# CREATE EXTENSION tds_fdw;