Warning: is_dir(): open_basedir restriction in effect. File(/tmp) is not within the allowed path(s): (/data/web/virtuals/98151/virtual) in /data/web/virtuals/98151/virtual/www/subdom/postgresql/wp-content/plugins/wp-simple-firewall/src/lib/vendor/fernleafsystems/wordpress-services/src/Core/Fs.php on line 465

Warning: Cannot modify header information - headers already sent by (output started at /data/web/virtuals/98151/virtual/www/subdom/postgresql/wp-content/plugins/wp-simple-firewall/src/lib/vendor/fernleafsystems/wordpress-services/src/Core/Fs.php:465) in /data/web/virtuals/98151/virtual/www/subdom/postgresql/wp-content/plugins/disable-xml-rpc-pingback/disable-xml-rpc-pingback.php on line 51
Build latest pgloader from sources (Debian 9) - PostgreSQL Candies

Lately I had to replace installed pgloader with latest version build directly from sources. OS I did it on is Debian 9.
I found it is not exactly simple so here are my notes about it. You will need to install development tools and latest “sbcl” from sources too.

  • ssh instance / server
  • start “tmux” or similar sw
  • update installed sw
    • sudo apt-get update
    • sudo apt-get upgrade
  • install dev tools:
    • sudo apt-get install sbcl unzip libsqlite3-dev make curl gawk freetds-dev libzip-dev gcc cmake make -y
  • clone latest sbcl and build latest sbcl from sources
    • rm -rf ~/sbcl
    • cd ~
    • git clone https://github.com/sbcl/sbcl.git
    • cd sbcl
    • sudo su
    • ./make.sh --fancy
    • ./install.sh
    • sbcl --version
    • exit
  • build latest pgloader
    • rm -rf ~/pgloader
    • cd ~
    • git clone https://github.com/dimitri/pgloader.git
    • cd pgloader
    • sudo su
    • make pgloader
    • exit
    • cd /home/upcload/pgloader/build/bin
    • ./pgloader --version