Installing DBD::Pg in Darwin

BruceDB has asked for the wisdom of the Perl Monks concerning the following question:

Hi,

First, here's some stats about my environment:

Configuring DBD::Pg 2.15.1
PostgreSQL version: 70310 (default port: 5432)
OS: darwin
[download]

I'm using MCPAN to install.

During the installation process I am asked the following question: "Path to pg_config?"

Using "locate pc_config" I find it at "/System/Library/CoreServices/RemoteManagement/rmdb.bundle/bin/pg_config"

I enter that as the answer. The process continues and I get the following:

POSTGRES_HOME: (not set)
POSTGRES_INCLUDE: /BinaryCache/RemoteDesktopDB/RemoteDesktopDB-105.roo
+t~225//System/Library/CoreServices/RemoteManagement/rmdb.bundle/inclu
+de
POSTGRES_LIB: /BinaryCache/RemoteDesktopDB/RemoteDesktopDB-105.root~22
+5//System/Library/CoreServices/RemoteManagement/rmdb.bundle/lib
OS: darwin
The value of POSTGRES_INCLUDE points to a non-existent directory: /Bin
+aryCache/RemoteDesktopDB/RemoteDesktopDB-105.root~225//System/Library
+/CoreServices/RemoteManagement/rmdb.bundle/include
Cannot build unless the directories exist, exiting.
[download]

According to http://kobesearch.cpan.org/htdocs/DBD-Pg/README.html, "BD::Pg needs to know where to find the libpq libraries: this is usually done by checking the output of the pg_config executable."

I check pc_config, and see the following:

# stored configuration values
val_bindir='/BinaryCache/RemoteDesktopDB/RemoteDesktopDB-105.root~225/
+/System/Library/CoreServices/RemoteManagement/rmdb.bundle/bin'
val_includedir='/BinaryCache/RemoteDesktopDB/RemoteDesktopDB-105.root~
+225//System/Library/CoreServices/RemoteManagement/rmdb.bundle/include
+'
val_includedir_server='/BinaryCache/RemoteDesktopDB/RemoteDesktopDB-10
+5.root~225//System/Library/CoreServices/RemoteManagement/rmdb.bundle/
+include/postgresql/server'
val_libdir='/BinaryCache/RemoteDesktopDB/RemoteDesktopDB-105.root~225/
+/System/Library/CoreServices/RemoteManagement/rmdb.bundle/lib'
val_pkglibdir='/BinaryCache/RemoteDesktopDB/RemoteDesktopDB-105.root~2
+25//System/Library/CoreServices/RemoteManagement/rmdb.bundle/lib/post
+gresql'
[download]

One question I have is the first part of the path (up to root~225/). I don't have a directory /Binary/... in my system. Is it okay to update this file (pg_config) and remove the first part of the path)? The path beginning with /System/... does exist.

Thanks,

- Bruce

Comment on Installing DBD::Pg in Darwin Select or Download Code

Replies are listed 'Best First'.
Re: Installing DBD::Pg in Darwin by zwon (Abbot) on Nov 03, 2009 at 20:21 UTC
Is it okay to update this file (pg_config) and remove the first part of the path)? I don't know if it'll help, but I'm pretty sure it wouldn't hurt if you try :)	[reply]
Re: Installing DBD::Pg in Darwin by john_oshea (Priest) on Nov 15, 2009 at 23:51 UTC
It sounds like you don't have a user/developer-oriented version of PostgreSQL installed - version 7.3.10 is getting on for four years old (which is positively ancient in the PostgreSQL world), and those paths you list seem to have something to do with Apple's Remote Desktop software (I don't have that installed so I can't confirm that), which is something you probably don't want to be altering. You may find it easier to install your own copy of PostgreSQL (even if you never use it on your machine) as that'll install all the libraries/headers that DBD::Pg is after. I'm a MacPorts fan, so doing a `sudo port install postgresql84` should get you everything installed in the appropriate places. My `pg_config` ends up in `/opt/local/lib/postgresql83/bin/pg_config` and the DBD::Pg install seems more than happy with that. Other alternatives: Fink and the PostgreSQL installer, though I've no idea if the latter will install pg_config and the like. FWIW, pg_config should, I think, be a compiled binary, and not something that you can alter in a text editor - on my system, `file` says it's a `Mach-O universal binary with 2 architectures` file. Apologies for the two-weeks-too-late response - I haven't been on PerlMonks in a while - hopefully your problem has been solved quite a while back, and, if not, hopefully the above will help a bit	[reply] [d/l] [select]