Probleme install pg_squezze in step make about pg_squeeze

[ahouska]

pg_squeeze requires postgres version 10 or higher.

If you wan to use the old branch for PG 9.6 (not recommended), you need to make sure that the pg_config is also from PG 9.6.

[mrhassan60]

I still have the same concerns with postgresql 11

[ahouska]

It seems you're still trying to use pg_squeeze 1.0. Please try 1.3.1: https://github.com/cybertec-postgresql/pg_squeeze/releases/tag/REL1_3_1

[mrhassan60]

Always the same problem,
here are the commands i write on linux Ubuntu 18.04 with pg_squezze :

apt update
apt upgrade
wget https://github.com/cybertec-postgresql/pg_squeeze/archive/REL1_3_1.tar.gz
tar -zxvf REL1_3_1.tar.gz
cd pg_squeeze-REL1_3_1/
nano Makefile

#ADD in file Makefile :

PGCONFIG=/usr/bin/pg_config

service postgresql restart
make
the errors is :

gcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -Wno-format-truncation -g -g -O2 -fstack-protector-strong -Wformat -Werror=format-security -fno-omit-frame-pointer -fPIC -I. -I./ -I/usr/include/postgresql/11/server -I/usr/include/postgresql/internal -Wdate-time -D_FORTIFY_SOURCE=2 -D_GNU_SOURCE -I/usr/include/libxml2 -I/usr/include/mit-krb5 -c -o pg_squeeze.o pg_squeeze.c
In file included from pg_squeeze.c:10:0:
pg_squeeze.h:12:10: fatal error: c.h: No such file or directory
#include "c.h"
^~~~~
compilation terminated.
: recipe for target 'pg_squeeze.o' failed
make: *** [pg_squeeze.o] Error 1

[dynelow]

Hi,
having the same issue with postgresql 13 on ubuntu 20.04. Any clue please?

hello@dynlow-virtual-machine:~/build/pg_squeeze-REL1_4_1$ make && sudo make install
gcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels -Wmissing-format-attribute -Wimplicit-fallthrough=3 -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -Wno-format-truncation -Wno-stringop-truncation -g -g -O2 -fstack-protector-strong -Wformat -Werror=format-security -fno-omit-frame-pointer -fPIC -I. -I./ -I/usr/include/postgresql/13/server -I/usr/include/postgresql/internal -Wdate-time -D_FORTIFY_SOURCE=2 -D_GNU_SOURCE -I/usr/include/libxml2 -c -o pg_squeeze.o pg_squeeze.c
In file included from pg_squeeze.c:10:
pg_squeeze.h:12:10: fatal error: c.h: No such file or directory
12 | #include "c.h"
| ^~~~~
compilation terminated.
make: *** [: pg_squeeze.o] Error 1

I used this link
https://codeload.github.com/cybertec-postgresql/pg_squeeze/tar.gz/refs/tags/REL1_4_1
And still have the same issue when i clone the repo

[ahouska]

Does the file c.h exist either in /usr/include/postgresql/13/server/ or in /usr/include/postgresql/internal/ ?

[dynelow]

I installed postgresql-server-dev 13, and it worked.