Skip site navigation (1) Skip section navigation (2)

Re: Performance Test for PostgreSQL9

From: Melton Low <softw(dot)db(at)gmail(dot)com>
To: Selva manickaraja <mavles78(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Performance Test for PostgreSQL9
Date: 2011-02-28 06:57:38
Message-ID: AANLkTinWcZjCcvHimVYgFShm-xqKzzT3cRR8N6=H4Pnd@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
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 :-)
>>
>>
>>
>

In response to

Responses

pgsql-performance by date

Next:From: Adarsh SharmaDate: 2011-02-28 07:23:08
Subject: Is Query need to be optimized
Previous:From: Melton LowDate: 2011-02-28 06:51:40
Subject: Re: Performance Test for PostgreSQL9

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group