Re: pg_repack issue

Hi Prakash,

You can see all the available options from here.

http://reorg.github.io/pg_repack/#installation

On Wed, Jun 5, 2019, 8:48 PM Prakash Ramakrishnan <
prakash(dot)ramakrishnan(dot)ap(at)nielsen(dot)com> wrote:

> Hi Sathish,
>
> Thanks for quick response and the database using separate table-space and
> we need to clear table and index bloat values and using jobs also how can i
> achieve this need exact command ?
>
> Regards,
> Prakash.R
>
> On Wed, Jun 5, 2019 at 6:16 PM Sathish Kumar <satcse88(at)gmail(dot)com> wrote:
>
>> Hi Prakash,
>>
>> You can run below command.
>>
>> pg_repack -d dbname -E DEBUG
>>
>>
>> On Wed, Jun 5, 2019, 7:55 PM Prakash Ramakrishnan <
>> prakash(dot)ramakrishnan(dot)ap(at)nielsen(dot)com> wrote:
>>
>>> Hi Peter,
>>>
>>> Thanks i have successfully created the extension how to use full vacuum
>>> using pg_repack.
>>>
>>> Regards,
>>> Prakash.R
>>>
>>> On Wed, Jun 5, 2019 at 5:23 PM Peter Eisentraut <
>>> peter(dot)eisentraut(at)2ndquadrant(dot)com> wrote:
>>>
>>>> On 2019-06-05 12:48, Prakash Ramakrishnan wrote:
>>>> > gcc -Wall -Wmissing-prototypes -Wpointer-arith
>>>> > -Wdeclaration-after-statement -Wendif-labels
>>>> -Wmissing-format-attribute
>>>> > -Wformat-security -fno-strict-aliasing -fwrapv
>>>> > -fexcess-precision=standard -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2
>>>> > -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4
>>>> > -grecord-gcc-switches -m64 -mtune=generic pg_repack.o pgut/pgut.o
>>>> > pgut/pgut-fe.o -L/usr/pgsql-11/lib -Wl,--as-needed
>>>> > -L/usr/lib64/llvm5.0/lib -L/usr/lib64 -Wl,--as-needed
>>>> > -Wl,-rpath,'/usr/pgsql-11/lib',--enable-new-dtags -L/usr/pgsql-11/lib
>>>> > -lpq -L/usr/pgsql-11/lib -lpgcommon -lpgport -lpthread -lssl -lcrypto
>>>> > -lz -lreadline -lrt -lcrypt -ldl -lm -o pg_repack
>>>> > */usr/bin/ld: cannot find -lreadline
>>>> > collect2: error: ld returned 1 exit status
>>>> > make[1]: *** [pg_repack] Error 1
>>>> > make[1]: Leaving directory
>>>> `/home/postgres/software/pg_repack-1.4.4/bin'
>>>> > make: *** [all] Error 2*
>>>>
>>>> It's a bit bogus that pg_repack would require this, but perhaps
>>>> installing the readline-devel (or similar) package would get you past
>>>> this.
>>>>
>>>> --
>>>> Peter Eisentraut http://www.2ndQuadrant.com/
>>>> PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
>>>>
>>>
>>>
>>> --
>>> Thanks,
>>> Prakash.R
>>> PostgreSQL - Offshore DBA support TCS / Nielsen Infrastructure Team On
>>> call : +91-8939599426
>>>
>>
>
> --
> Thanks,
> Prakash.R
> PostgreSQL - Offshore DBA support TCS / Nielsen Infrastructure Team On
> call : +91-8939599426
>