Re: Performance Test for PostgreSQL9

[Selva manickaraja <mavles78@xxxxxxxxx>]

OK, somehow I got these modules installed. Finally I successfully built and installed PostgreSQL! I must thank you guys so much for helping.

Now coming to the real issue of the matter. According to the documentation the "gmake installcheck" can be run in various directories. However it seem to be only local. Can these tests be run from local but to stress test a database on a remote machine. This way I don't need to go on building postgresql from source in every new db server. I will wait for your reply.

Thank you.

Regards,

Selvam

On Mon, Feb 28, 2011 at 2:57 PM, Melton Low <softw.db@xxxxxxxxx> wrote:

Resending.  Hit the send button too soon.

Use apt-get to install

sudo apt-get install libreadline-dev

sudo apt-get install  zlib1g-dev

and other dependencies mentioned in the source distribution INSTALL file.

ln -s /usr/bin/make /usr/bin/gmake

This will give you gmake which would already be installed in Ubuntu as make but allow it to be invoke as gmake.

Then follow the configure, make and install steps previously posted.

You can also get the ppa package from 

http://www.openscg.org/

Cheers, 

Mel

On Sun, Feb 27, 2011 at 11:39 PM, Selva manickaraja <mavles78@xxxxxxxxx> wrote:

Yes, true now it looks like pg-general. I started out this discussion because I couldn't get Performance Testing done. But looks like the performance cannot be done due to the tool cannot be built...:) and all evils are getting unleashed from this..

OK, I did exactly to move to the top of the directory and run the ./configure first. Everything work until the last time it reports error now....

-----------------------------------------------------------------------------------------------
checking for -lreadline... no
checking for -ledit... no
configure: error: readline library not found
If you have readline already installed, see config.log for details on the
failure.  It is possible the compiler isn't looking in the proper directory.
Use --without-readline to disable readline support.
-----------------------------------------------------------------------------------------------

I tried man readline and man edit, there seem to manuals on it. I checked the Synaptic Manager. There seem to be a package called readline-common. I then search the net for some assistance. Looks like there was another guy who had a similar problem like me. The URL is http://ubuntuforums.org/showthread.php?t=1638949

So I tried installing 'readline' using

->sudo apt-cache search readline
AND
->sudo apt-get install libreadline6 libreadline6-dev

Upon answering 'y' to install without verification, I get Bad Gateway error.

Install these packages without verification [y/N]? y
Err http://my.archive.ubuntu.com/ubuntu/ maverick/main libncurses5-dev i386 5.7+20100626-0ubuntu1
  502  Bad Gateway
Err http://my.archive.ubuntu.com/ubuntu/ maverick/main libreadline6-dev i386 6.1-3
  502  Bad Gateway
Failed to fetch http://my.archive.ubuntu.com/ubuntu/pool/main/n/ncurses/libncurses5-dev_5.7+20100626-0ubuntu1_i386.deb  502  Bad Gateway
Failed to fetch http://my.archive.ubuntu.com/ubuntu/pool/main/r/readline6/libreadline6-dev_6.1-3_i386.deb  502  Bad Gateway
E: Unable to fetch some archives, maybe run apt-get update or try with --fix-missing?

Looks like I'm stuck at this level. Please assist to breakaway....

Thank you.

Regards,

Selvam

On Mon, Feb 28, 2011 at 1:53 PM, Mark Kirkwood <mark.kirkwood@xxxxxxxxxxxxxxx> wrote:

On 28/02/11 18:09, Selva manickaraja wrote:

As mentioned in the documentation, I went to the directory src/test/regress and ran the command. It gives the error

GNUmakefile:15: ../../../src/Makefile.global: No such file or directory
GNUmakefile:80: /src/Makefile.shlib: No such file or directory
make: *** No rule to make target `/src/Makefile.shlib'.  Stop.

Really can't make any sense out of this.

Any ideas?

You have not run configure to generate these make files (or you have run 'make distclean' to destroy them).

generally you need to do:

$ ./configure --prefix=your-chosen-install-prefix-here
$ make
$ make install
$ make check

The last step runs the regression test.

regards

Mark

P.s: this discussion really belongs on pg-general rather than performance, as it is about building and installing postgres rather than performance, *when* you have it installed ok, then performance based discussion here is fine :-)