Installing Pg gem for PostGreSQL 8.4

Ruby
1

Hi All,

I want to save data from a ruby script into a table in a PostGreSQL 8.4
database.

After looking into PostGreSQL connectivity in Ruby, I have come accross
the ‘pg’ gem.

I attempted to install the gem with the command: ‘sudo gem install pg’
but got the following error:
sudo gem install pg
Building native extensions. This could take a while…
ERROR: Error installing pg:
ERROR: Failed to build gem native extension.

/usr/bin/ruby1.8 extconf.rb
checking for main() in -lpq… no
checking for main() in -llibpq… no
checking for main() in -lms/libpq… no
*** extconf.rb failed ***
Could not create Makefile due to some reason, probably lack of
necessary libraries and/or headers. Check the mkmf.log file for more
details. You may need configuration options.

Provided configuration options:
–with-opt-dir
–without-opt-dir
–with-opt-include
–without-opt-include=${opt-dir}/include
–with-opt-lib
–without-opt-lib=${opt-dir}/lib
–with-make-prog
–without-make-prog
–srcdir=.
–curdir
–ruby=/usr/bin/ruby1.8
–with-pg-dir
–without-pg-dir
–with-pg-include
–without-pg-include=${pg-dir}/include
–with-pg-lib
–without-pg-lib=${pg-dir}/lib
–with-pqlib
–without-pqlib
–with-libpqlib
–without-libpqlib
–with-ms/libpqlib
–without-ms/libpqlib
Could not find PostgreSQL build environment (libraries & headers):
Makefile not created

Gem files will remain installed in /var/lib/gems/1.8/gems/pg-0.8.0 for
inspection.
Results logged to /var/lib/gems/1.8/gems/pg-0.8.0/ext/gem_make.out

Would appreciate it if someone could point me in the right direction.

Saeed.

2

Are you installing this on a mac, windows or a linux environment? You
may
need to make sure your C/C++ compiler is configured on the platform for
the
native extensions to compile and install.

Thanks, Shashank

3

Shashank Tiwari wrote:

Are you installing this on a mac, windows or a linux environment? You
may
need to make sure your C/C++ compiler is configured on the platform for
the
native extensions to compile and install.

Thanks, Shashank

Hi Shashank,

Thanks for replying. I’m using Linux Ubuntu Karmic Koala.

Saeed.

4

On Fri, 2010-02-26 at 23:16 +0900, Saeed B. wrote:

Could not find PostgreSQL build environment (libraries & headers):

you need to install the postgresql development packages

5

you need to install the postgresql development packages

I think I’ve done this already. Nonetheless, I’m going to try and
install it again. Do you know the name of the development packages?

Thanks,

Saeed.

6

Saeed B. wrote:

Shashank Tiwari wrote:

Are you installing this on a mac, windows or a linux environment? You
may
need to make sure your C/C++ compiler is configured on the platform for
the
native extensions to compile and install.

Thanks, Shashank

I just installed the ‘libecpg-dev’ package and am now getting the
following error when trying to install the pg gem:

"sudo gem install pg
Building native extensions. This could take a while…
ERROR: Error installing pg:
ERROR: Failed to build gem native extension.

/usr/bin/ruby1.8 extconf.rb
checking for pg_config… yes
checking for libpq-fe.h… yes
checking for libpq/libpq-fs.h… yes
checking for PQconnectdb() in -lpq… no
checking for PQconnectdb() in -llibpq… no
checking for PQconnectdb() in -lms/libpq… no
Can’t find the PostgreSQL client library (libpq)
*** extconf.rb failed ***
Could not create Makefile due to some reason, probably lack of
necessary libraries and/or headers. Check the mkmf.log file for more
details. You may need configuration options.

Provided configuration options:
–with-opt-dir
–without-opt-dir
–with-opt-include
–without-opt-include=${opt-dir}/include
–with-opt-lib
–without-opt-lib=${opt-dir}/lib
–with-make-prog
–without-make-prog
–srcdir=.
–curdir
–ruby=/usr/bin/ruby1.8
–with-pg
–without-pg
–with-pg-config
–without-pg-config
–with-pg-dir
–without-pg-dir
–with-pg-include
–without-pg-include=${pg-dir}/include
–with-pg-lib
–without-pg-lib=${pg-dir}/lib
–enable-static-build
–disable-static-build
–with-pqlib
–without-pqlib
–with-libpqlib
–without-libpqlib
–with-ms/libpqlib
–without-ms/libpqlib

Gem files will remain installed in /var/lib/gems/1.8/gems/pg-0.9.0 for
inspection.
Results logged to /var/lib/gems/1.8/gems/pg-0.9.0/ext/gem_make.out"

7

On Mon, 2010-03-01 at 17:56 +0900, Saeed B. wrote:

I just installed the ‘libecpg-dev’ package and am now getting the
following error when trying to install the pg gem:

I believe the libecpg-dev package would only provide the required
packages for developing embedded sql programs.

Open synaptic, scroll down to the postgresql section, and look at the
available packages. Make sure you have appropriate server and client
packages installed as well as their associated dev packages.

8

Run this…
$ dpkg --get-selections
and paste the results in a pastebin.

At this point, the gems is stating that it cannot find libpq ( the
postgresql C client library ). Do you have the postgresql client
packages installed?

reid

9

Here is the result of the ‘$ dpkg --get-selections’ command;
libxvmc1 installlibxxf86dga1 installlibxxf86misc1 installlibxx - Pastebin.com

Looked in Synaptic, seemed like all the right server and client packages
were installed.

Looks like you’re missing the libpq5 and libpq-dev packages.

10

Lars H. wrote:

Here is the result of the ‘$ dpkg --get-selections’ command;
libxvmc1 installlibxxf86dga1 installlibxxf86misc1 installlibxx - Pastebin.com

Looked in Synaptic, seemed like all the right server and client packages
were installed.

Looks like you’re missing the libpq5 and libpq-dev packages.

When I try to install them using the command:

sudo apt-get libpq5 libpq-dev

I get the message;

Reading package lists… Done
Building dependency tree
Reading state information… Done
libpq5 is already the newest version.
libpq-dev is already the newest version.
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.

:S

11

On Mon, 2010-03-01 at 23:19 +0900, Saeed B. wrote:

Here is the result of the ‘$ dpkg --get-selections’ command;
libxvmc1 installlibxxf86dga1 installlibxxf86misc1 installlibxx - Pastebin.com

Looked in Synaptic, seemed like all the right server and client packages
were installed.

pastebin the output of

$ apt-cache search postgresql

12

Reid T. wrote:

On Mon, 2010-03-01 at 23:19 +0900, Saeed B. wrote:

Here is the result of the ‘$ dpkg --get-selections’ command;
libxvmc1 installlibxxf86dga1 installlibxxf86misc1 installlibxx - Pastebin.com

Looked in Synaptic, seemed like all the right server and client packages
were installed.

pastebin the output of

$ apt-cache search postgresql

I don’t think that is all of the output, I copied what was displayed on
the terminal.

Many Thanks,

Saeed

13

Here is the result of the ‘$ dpkg --get-selections’ command;

Looked in Synaptic, seemed like all the right server and client packages
were installed.

14

On Tue, 2010-03-02 at 00:58 +0900, Saeed B. wrote:

$ apt-cache search postgresql

nurpawiki - Wiki with integrated to-do list and schedulerodbc-postgresql - ODB - Pastebin.com

I don’t think that is all of the output, I copied what was displayed on
the terminal.

Many Thanks,

Saeed

what do the following commands return

$pg_config --libdir

$pg_config --bindir

15

Reid T. wrote:

On Tue, 2010-03-02 at 00:58 +0900, Saeed B. wrote:

$ apt-cache search postgresql

nurpawiki - Wiki with integrated to-do list and schedulerodbc-postgresql - ODB - Pastebin.com

I don’t think that is all of the output, I copied what was displayed on
the terminal.

Many Thanks,

Saeed

what do the following commands return

$pg_config --libdir

$pg_config --bindir

pg_config --libdir
/usr/lib

pg_config --bindir
/usr/lib/postgresql/8.4/bin

16

Reid T. wrote:

On Tue, 2010-03-02 at 17:24 +0900, Saeed B. wrote:

/usr/lib

pg_config --bindir
/usr/lib/postgresql/8.4/bin

what does
$ ls -lrt /usr/lib/libpq

return

ls -lrt /usr/lib/libpq
-rw-r–r-- 1 root root 217474 2009-09-09 17:51 /usr/lib/libpq.a
-rw-r–r-- 1 root root 151036 2009-09-09 17:51 /usr/lib/libpq.so.5.2
lrwxrwxrwx 1 root root 12 2009-11-30 12:12 /usr/lib/libpq.so.5 ->
libpq.so.5.2
lrwxrwxrwx 1 root root 12 2010-03-02 10:12 /usr/lib/libpq.so ->
libpq.so.5.2

17

On Tue, 2010-03-02 at 17:24 +0900, Saeed B. wrote:

/usr/lib

pg_config --bindir
/usr/lib/postgresql/8.4/bin

what does
$ ls -lrt /usr/lib/libpq

return

18

On Tue, 2010-03-02 at 11:23 -0500, Reid T. wrote:

$ ls -lrt /usr/lib/libpq
libpq.so.5.2

That may or may not be where your’s is located.

doh – your’s is likely here

Gem files will remain installed in /var/lib/gems/1.8/gems/pg-0.9.0
for

19

On Tue, 2010-03-02 at 23:09 +0900, Saeed B. wrote:

return

ls -lrt /usr/lib/libpq
-rw-r–r-- 1 root root 217474 2009-09-09 17:51 /usr/lib/libpq.a
-rw-r–r-- 1 root root 151036 2009-09-09 17:51 /usr/lib/libpq.so.5.2
lrwxrwxrwx 1 root root 12 2009-11-30 12:12 /usr/lib/libpq.so.5 ->
libpq.so.5.2
lrwxrwxrwx 1 root root 12 2010-03-02 10:12 /usr/lib/libpq.so ->
libpq.so.5.2

ok - that all looks right so far.
per your original email

Check the mkmf.log file for more
details.
what does mkmf.log contain?

on my box this file is located at

/usr/lib/ruby/gems/1.8/gems/pg-0.8.0/ext/mkmf.log

That may or may not be where your’s is located.

20

Reid T. wrote:

On Tue, 2010-03-02 at 11:23 -0500, Reid T. wrote:

$ ls -lrt /usr/lib/libpq
libpq.so.5.2

That may or may not be where your’s is located.

doh – your’s is likely here

Gem files will remain installed in /var/lib/gems/1.8/gems/pg-0.9.0
for

find_executable: checking for pg_config… -------------------- yes

have_header: checking for libpq-fe.h… -------------------- yes

“gcc -E -I. -I/usr/lib/ruby/1.8/i486-linux -I.
-I/usr/include/postgresql/include -D_FILE_OFFSET_BITS=64
-I/usr/include/postgresql -fno-strict-aliasing -g -g -O2 -fPIC
conftest.c -o conftest.i”
checked program was:
/* begin /
1: #include <libpq-fe.h>
/ end */

have_header: checking for libpq/libpq-fs.h… -------------------- yes

“gcc -E -I. -I/usr/lib/ruby/1.8/i486-linux -I.
-I/usr/include/postgresql/include -D_FILE_OFFSET_BITS=64
-I/usr/include/postgresql -fno-strict-aliasing -g -g -O2 -fPIC
conftest.c -o conftest.i”
checked program was:
/* begin /
1: #include <libpq/libpq-fs.h>
/ end */

have_library: checking for PQconnectdb() in
-l/usr/include/postgresql/… -------------------- no

“gcc -o conftest -I. -I/usr/lib/ruby/1.8/i486-linux -I.
-I/usr/include/postgresql/include -D_FILE_OFFSET_BITS=64
-I/usr/include/postgresql -fno-strict-aliasing -g -g -O2 -fPIC
conftest.c -L. -L/usr/lib -L/usr/include/postgresql/lib -L.
-Wl,-Bsymbolic-functions -rdynamic -Wl,-export-dynamic -L/usr/lib
-lruby1.8-static -l/usr/include/postgresql/ -lpthread -lrt -ldl -lcrypt
-lm -lc”
conftest.c: In function ‘t’:
conftest.c:3: error: ‘PQconnectdb’ undeclared (first use in this
function)
conftest.c:3: error: (Each undeclared identifier is reported only once
conftest.c:3: error: for each function it appears in.)
checked program was:
/* begin /
1: /top/
2: int main() { return 0; }
3: int t() { void ((volatile p)()); p = (void (()()))PQconnectdb;
return 0; }
/ end */

“gcc -o conftest -I. -I/usr/lib/ruby/1.8/i486-linux -I.
-I/usr/include/postgresql/include -D_FILE_OFFSET_BITS=64
-I/usr/include/postgresql -fno-strict-aliasing -g -g -O2 -fPIC
conftest.c -L. -L/usr/lib -L/usr/include/postgresql/lib -L.
-Wl,-Bsymbolic-functions -rdynamic -Wl,-export-dynamic -L/usr/lib
-lruby1.8-static -l/usr/include/postgresql/ -lpthread -lrt -ldl -lcrypt
-lm -lc”
/usr/bin/ld: cannot find -l/usr/include/postgresql/
collect2: ld returned 1 exit status
checked program was:
/* begin /
1: /top/
2: int main() { return 0; }
3: int t() { PQconnectdb(); return 0; }
/ end */

have_library: checking for PQconnectdb() in -llibpq…
-------------------- no

“gcc -o conftest -I. -I/usr/lib/ruby/1.8/i486-linux -I.
-I/usr/include/postgresql/include -D_FILE_OFFSET_BITS=64
-I/usr/include/postgresql -fno-strict-aliasing -g -g -O2 -fPIC
conftest.c -L. -L/usr/lib -L/usr/include/postgresql/lib -L.
-Wl,-Bsymbolic-functions -rdynamic -Wl,-export-dynamic -L/usr/lib
-lruby1.8-static -llibpq -lpthread -lrt -ldl -lcrypt -lm -lc”
conftest.c: In function ‘t’:
conftest.c:3: error: ‘PQconnectdb’ undeclared (first use in this
function)
conftest.c:3: error: (Each undeclared identifier is reported only once
conftest.c:3: error: for each function it appears in.)
checked program was:
/* begin */
1: /top/
2: int main() { return 0; }