Pivotal Knowledge Base


gpfdist Shows Error Message while Loading Shared libraries "libyaml-0.so.1: cannot open Shared Object File: No such file or directory"


  • Pivotal Greenplum Database (GPDB) 4.3.x
  • Operating System- Red Hat Enterprise Linux 6.x


When running gpfdist on the server only, installed with GPDB Loader in a Linux environment, it failed with errors. The error message is shown below:

error while loading shared libraries: libyaml-0.so.1: cannot open shared object file: No such file or directory


As explained in the 4.3.7.x release note shown below, the library file libyaml-0.so.1 was missed in the releases prior to


Loaders: gpload

The Greenplum Database Loaders for Red Hat Enterprise 5 and 6 did not contain the library libyaml-0.so.1.

This issue has been resolved.


The official solution would be to upgrade GPDB to first, then install the GPDB Loader for matching the release separately.

If an upgrade is not possible at the moment, then try the following workaround.

  1. If there is a GPDB cluster running in RedHat Linux environment, copy file libyaml-0.so.1 from the master host of GPDB cluster to the server installed with GPDB Loaders.
  2. If there is no GPDB cluster available, then download the GPDB server installation binary package from network.pivotal.io and upload it to the server installed with GPDB Loaders. Then install the GPDB server package on the GPDB Loaders host and copy file libyaml-0.so.1 from the GPDB server installation directory to the GPDB Loaders installation directory.

  3. Create related soft links for file libyaml-0.so.1 as illustrated below.
    [root@mdw lib]# pwd
    /usr/local/greenplum-loaders- [root@mdw lib]# cp /usr/local/greenplum-db- . [root@mdw lib]# ln -s libyaml-0.so.1.0.0 libyaml-0.so.1 [root@mdw lib]# ln -s libyaml-0.so.1.0.0 libyaml.so [root@mdw lib]# chown gpadmin:gpadmin libyaml*

    [root@mdw lib]# ls -l libyaml* lrwxrwxrwx 1 root root 18 Mar 7 20:19 libyaml-0.so.1 -> libyaml-0.so.1.0.0 -rwx------ 1 gpadmin gpadmin 319651 Mar 7 20:18 libyaml-0.so.1.0.0
    lrwxrwxrwx 1 root root 18 Mar 7 20:19 libyaml.so -> libyaml-0.so.1.0.0


Powered by Zendesk