Обсуждение: pg_repack issue
Hi Team,
While during the pg_repack installation getting below error please someone help
postgres@brurhen001.enterprisenet.org:/home/postgres/software/pg_repack-1.4.4
==> ll
total 16
drwx------. 3 postgres postgres 71 Oct 18 2018 bin
-rw-------. 1 postgres postgres 1662 Oct 18 2018 COPYRIGHT
drwx------. 2 postgres postgres 121 Oct 18 2018 doc
drwx------. 3 postgres postgres 139 Oct 18 2018 lib
-rw-------. 1 postgres postgres 1616 Oct 18 2018 Makefile
-rw-------. 1 postgres postgres 1285 Oct 18 2018 META.json
drwx------. 2 postgres postgres 219 Oct 18 2018 msvc
-rw-------. 1 postgres postgres 2201 Oct 18 2018 README.rst
drwx------. 4 postgres postgres 96 Oct 18 2018 regress
drwx------. 2 postgres postgres 54 Oct 18 2018 SPECS
postgres@brurhen001.enterprisenet.org:/home/postgres/software/pg_repack-1.4.4
==> make
make[1]: Entering directory `/home/postgres/software/pg_repack-1.4.4/bin'
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 -I/usr/pgsql-11/include -DREPACK_VERSION=1.4.4 -I. -I./ -I/usr/pgsql-11/include/server -I/usr/pgsql-11/include/internal -D_GNU_SOURCE -I/usr/include/libxml2 -I/usr/include -c -o pg_repack.o pg_repack.c
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 -I/usr/pgsql-11/include -DREPACK_VERSION=1.4.4 -I. -I./ -I/usr/pgsql-11/include/server -I/usr/pgsql-11/include/internal -D_GNU_SOURCE -I/usr/include/libxml2 -I/usr/include -c -o pgut/pgut.o pgut/pgut.c
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 -I/usr/pgsql-11/include -DREPACK_VERSION=1.4.4 -I. -I./ -I/usr/pgsql-11/include/server -I/usr/pgsql-11/include/internal -D_GNU_SOURCE -I/usr/include/libxml2 -I/usr/include -c -o pgut/pgut-fe.o pgut/pgut-fe.c
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
-
==> ll
total 16
drwx------. 3 postgres postgres 71 Oct 18 2018 bin
-rw-------. 1 postgres postgres 1662 Oct 18 2018 COPYRIGHT
drwx------. 2 postgres postgres 121 Oct 18 2018 doc
drwx------. 3 postgres postgres 139 Oct 18 2018 lib
-rw-------. 1 postgres postgres 1616 Oct 18 2018 Makefile
-rw-------. 1 postgres postgres 1285 Oct 18 2018 META.json
drwx------. 2 postgres postgres 219 Oct 18 2018 msvc
-rw-------. 1 postgres postgres 2201 Oct 18 2018 README.rst
drwx------. 4 postgres postgres 96 Oct 18 2018 regress
drwx------. 2 postgres postgres 54 Oct 18 2018 SPECS
postgres@brurhen001.enterprisenet.org:/home/postgres/software/pg_repack-1.4.4
==> make
make[1]: Entering directory `/home/postgres/software/pg_repack-1.4.4/bin'
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 -I/usr/pgsql-11/include -DREPACK_VERSION=1.4.4 -I. -I./ -I/usr/pgsql-11/include/server -I/usr/pgsql-11/include/internal -D_GNU_SOURCE -I/usr/include/libxml2 -I/usr/include -c -o pg_repack.o pg_repack.c
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 -I/usr/pgsql-11/include -DREPACK_VERSION=1.4.4 -I. -I./ -I/usr/pgsql-11/include/server -I/usr/pgsql-11/include/internal -D_GNU_SOURCE -I/usr/include/libxml2 -I/usr/include -c -o pgut/pgut.o pgut/pgut.c
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 -I/usr/pgsql-11/include -DREPACK_VERSION=1.4.4 -I. -I./ -I/usr/pgsql-11/include/server -I/usr/pgsql-11/include/internal -D_GNU_SOURCE -I/usr/include/libxml2 -I/usr/include -c -o pgut/pgut-fe.o pgut/pgut-fe.c
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
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
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.eisentraut@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
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.ap@nielsen.com> wrote:
Hi Peter,Thanks i have successfully created the extension how to use full vacuum using pg_repack.Regards,Prakash.ROn Wed, Jun 5, 2019 at 5:23 PM Peter Eisentraut <peter.eisentraut@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.RPostgreSQL - Offshore DBA support TCS / Nielsen Infrastructure Team On call : +91-8939599426
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@gmail.com> wrote:
Hi Prakash,You can run below command.pg_repack -d dbname -E DEBUGOn Wed, Jun 5, 2019, 7:55 PM Prakash Ramakrishnan <prakash.ramakrishnan.ap@nielsen.com> wrote:Hi Peter,Thanks i have successfully created the extension how to use full vacuum using pg_repack.Regards,Prakash.ROn Wed, Jun 5, 2019 at 5:23 PM Peter Eisentraut <peter.eisentraut@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.RPostgreSQL - 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
Hi Prakash,
You can see all the available options from here.
On Wed, Jun 5, 2019, 8:48 PM Prakash Ramakrishnan <prakash.ramakrishnan.ap@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.ROn Wed, Jun 5, 2019 at 6:16 PM Sathish Kumar <satcse88@gmail.com> wrote:Hi Prakash,You can run below command.pg_repack -d dbname -E DEBUGOn Wed, Jun 5, 2019, 7:55 PM Prakash Ramakrishnan <prakash.ramakrishnan.ap@nielsen.com> wrote:Hi Peter,Thanks i have successfully created the extension how to use full vacuum using pg_repack.Regards,Prakash.ROn Wed, Jun 5, 2019 at 5:23 PM Peter Eisentraut <peter.eisentraut@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.RPostgreSQL - Offshore DBA support TCS / Nielsen Infrastructure Team On call : +91-8939599426--Thanks,Prakash.RPostgreSQL - Offshore DBA support TCS / Nielsen Infrastructure Team On call : +91-8939599426
Hi Sathish,
Thanks i ran the pg_repack and its working fine but still the wasted bytes not removing why?
current_database | schemaname | tablename | tbloat | wastedbytes | i
name | ibloat | wastedibytes
------------------+-----------------------+--------------------------------------------------+--------+-------------+-------------------------------
----------------------------------+--------+--------------
AIBE01PR | lbmdigital_prod | digital_display_execution | 1.1 | 637059072 | digital_display_exe_idx_fk14
| 0.1 | 0
AIBE01PR | lbmdigital_prod | digital_display_execution | 1.1 | 637059072 | digital_display_exe_idx_fk22
| 0.1 | 0
AIBE01PR | lbmdigital_prod | digital_display_execution | 1.1 | 637059072 | digital_display_exe_index4
| 0.1 | 0
AIBE01PR | lbmdigital_prod | digital_display_execution | 1.1 | 637059072 | digital_display_exe_index3
| 0.2 | 0
AIBE01PR | lbmdigital_prod | digital_display_execution | 1.1 | 637059072 | digital_display_exe_index1
| 0.1 | 0
AIBE01PR | lbmdigital_prod | digital_display_execution | 1.1 | 637059072 | digital_display_execution_pkey
| 0.1 | 0
AIBE01PR | lbmdigital_prod | digital_display_execution | 1.1 | 637059072 | digital_display_exe_idx_fk9
| 0.1 | 0
AIBE01PR | cmt_prod | cmt_creative_transfer | 1.1 | 157155328 | cmt_creative_transfer_idx3
name | ibloat | wastedibytes
------------------+-----------------------+--------------------------------------------------+--------+-------------+-------------------------------
----------------------------------+--------+--------------
AIBE01PR | lbmdigital_prod | digital_display_execution | 1.1 | 637059072 | digital_display_exe_idx_fk14
| 0.1 | 0
AIBE01PR | lbmdigital_prod | digital_display_execution | 1.1 | 637059072 | digital_display_exe_idx_fk22
| 0.1 | 0
AIBE01PR | lbmdigital_prod | digital_display_execution | 1.1 | 637059072 | digital_display_exe_index4
| 0.1 | 0
AIBE01PR | lbmdigital_prod | digital_display_execution | 1.1 | 637059072 | digital_display_exe_index3
| 0.2 | 0
AIBE01PR | lbmdigital_prod | digital_display_execution | 1.1 | 637059072 | digital_display_exe_index1
| 0.1 | 0
AIBE01PR | lbmdigital_prod | digital_display_execution | 1.1 | 637059072 | digital_display_execution_pkey
| 0.1 | 0
AIBE01PR | lbmdigital_prod | digital_display_execution | 1.1 | 637059072 | digital_display_exe_idx_fk9
| 0.1 | 0
AIBE01PR | cmt_prod | cmt_creative_transfer | 1.1 | 157155328 | cmt_creative_transfer_idx3
Regards,
Praaksh.R
On Wed, Jun 5, 2019 at 6:54 PM Sathish Kumar <satcse88@gmail.com> wrote:
Hi Prakash,You can see all the available options from here.On Wed, Jun 5, 2019, 8:48 PM Prakash Ramakrishnan <prakash.ramakrishnan.ap@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.ROn Wed, Jun 5, 2019 at 6:16 PM Sathish Kumar <satcse88@gmail.com> wrote:Hi Prakash,You can run below command.pg_repack -d dbname -E DEBUGOn Wed, Jun 5, 2019, 7:55 PM Prakash Ramakrishnan <prakash.ramakrishnan.ap@nielsen.com> wrote:Hi Peter,Thanks i have successfully created the extension how to use full vacuum using pg_repack.Regards,Prakash.ROn Wed, Jun 5, 2019 at 5:23 PM Peter Eisentraut <peter.eisentraut@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.RPostgreSQL - Offshore DBA support TCS / Nielsen Infrastructure Team On call : +91-8939599426--Thanks,Prakash.RPostgreSQL - 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