Re: How do I run PG Tuning Wizard on Linux?

Sachin Srivastava <sachin.srivastava@xxxxxxxxxxxxxxxx> · Fri, 31 Jul 2009 01:44:19 +0530

export
LD_LIBRARY_PATH=/opt/PostgreSQL/EnterpriseDB-TuningWizard/lib:$LD_LIBRARY_PATH

or 

LD_LIBRARY_PATH=/opt/PostgreSQL/EnterpriseDB-TuningWizard/lib:$LD_LIBRARY_PATH
/opt/PostgreSQL/EnterpriseDB-TuningWizard/TuningWizard

Basically you have to set the LD_LIBRARY_PATH.

This will solve the problem also you can launch the TuningWizard from
menu icons.

On 07/31/2009 12:59 AM, Jennifer Trey wrote:
Just another try on TuningWizard. 

  I tried running it from console : 

  root@Ubuntu-904-jaunty-64-minimal:/opt/PostgreSQL/EnterpriseDB-TuningWizard#
  ./TuningWizard
  ./TuningWizard: error while loading shared libraries:
libexpat.so.0: cannot open shared object file: No such file or directory

  And : 

  root@Ubuntu-904-jaunty-64-minimal:/opt/PostgreSQL/EnterpriseDB-TuningWizard#
  locate
*libexpat*

  /opt/PostgreSQL/8.4/pgAdmin3/lib/libexpat.so
  /opt/PostgreSQL/8.4/pgAdmin3/lib/libexpat.so.0
  /opt/PostgreSQL/8.4/pgAdmin3/lib/libexpat.so.0.5.0
  /opt/PostgreSQL/EnterpriseDB-TuningWizard/lib/libexpat.so
  /opt/PostgreSQL/EnterpriseDB-TuningWizard/lib/libexpat.so.0
  /opt/PostgreSQL/EnterpriseDB-TuningWizard/lib/libexpat.so.0.5.0
  /usr/lib/libexpat.so.1
  /usr/lib/libexpat.so.1.5.2
  /usr/lib/libexpatw.so.1
  /usr/lib/libexpatw.so.1.5.2
  /usr/share/doc/libexpat1
  /usr/share/doc/libexpat1/changelog.Debian.gz
  /usr/share/doc/libexpat1/changelog.gz
  /usr/share/doc/libexpat1/copyright
  /var/lib/dpkg/info/libexpat1.list
  /var/lib/dpkg/info/libexpat1.md5sums
  /var/lib/dpkg/info/libexpat1.postinst
  /var/lib/dpkg/info/libexpat1.postrm
  /var/lib/dpkg/info/libexpat1.shlibs

  Any ideas?

-- 
Regards,
Sachin Srivastava
www.enterprisedb.com