How to install pg_bulkload to Ubuntu 16.04 about pg_bulkload HOT 7 CLOSED

Its not hard to install but you need to get the dependencies and sometimes symlink things that aren't where make expects them, here's my latest install on Ubuntu Xenial as a shell script.
#!/bin/bash

PG_TARGET=$1
apt-get install "postgresql-server-dev-$PG_TARGET"
apt-get install "build-essential" "git" "libpam0g-dev"
apt-get install "libedit-dev" "libselinux1-dev" "openssl" "libssl-dev"

ln -s "/usr/lib/x86_64-linux-gnu/libgssapi_krb5.so.2" "/usr/lib/x86_64-linux-gnu/libgssapi_krb5.so"

git clone "https://github.com/ossc-db/pg_bulkload.git" /opt/pg_bulkload

cd /opt/pg_bulkload
make clean
make
make install

ln -s /opt/pg_bulkload/bin/pg_bulkload /usr/local/sbin/pg_bulkload
sudo -u postgres psql postgres < /opt/pg_bulkload/lib/pg_bulkload.sql

from pg_bulkload.

Currently it is the only way to build from source in Ubuntu.

from pg_bulkload.

Hi!
It seems to me that you should ask pgapt (PostgreSQL Debian and Ubuntu Repository Team).
https://redmine.postgresql.org/projects/pgapt/issues

from pg_bulkload.

Hi @brainbuz, I get the following errors during the make:

/usr/bin/ld: cannot find -lpgcommon
/usr/bin/ld: cannot find -lpgport

I have peformed the installation of the pg development packages using: sudo apt-get install postgresql-server-dev-10

Any additional tips?

Thanks
Emil

from pg_bulkload.

egalot I haven't needed to build with either pg 10 or with bionic yet .
/usr/bin/ld is gnu linker so you are either missing a dependency or need to help the linker find it with a symlink. I would guess that since you installed the dev package you need to figure out the missing symlink(s).

from pg_bulkload.

from pg_bulkload.

Well I was too quick to call victory on this one, although the application compiled, additional steps did not execute properly and thus the application fails to properly register itself as a postgres module. I am still hoping to find a solution.

from pg_bulkload.