Re: Cstore_fdw issue.
От | Adrian Klaver |
---|---|
Тема | Re: Cstore_fdw issue. |
Дата | |
Msg-id | 64267886-2561-891a-0334-760fda81cc9b@aklaver.com обсуждение исходный текст |
Ответ на | Cstore_fdw issue. (Moses Mafusire <mosesmafusire@yahoo.com>) |
Ответы |
Re: Cstore_fdw issue.
|
Список | pgsql-general |
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
В списке pgsql-general по дате отправления:
Следующее
От: Adrian KlaverДата:
Сообщение: Re: Could someone please help us share the procedure to troubleshootthe locks on proc issues.