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:
- wget postgresql-8.2.2.tar.gz from postgres.org
- tar -zxf postgresql-8.2.2.tar.gz
- yum install flex
- ./configure --prefix=/usr/local/pgsql --without-readline
- gmake
- gmake install
- export POSTGRES_INCLUDE=/usr/local/pgsql/include/
- export POSTGRES_LIB=/usr/local/pgsql/lib/
- 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.