I actually started the installation process as me. I was logged as user
postgres because after trying and getting that version error message. I thought
as user postgres I would be able to install, but failed). I get the same
results though;
[username@dart-centos ~]$ /usr/bin/pg_configBINDIR = /usr/binDOCDIR =
/usr/share/doc/pgsqlHTMLDIR = /usr/share/doc/pgsqlINCLUDEDIR =
/usr/includePKGINCLUDEDIR = /usr/include/pgsqlINCLUDEDIR-SERVER =
/usr/include/pgsql/serverLIBDIR = /usr/lib64PKGLIBDIR =
/usr/lib64/pgsqlLOCALEDIR = /usr/share/localeMANDIR = /usr/share/manSHAREDIR =
/usr/share/pgsqlSYSCONFDIR = /etcPGXS =
/usr/lib64/pgsql/pgxs/src/makefiles/pgxs.mkCONFIGURE =
'--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 = gccCPPFLAGS =
-D_GNU_SOURCECFLAGS = -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-protectionCFLAGS_SL
= -fPICLDFLAGS = -Wl,-z,relro -Wl,-z,now
-specs=/usr/lib/rpm/redhat/redhat-hardened-ld -Wl,--as-neededLDFLAGS_EX =
LDFLAGS_SL = LIBS = -lpgcommon -lpgport -lpthread -lssl -lcrypto -lgssapi_krb5
-lz -lrt -lcrypt -ldl -lm VERSION = PostgreSQL 12.1
[username@dart-centos ~]$ /usr/pgsql-12/bin/pg_configBINDIR =
/usr/pgsql-12/binDOCDIR = /usr/pgsql-12/docHTMLDIR =
/usr/pgsql-12/doc/htmlINCLUDEDIR = /usr/pgsql-12/includePKGINCLUDEDIR =
/usr/pgsql-12/includeINCLUDEDIR-SERVER = /usr/pgsql-12/include/serverLIBDIR =
/usr/pgsql-12/libPKGLIBDIR = /usr/pgsql-12/libLOCALEDIR =
/usr/pgsql-12/share/localeMANDIR = /usr/pgsql-12/share/manSHAREDIR =
/usr/pgsql-12/shareSYSCONFDIR = /etc/sysconfig/pgsqlPGXS =
/usr/pgsql-12/lib/pgxs/src/makefiles/pgxs.mkCONFIGURE = '--enable-rpath'
'--prefix=/usr/pgsql-12' '--includedir=/usr/pgsql-12/include'
'--libdir=/usr/pgsql-12/lib' '--mandir=/usr/pgsql-12/share/man'
'--datadir=/usr/pgsql-12/share' '--with-icu' '--with-llvm' '--with-perl'
'--with-python' '--with-tcl' '--with-tclconfig=/usr/lib64' '--with-openssl'
'--with-pam' '--with-gssapi' '--with-includes=/usr/include'
'--with-libraries=/usr/lib64' '--enable-nls' '--enable-dtrace'
'--with-uuid=e2fs' '--with-libxml' '--with-libxslt' '--with-ldap'
'--with-selinux' '--with-systemd' '--with-system-tzdata=/usr/share/zoneinfo'
'--sysconfdir=/etc/sysconfig/pgsql' '--docdir=/usr/pgsql-12/doc'
'--htmldir=/usr/pgsql-12/doc/html' '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,--as-needed'
'PKG_CONFIG_PATH=:/usr/lib64/pkgconfig:/usr/share/pkgconfig'
'PYTHON=/usr/bin/python2'CC = gccCPPFLAGS = -D_GNU_SOURCE
-I/usr/include/libxml2 -I/usr/includeCFLAGS = -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-protectionCFLAGS_SL
= -fPICLDFLAGS = -Wl,--as-needed -L/usr/lib64 -L/usr/lib64 -Wl,--as-needed
-Wl,-rpath,'/usr/pgsql-12/lib',--enable-new-dtagsLDFLAGS_EX = LDFLAGS_SL = LIBS
= -lpgcommon -lpgport -lpthread -lselinux -lxslt -lxml2 -lpam -lssl -lcrypto
-lgssapi_krb5 -lz -lreadline -lrt -lcrypt -ldl -lm VERSION = PostgreSQL 12.2
Thanks
Moses
On Friday, April 3, 2020, 01:57:21 PM EDT, Adrian Klaver
<adrian.kla...@aklaver.com> wrote:
On 4/3/20 10:48 AM, Moses Mafusire wrote:
> Adrian,
> I really appreciate your help. I was able to open the file in a text
> editor in centOS, but it's read-only. I cannot even replace the file.
> Any tricks up your sleeves for me to edit this file.
Looks like a permissions issue.
In your first post you had:
[postgres@dart-centos cstore_fdw]$ PATH=/usr/pgsql-12/bin/:$PATH make
From above I am assuming you unpacked the cstore source as the postgres
user into the cstore_fdw directory. Is that correct?
If that is the case then you will need to open the Makefile as the
postgres user in order to edit it.
While you are in:
[postgres@dart-centos cstore_fdw]$
run:
/usr/bin/pg_config
and
/usr/pgsql-12/bin/pg_config
and confirm they are actually returning information.
>
> Thanks
>
> *Moses *
--
Adrian Klaver
adrian.kla...@aklaver.com
