I am totally new to postgres and need help to fix a problem comes from rake command. This morning I installed postgres 8.2 on my centos 4.3 box. the steps I used to install postgres are as follows: 1) wget postgresql-8.2.2.tar.gz from postgres.org 2) tar -zxf postgresql-8.2.2.tar.gz 3) yum install flex 4) ./configure --prefix=/usr/local/pgsql --without-readline 5) gmake 6) gmake install 7) export POSTGRES_INCLUDE=/usr/local/pgsql/include/ 8) export POSTGRES_LIB=/usr/local/pgsql/lib/ 9) export LD_LIBRARY_PATH=/usr/local/pgsql/lib/ 10)gem install ruby-postgres everything was fine. after that, I started postgresql and created a test db: CREATE DATABASE "test_developent" WITH ENCODING='UNICODE' OWNER=postgres; it was ok too. then, rails test --database=postgresql it was successfully as well. when I test rake db:migrate, I got the following error message: (in /usr/local/html/test) rake aborted! libpq.so.5: cannot open shared object file: No such file or directory - /usr/lib64/ruby/gems/1.8/gems/ruby-postgres-0.7.1.2006.04.06/./postgres.so I found postgres.so is located at folder ruby-postgres-0.7.1.2006.04.06, no idea why there is a "./" before postgres.so. any one could help me out? thanks.
on 2007-02-06 21:28
on 2007-02-07 03:07
On Tue, 2007-02-06 at 21:28 +0100, Surfman Joe wrote: > 5) gmake > OWNER=postgres; > rake aborted! > libpq.so.5: cannot open shared object file: No such file or directory - > /usr/lib64/ruby/gems/1.8/gems/ruby-postgres-0.7.1.2006.04.06/./postgres.so > > I found postgres.so is located at folder ruby-postgres-0.7.1.2006.04.06, > no idea why there is a "./" before postgres.so. any one could help me > out? thanks. ---- I think you need to install a version of ruby-postgres that is built against the libraries of the postgres version that you installed. try uninstalling the ruby-postgres gem and then re-installing it. Craig