How do I run PG Tuning Wizard on Linux?

Is this it?
http://pgfoundry.org/projects/pgtune

I thought it was EnterpriseDB. Perhaps that's only for windows?

Thanks / Jen

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

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

i am using a friends account btw...

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

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

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?

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

On 07/30/2009 07:31 PM, Jennifer Trey wrote:

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...

Possibly a crash. Please try running TuningWizard from command line and
see if you get any error messages.

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

No not for running TuningWizard atleast.

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

Hi Jennifer,

Some times, gtk does not work as expected.
Please try to run TuningWizard using the following command:
DISPLAY=:0.0
LD_LIBRARY_PATH=/opt/PostgreSQL/EnterpriseDB-TuningWizard/lib
/opt/PostgreSQL/EnterpriseDB-TuningWizard/TuningWizard.

Hope - this will help you.
BTW: TuningWizard is updated to work with PostgreSQL 8.4 version.

Jennifer Trey wrote:

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

--
Thanks & Regards,
Ashesh Vashi

EnterpriseDB INDIA: http://www.enterprisedb.com