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.ramakrishnan...@nielsen.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 <satcs...@gmail.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.ramakrishnan...@nielsen.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.eisentr...@2ndquadrant.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 >
