Thread: [DOCS] CentOS 7 incorrect installation location

[DOCS] CentOS 7 incorrect installation location

From
gregory.r.moon@gmail.com
Date:
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/9.6/static/tutorial-sql-intro.html
Description:

The make command in the tutorial throws an error concerning the pgxs path.
"pg_config --pgxs" returns "/usr/lib/pgxs/...", when the actual path is
"/usr/pgsql-9.6/lib/pgxs/...". Similarly, the expected location of the
header files is "/usr/include/...", when they are actually installed to
"/usr/pgsql-9.6/include/...". This causes the command to fail and so the
tutorial cannot continue until the issues are addressed.

To replicate:
1. Install postgres repo
"yum install
https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-7-x86_64/pgdg-centos96-9.6-3.noarch.rpm"
2. Install postgres and postgres-server
"yum install postgresql96 postgresql96-devel postgresql96-server"
3. Start postgresql server using initdb/systemctl commands
4. Download postgresql-9.6 source from
https://ftp.postgresql.org/pub/source/v9.6.1/postgresql-9.6.1.tar.gz
5. Expand source files
6. Move to tutorial directory
"cd ..../src/tutorial"
7. Run make



Re: [DOCS] CentOS 7 incorrect installation location

From
Peter Eisentraut
Date:
On 1/18/17 3:24 PM, gregory.r.moon@gmail.com wrote:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/9.6/static/tutorial-sql-intro.html
> Description:
>
> The make command in the tutorial throws an error concerning the pgxs path.
> "pg_config --pgxs" returns "/usr/lib/pgxs/...", when the actual path is
> "/usr/pgsql-9.6/lib/pgxs/...". Similarly, the expected location of the
> header files is "/usr/include/...", when they are actually installed to
> "/usr/pgsql-9.6/include/...". This causes the command to fail and so the
> tutorial cannot continue until the issues are addressed.

That would mean that the packaging is broken.  Can anyone confirm this?

--
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


Re: [DOCS] CentOS 7 incorrect installation location

From
Devrim Gündüz
Date:
Hi,

On Wed, 2017-01-18 at 20:24 +0000, gregory.r.moon@gmail.com wrote:
> The make command in the tutorial throws an error concerning the pgxs path.
> "pg_config --pgxs" returns "/usr/lib/pgxs/...", when the
> actual path is
> "/usr/pgsql-9.6/lib/pgxs/...

I think both CentOS and community RPMs are both installed. What is the output
of

rpm -qf /usr/bin/pg_config

Regards,
--
Devrim Gündüz
EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR

Attachment