On 4/2/20 1:40 PM, Moses Mafusire wrote:
Hi,
I am new to PostgreSQL, successfully installed PGSql v12.2 on my CentOS
7 machine and I am trying to install cstore_fdw.
1. I have managed to run this command;
/sudo yum install protobuf-c-devel/
/
/
/ 2. /Per the instructions I am followin;
/ Once you have protobuf-c installed on your machine, you are
ready to build cstore_fdw. For this, you need to include the pg_config
directory path in your make command. /
/
/
// 3. I have searched for pg_config directory and found 2 locations;
/usr/bin/pg_config
/usr/pgsql-12/bin/pg_config
//4. However when I try to run makefile in c_store_fdw I get this error;
[postgres@dart-centos cstore_fdw]$ sudo PATH=/usr/bin/:$PATH make
/ [sudo] password for postgres: /
Makefile:50: *** PostgreSQL 9.3 to 12 is required to compile
this extension. Stop.
// I even tried the other path, same error;
[postgres@dart-centos cstore_fdw]$
PATH=/usr/pgsql-12/bin/:$PATH make
Makefile:50: *** PostgreSQL 9.3 to 12 is required to compile
this extension. Stop.
5. PostgreSQL Version
/ postgres=# show server_version;/
server_version
----------------
12.2
(1 row)
postgres=# \! psql -V
psql (PostgreSQL) 12.2
May you please assist me with this issue. //
What do you get if you run:
pg_config
from the command line.
An example from my machine:
aklaver@maura:~> pg_config
BINDIR = /usr/local/pgsql12/bin
DOCDIR = /usr/local/pgsql12/share/doc
HTMLDIR = /usr/local/pgsql12/share/doc
INCLUDEDIR = /usr/local/pgsql12/include
PKGINCLUDEDIR = /usr/local/pgsql12/include
INCLUDEDIR-SERVER = /usr/local/pgsql12/include/server
LIBDIR = /usr/local/pgsql12/lib64
PKGLIBDIR = /usr/local/pgsql12/lib64
LOCALEDIR = /usr/local/pgsql12/share/locale
MANDIR = /usr/local/pgsql12/share/man
SHAREDIR = /usr/local/pgsql12/share
SYSCONFDIR = /usr/local/pgsql12/etc
PGXS = /usr/local/pgsql12/lib64/pgxs/src/makefiles/pgxs.mk
CONFIGURE = '--with-python' '--with-openssl' '--with-libxml'
'--with-uuid=ossp' '--prefix=/usr/local/pgsql12'
CC = gcc
CPPFLAGS = -D_GNU_SOURCE -I/usr/include/libxml2
CFLAGS = -Wall -Wmissing-prototypes -Wpointer-arith
-Wdeclaration-after-statement -Werror=vla -Wendif-labels
-Wmissing-format-attribute -Wformat-security -fno-strict-aliasing
-fwrapv -fexcess-precision=standard -Wno-format-truncation -O2
CFLAGS_SL = -fPIC
LDFLAGS = -Wl,--as-needed
-Wl,-rpath,'/usr/local/pgsql12/lib64',--enable-new-dtags
LDFLAGS_EX =
LDFLAGS_SL =
LIBS = -lpgcommon -lpgport -lpthread -lxml2 -lssl -lcrypto -lz
-lreadline -lrt -lcrypt -ldl -lm
VERSION = PostgreSQL 12.1
Thank You,
Moses
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
