Installing Pg gem for PostGreSQL 8.4
in [Ruby]
|
Prev: Counting a string
Next: Execute a stub written in plsql
From: Reid Thompson on 2 Mar 2010 09:01 On Tue, 2010-03-02 at 17:24 +0900, Saeed Bhuta wrote: > Reid Thompson wrote: > > On Tue, 2010-03-02 at 00:58 +0900, Saeed Bhuta wrote: > >> > $ apt-cache search postgresql > >> > >> http://pastebin.com/7qCufpx1 > >> > >> 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 what does $ ls -lrt /usr/lib/*libpq* return
From: Saeed Bhuta on 2 Mar 2010 09:09 Reid Thompson wrote: > On Tue, 2010-03-02 at 17:24 +0900, Saeed Bhuta 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 -- Posted via http://www.ruby-forum.com/.
From: Reid Thompson on 2 Mar 2010 11:24 On Tue, 2010-03-02 at 23:09 +0900, Saeed Bhuta wrote: > Reid Thompson wrote: > > On Tue, 2010-03-02 at 17:24 +0900, Saeed Bhuta 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 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.
From: Reid Thompson on 2 Mar 2010 11:28 On Tue, 2010-03-02 at 11:23 -0500, Reid Thompson wrote: > On Tue, 2010-03-02 at 23:09 +0900, Saeed Bhuta wrote: > > Reid Thompson wrote: > > > On Tue, 2010-03-02 at 17:24 +0900, Saeed Bhuta 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 > > 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. doh -- your's is likely here > 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"
From: Saeed Bhuta on 2 Mar 2010 11:49
Reid Thompson wrote: > On Tue, 2010-03-02 at 11:23 -0500, Reid Thompson 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; } -- Posted via http://www.ruby-forum.com/. |