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

On 07/29/2009 09:46 PM, Jennifer Trey wrote:
> Is this it?
>
> http://pgfoundry.org/projects/pgtune
>
> I thought it was EnterpriseDB. Perhaps that's only for windows?
>
> Thanks / Jen
You can have TuningWizard (EnterpriseDB's) for linux also available
through StackBuilder.

--
Regards,
Sachin Srivastava
www.enterprisedb.com

On 07/30/2009 03:19 PM, Moe wrote:
> Hi Sachin,
>
> I am sorry but I am not that familiar with Linux. So you have excuse me.
>
> I can't figure out how to do this. I looked for it in the package
> manager and googled it but no luck.
> What commands should I run to install and run it?
>
> Thanks in advance / Jennifer
If you have installed the PostgreSQL 8.4 from EnterpriseDB's One-Click
installer (for linux). You will find an entry in your Applications menu.

Applications --> PostgreSQL 8.4 --> Application Stack Builder.

Click on the menu entry to start the stackbuilder. There you will see a
bunch of applications you can choose to install. TuningWizard is one of
them.

--
Regards,
Sachin Srivastava
www.enterprisedb.com

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

Unfortunately I used the apt-get utility. So I might have missed out on those packages. 

But I un-installed (I hope I got everything) and deleted some folders, got the one click installer and re-installed. I got everything now and  set up postgre and it is working fine. However (something I ran into), running pg_config --sharedir gives a folder that doesn't exist anymore( from previous installation I would think (i might have deleted that folder))

Running the TuningWizard seems to not be working though. After I select "mixed", it says: "Initializing Webservice" and then it disappears and nothing ever happens... Looking at the postgresql.conf file , it seems not have been touched...

Just a thought, do I need the Apache Server thingy that one can select on the StackBuilder?

I am running on Ubuntu Server 9.04 

Thanks / Jen

-- 
Regards,
Sachin Srivastava
www.enterprisedb.com

Thank you for your answer.

I did export the LD_LIBRARY_PATH and now the complain is something else.. progress :)

Error: Unable to initialize gtk, is DISPLAY set properly?

I have also launched the TuningWizard from an icon and I got to the step (development, mixed, dedicated) as before and then the same message (connecting to webserver) and then it disappears.

Thanks / Jen