Re: Performance Test for PostgreSQL9

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(dot)db(at)gmail(dot)com> 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(at)gmail(dot)com>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(dot)kirkwood(at)catalyst(dot)net(dot)nz> 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 :-)
>>>
>>>
>>>
>>
>