Install fails on CentOS

[wyager]

I'm running CentOS 6 (centos-release-6-8.el6.centos.12.3.x86_64)

Here's my postgres stuff:

Installed Packages
Name        : libpqxx
Arch        : x86_64
Epoch       : 1
Version     : 4.0.1
Release     : 2.el6
Size        : 641 k
Repo        : installed
From repo   : epel
Summary     : C++ client API for PostgreSQL
URL         : http://pqxx.org/
License     : BSD
Description : C++ client API for PostgreSQL. The standard front-end (in the sense of
            : "language binding") for writing C++ programs that use PostgreSQL.
            : Supersedes older libpq++ interface.

Installed Packages
Name        : libpqxx-devel
Arch        : x86_64
Epoch       : 1
Version     : 4.0.1
Release     : 2.el6
Size        : 327 k
Repo        : installed
From repo   : epel
Summary     : Development tools for libpqxx
URL         : http://pqxx.org/
License     : BSD
Description : Development tools for libpqxx.

Installed Packages
Name        : postgresql
Arch        : x86_64
Version     : 8.4.20
Release     : 6.el6
Size        : 14 M
Repo        : installed
From repo   : base
Summary     : PostgreSQL client programs
URL         : http://www.postgresql.org/
License     : PostgreSQL
Description : PostgreSQL is an advanced Object-Relational database management system
            : (DBMS) that supports almost all SQL constructs (including
            : transactions, subselects and user-defined types and functions). The
            : postgresql package includes the client programs and libraries that
            : you'll need to access a PostgreSQL DBMS server.  These PostgreSQL
            : client programs are programs that directly manipulate the internal
            : structure of PostgreSQL databases on a PostgreSQL server. These client
            : programs can be located on the same machine with the PostgreSQL
            : server, or may be on a remote machine which accesses a PostgreSQL
            : server over a network connection. This package contains the docs
            : in HTML for the whole package, as well as command-line utilities for
            : managing PostgreSQL databases on a PostgreSQL server.
            :
            : If you want to manipulate a PostgreSQL database on a local or remote PostgreSQL
            : server, you need this package. You also need to install this package
            : if you're installing the postgresql-server package.


Name        : postgresql-devel
Arch        : x86_64
Version     : 8.4.20
Release     : 6.el6
Size        : 3.4 M
Repo        : installed
From repo   : base
Summary     : PostgreSQL development header files and libraries
URL         : http://www.postgresql.org/
License     : PostgreSQL
Description : The postgresql-devel package contains the header files and libraries
            : needed to compile C or C++ applications which will directly interact
            : with a PostgreSQL database management server and the ecpg Embedded C
            : Postgres preprocessor. You need to install this package if you want to
            : develop applications which will interact with a PostgreSQL server.

And the failure:

$ cabal install postgresql-libpq-0.9.2.0
Resolving dependencies...
Downloading postgresql-libpq-0.9.2.0...
Configuring postgresql-libpq-0.9.2.0...
Building postgresql-libpq-0.9.2.0...
Failed to install postgresql-libpq-0.9.2.0
Build log ( /home/Frontend/.cabal/logs/postgresql-libpq-0.9.2.0.log ):
[1 of 1] Compiling Main             ( /tmp/cabal-tmp-20238/postgresql-libpq-0.9.2.0/dist/setup/setup.hs, /tmp/cabal-tmp-20238/postgresql-libpq-0.9.2.0/dist/setup/Main.o )
Linking /tmp/cabal-tmp-20238/postgresql-libpq-0.9.2.0/dist/setup/setup ...
Configuring postgresql-libpq-0.9.2.0...
Building postgresql-libpq-0.9.2.0...
Preprocessing library postgresql-libpq-0.9.2.0...
LibPQ.hsc: In function ‘main’:
LibPQ.hsc:983: error: ‘PGRES_SINGLE_TUPLE’ undeclared (first use in this function)
LibPQ.hsc:983: error: (Each undeclared identifier is reported only once
LibPQ.hsc:983: error: for each function it appears in.)
compiling dist/build/Database/PostgreSQL/LibPQ_hsc_make.c failed (exit code 1)
command was: /usr/bin/gcc -c dist/build/Database/PostgreSQL/LibPQ_hsc_make.c -o dist/build/Database/PostgreSQL/LibPQ_hsc_make.o -fno-stack-protector -D__GLASGOW_HASKELL__=710 -Dlinux_BUILD_OS=1 -Dx86_64_BUILD_ARCH=1 -Dlinux_HOST_OS=1 -Dx86_64_HOST_ARCH=1 -I/usr/include -Icbits -Idist/build/autogen -include dist/build/autogen/cabal_macros.h -I/usr/local/haskell/ghc-7.10.2-x86_64/lib/ghc-7.10.2/bytes_6elQVSg5cWdFrvRnfxTUrH/include -I/usr/local/haskell/ghc-7.10.2-x86_64/lib/ghc-7.10.2/base_GDytRqRVSUX7zckgKqJjgw/include -I/usr/local/haskell/ghc-7.10.2-x86_64/lib/ghc-7.10.2/integ_2aU3IZNMF9a7mQ0OzsZ0dS/include -I/usr/local/haskell/ghc-7.10.2-x86_64/lib/ghc-7.10.2/include -I/usr/local/haskell/ghc-7.10.2-x86_64/lib/ghc-7.10.2/include/
cabal: Error: some packages failed to install:
postgresql-libpq-0.9.2.0 failed during the building phase. The exception was:
ExitFailure 1

Any suggestions?

[lpsmith]

You need libpq-devel, the C library, not libpqxx-devel, the C++ library. And libpq needs to be libpq version 9.2 or later, which appears to be the problem here.

[wyager]

Great, thank you. libpq-devel is called postgresql-libs on CentOS, which is why I was confused by the xx libraries.

After manually installing 9.2 from https://www.postgresql.org/download/linux/redhat/ and adding /usr/pgsql-9.2/bin to my PATH, everything builds. Closing!

[lpsmith]

Yeah, I was trying to figure out the name of the package using a CentOS VM I'm using, but I discovered the VM has a DNS resolution problem I haven't quite yet worked out. (It's using a third party package that more or less takes over the VM, and does it's own wonky things with DNS.) Glad my help was good enough!