Trying to install DBD::Pg on a client system (ie one NOT running a postgres database) it is asking for the location of the pg_config file, which (not surprisingly) doesn’t exist.
System is Rocky Linux release 9.2 (Blue Onyx) Postgresql IS installed via the postgres.org repository: dnf info postgresql Last metadata expiration check: 0:46:45 ago on Thu 02 Nov 2023 03:28:22 PM MST. Installed Packages Name : postgresql Version : 13.11 Release : 1.el9_2 Architecture : x86_64 Size : 5.7 M Source : postgresql-13.11-1.el9_2.src.rpm Repository : @System From repo : appstream Summary : PostgreSQL client programs URL : http://www.postgresql.org/ License : PostgreSQL Description : PostgreSQL is an advanced Object-Relational database management : system (DBMS). The base postgresql package contains the client : programs that you'll need to access a PostgreSQL DBMS server, as : well as HTML documentation for the whole system. These client : programs can be located on the same machine as the PostgreSQL : server, or on a remote machine that accesses a PostgreSQL server : over a network connection. The PostgreSQL server can be found in : the postgresql-server sub-package. But I was getting some weird issues using the perl-DBD-Pg package so I removed it and am trying to install it from CPAN (which is offering a newer version anyway) with the following results: cpan[2]> install DBD::Pg Running install for module 'DBD::Pg' Checksum for /root/.cpan/sources/authors/id/T/TU/TURNSTEP/DBD-Pg-3.17.0.tar.gz ok Scanning cache /root/.cpan/build for sizes ............................................................................DONE 'YAML' not installed, will not store persistent state Configuring T/TU/TURNSTEP/DBD-Pg-3.17.0.tar.gz with Makefile.PL Configuring DBD::Pg 3.17.0 Path to pg_config? No POSTGRES_HOME defined, cannot find automatically No 'Makefile' created TURNSTEP/DBD-Pg-3.17.0.tar.gz /usr/bin/perl Makefile.PL -- NOT OK Failed during this command: TURNSTEP/DBD-Pg-3.17.0.tar.gz : writemakefile NO -- No 'Makefile’ created So what should be in the pg_conf file fore a client-only system? (Note even with the perl-DBD-Pg repo package installed there is no pg_config file on the system…including on another server running the same version of Linux that is successfully running a website using a postgres database on the same postgres server… ) -- Bruce Johnson University of Arizona College of Pharmacy Information Technology Group Institutions do not have opinions, merely customs
