Problems executing make USE_PGXS=1 on Ubuntu 14.04

[janisroze]

Following guide for Postgresql9.3 on ubuntu I am getting an error executing

make USE_PGXS=1

The output is:

gcc -g -O2 -fstack-protector --param=ssp-buffer-size=4 -Wformat -Werror=format-security -I/usr/include/mit-krb5 -fPIC -pie -DLINUX_OOM_SCORE_ADJ=0 -fno-omit-frame-pointer -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -g -fpic -I. -I./ -I/usr/include/postgresql/9.3/server -I/usr/include/postgresql/internal -D_FORTIFY_SOURCE=2 -D_GNU_SOURCE -I/usr/include/libxml2  -I/usr/include/tcl8.6  -c -o src/tds_fdw.o src/tds_fdw.c
src/tds_fdw.c:52:22: fatal error: sybfront.h: No such file or directory
 #include <sybfront.h>
                      ^
compilation terminated.
make: *** [src/tds_fdw.o] Error 1

How can i fix this? What is wrong here?

[shulcsm]

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

[GeoffMontee]

Thanks, shulcsm!

The command provided above should install the TDS-related dependencies, including the sybfront.h header.

gmontee@gmontee-VirtualBox:~$ sudo dpkg --listfiles freetds-dev
/.
/usr
/usr/lib
/usr/lib/x86_64-linux-gnu
/usr/lib/x86_64-linux-gnu/libsybdb.a
/usr/lib/x86_64-linux-gnu/libct.a
/usr/include
/usr/include/ctpublic.h
/usr/include/sybfront.h
/usr/include/cspublic.h
/usr/include/syberror.h
/usr/include/sybdb.h
/usr/include/sqldb.h
/usr/include/bkpublic.h
/usr/include/sqlfront.h
/usr/include/cstypes.h
/usr/include/odbcss.h
/usr/include/tds_sysdep_public.h
/usr/share
/usr/share/doc
/usr/share/doc/freetds-dev
/usr/share/doc/freetds-dev/copyright
/usr/lib/x86_64-linux-gnu/libsybdb.so
/usr/lib/x86_64-linux-gnu/libct.so
/usr/share/doc/freetds-dev/changelog.Debian.gz

[janisroze]

Thank You for the help