Re: Cstore_fdw issue. - Mailing list pgsql-general
| From | Moses Mafusire |
|---|---|
| Subject | Re: Cstore_fdw issue. |
| Date | |
| Msg-id | 2128533583.79465.1585918430902@mail.yahoo.com Whole thread Raw |
| In response to | Re: Cstore_fdw issue. (Adrian Klaver <adrian.klaver@aklaver.com>) |
| Responses |
Re: Cstore_fdw issue.
|
| List | pgsql-general |
Hi Adrian,
Thanks for your response. Here is what I'm getting when I run pg_config;
$ pg_config
BINDIR = /usr/bin
DOCDIR = /usr/share/doc/pgsql
HTMLDIR = /usr/share/doc/pgsql
INCLUDEDIR = /usr/include
PKGINCLUDEDIR = /usr/include/pgsql
INCLUDEDIR-SERVER = /usr/include/pgsql/server
LIBDIR = /usr/lib64
PKGLIBDIR = /usr/lib64/pgsql
LOCALEDIR = /usr/share/locale
MANDIR = /usr/share/man
SHAREDIR = /usr/share/pgsql
SYSCONFDIR = /etc
PGXS = /usr/lib64/pgsql/pgxs/src/makefiles/pgxs.mk
CONFIGURE = '--build=x86_64-redhat-linux-gnu' '--host=x86_64-redhat-linux-gnu' '--program-prefix=' '--disable-dependency-tracking' '--prefix=/usr' '--exec-prefix=/usr' '--bindir=/usr/bin' '--sbindir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' '--includedir=/usr/include' '--libdir=/usr/lib64' '--libexecdir=/usr/libexec' '--localstatedir=/var' '--sharedstatedir=/var/lib' '--mandir=/usr/share/man' '--infodir=/usr/share/info' '--disable-rpath' '--with-ldap' '--with-openssl' '--with-gssapi' '--enable-nls' '--without-readline' '--datadir=/usr/share/pgsql' 'build_alias=x86_64-redhat-linux-gnu' 'host_alias=x86_64-redhat-linux-gnu' 'CFLAGS=-O2 -g -pipe -Wall -Werror=format-security -Wp,-D_FORTIFY_SOURCE=2 -Wp,-D_GLIBCXX_ASSERTIONS -fexceptions -fstack-protector-strong -grecord-gcc-switches -specs=/usr/lib/rpm/redhat/redhat-hardened-cc1 -specs=/usr/lib/rpm/redhat/redhat-annobin-cc1 -m64 -mtune=generic -fasynchronous-unwind-tables -fstack-clash-protection -fcf-protection' 'LDFLAGS=-Wl,-z,relro -Wl,-z,now -specs=/usr/lib/rpm/redhat/redhat-hardened-ld' 'CXXFLAGS=-O2 -g -pipe -Wall -Werror=format-security -Wp,-D_FORTIFY_SOURCE=2 -Wp,-D_GLIBCXX_ASSERTIONS -fexceptions -fstack-protector-strong -grecord-gcc-switches -specs=/usr/lib/rpm/redhat/redhat-hardened-cc1 -specs=/usr/lib/rpm/redhat/redhat-annobin-cc1 -m64 -mtune=generic -fasynchronous-unwind-tables -fstack-clash-protection -fcf-protection' 'PKG_CONFIG_PATH=:/usr/lib64/pkgconfig:/usr/share/pkgconfig'
CC = gcc
CPPFLAGS = -D_GNU_SOURCE
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 -Wno-stringop-truncation -O2 -g -pipe -Wall -Werror=format-security -Wp,-D_FORTIFY_SOURCE=2 -Wp,-D_GLIBCXX_ASSERTIONS -fexceptions -fstack-protector-strong -grecord-gcc-switches -specs=/usr/lib/rpm/redhat/redhat-hardened-cc1 -specs=/usr/lib/rpm/redhat/redhat-annobin-cc1 -m64 -mtune=generic -fasynchronous-unwind-tables -fstack-clash-protection -fcf-protection
CFLAGS_SL = -fPIC
LDFLAGS = -Wl,-z,relro -Wl,-z,now -specs=/usr/lib/rpm/redhat/redhat-hardened-ld -Wl,--as-needed
LDFLAGS_EX =
LDFLAGS_SL =
LIBS = -lpgcommon -lpgport -lpthread -lssl -lcrypto -lgssapi_krb5 -lz -lrt -lcrypt -ldl -lm
VERSION = PostgreSQL 12.1
Moses Mafusire
MCITP DBA, MCTS SQL Developer, MCTS Windows 7 Fundamentals, Certified Internet CIW Foundations Associate, Project+, A+, Security+, Linux+, ITIL
On Thursday, April 2, 2020, 06:27:31 PM EDT, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
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@aklaver.com
> 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@aklaver.com
pgsql-general by date: