Re: Missing pg_config on SuSE SLES 12 for PostgreSQL 10

El día sábado, abril 27, 2019 a las 04:11:06p. m. +0200, Christoph Moench-Tegeder escribió:

> ## Matthias Apitz (guru@unixarea.de):
>
> > To get Perl's DBD::Pg compiled now I really do need the pg_config tool,
> > but I can't figure out how to get it. I see the following RPM (the ones
> > with an 'i' or 'i+' are installed):
>
> Um. Which postgresql10-* packages are that?
> SLES12SP4 has "postgresql10" and friends:
> Information for package postgresql10:
> -------------------------------------
> Repository     : SLES12-SP4-Updates
> Name           : postgresql10
> Version        : 10.6-1.6.1
> Arch           : x86_64
> Vendor         : SUSE LLC <https://www.suse.com/>
>
> And there are the PGDG packages:
> cmt@squirrel:/tmp$ rpm -qp --info postgresql10-10.7-1PGDG.sles12.x86_64.rpm
> warning: postgresql10-10.7-1PGDG.sles12.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID 442df0f8: NOKEY
> Name        : postgresql10
> Version     : 10.7
> Release     : 1PGDG.sles12
> Architecture: x86_64
> Install Date: (not installed)
> Group       : Applications/Databases
> Size        : 15066385
> License     : PostgreSQL
>
> If you are on a SLES without postgresql10 packages and use the PGDG
> packages, you'll find pg_config in the "postgresql10" package (at
> least it's in that postgresql10-10.7-1PGDG.sles12.x86_64.rpm I used above,
> and the spec file shows the same...), the full path would be
>  "/usr/pgsql-10/bin/pg_config".
>
> If you're on SLES12 with Suse's postgresql10 packages, you'll find
> pg_config in "postgresql10-devel" - which you only get if you have
> activated/installed the "SDK" repositories. The full path for pg_config
> with this package is
>   "/usr/lib/postgresql10/bin/pg_config".
>
> If you are on a SLES with postgresql10 packages and are mixing that
> with the PGDG packages, you might be in a mess. And as far as I know
> there's no good way to make sure which packages you get, as zypper
> tells me "Repository priorities are without effect. All enabled repositories
> share the same priority.".

Hello Christoph,

The server in question is SLES12-SP3 and I can't update to SP4 at the
moment. I have installed the following pkg:

# cat /etc/os-release
NAME="SLES"
VERSION="12-SP3"
VERSION_ID="12.3"
PRETTY_NAME="SUSE Linux Enterprise Server 12 SP3"
ID="sles"
ANSI_COLOR="0;32"
CPE_NAME="cpe:/o:suse:sles:12:sp3"

# rpm -qa | egrep 'postgre|libpq' | sort
libpq5-10.6-1.6.1.x86_64
libpqos1-0.1.4-3.1.x86_64
libpqxx-5.0.1-2.sles12.x86_64
libpqxx-devel-5.0.1-2.sles12.x86_64
postgresql-init-10-17.20.1.noarch
postgresql-jdbc-9.4-1.1.noarch
postgresql10-10.6-1.6.1.x86_64
postgresql10-contrib-10.6-1.6.1.x86_64
postgresql10-devel-10.4-1PGDG.sles12.x86_64
postgresql10-docs-10.6-1.6.1.noarch
postgresql10-libs-10.4-1PGDG.sles12.x86_64
postgresql10-server-10.6-1.6.1.x86_64

How can I activated/installed the "SDK" repositories to get rid of the
PGDG packages? Thanks in advance.

Regards

    matthias

--
Matthias Apitz, ✉ guru@unixarea.de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub