Re: Gurjeet Singh Index Adviser User Interface

Goodnight,
I apologize please that today I was able to test the directory, since I had
a health problem in recent days.
Well, I actually found the files corresponding to the pg_advise_index
interface. But I was surprised that the executable is not present, but
apparently this interface must be compiled by another part of the index
adviser, to be able to execute it. It has a Makefile.
I tried to compile as follows, and I get the following errors:
root(at)debian:/home/yessica/Descargas/postgresql-8.3.23/contrib/pg_adviser_master/pg_advise#
USE_PGXS = 1 make
You need to install postgresql-server-dev-X.Y for building a server-side
extension or libpq-dev for building a client-side application.
make: *** There are no targets. High.
root(at)debian:/home/yessica/Descargas/postgresql-8.3.23/contrib/pg_adviser_master/pg_advise#
make install
make: Nothing is done for 'install'.
I will greatly appreciate a help please, regarding these errors that I got.
The truth is that I honestly don't have much experience using Linux.
Best regards,
Yessica brinkmann

<http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
Libre
de virus. www.avg.com
<http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

El mar., 29 sept. 2020 a las 18:55, Yessica Brinkmann (<
brinkmann(dot)yessica(at)gmail(dot)com>) escribió:

> Goodnight,
> Thank you very much for the answer.
> I followed all the installation instructions: apply patch, compile
> install postgres, etc.
> I just tried everything with the UI ii) Manually (through psql session),
> which is also mentioned in the readme, and everything works for me. But
> to better test my thesis, I would also need to use the other user interface
> mentioned in the readme and that is precisely i) pg_advise_index tool.
> I understand what you are telling me about the directory. I will be
> testing this way.
> Many thanks.
> Best regards,
> Yessica brinkmann
>
> El mar., 29 sept. 2020 a las 18:21, Rob Sargent (<robjsargent(at)gmail(dot)com>)
> escribió:
>
>>
>>
>> On 9/29/20 3:46 PM, Yessica Brinkmann wrote:
>> > I will greatly appreciate a help with this topic please. I really need
>> > to use that interface to be able to test my thesis. And I am not being
>> > able to use.
>> > Best regards,
>> > Yessica Brinkmann
>>
>> I didn't see any reported error messages in your post.
>>
>> And you followed all the installation instructions: apply patch, compile
>> install postgres, etc? Not for the faint of heart, to be sure.
>>
>> As presented
>>
>> pg_advise_index -d DB -h host -U user -s 10M -o advisory.sql workload.sql
>>
>> would need to be run in the directory containing advisory.sql and your
>> PATH would need to include the directory containing the
>> 'pg_advise_index' executable.
>>
>>
>>
>>
>>
>
> <http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> Libre
> de virus. www.avg.com
> <http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
> <#m_-6212125912420465024_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>