Help with postgres...

6 views
Skip to first unread message

Jason Patrick Agujo

unread,
Nov 24, 2009, 3:30:38 AM11/24/09
to ruby...@googlegroups.com
im trying to learn a different database connection aside from MySQL. a friend suggested that i use "postgres" im not sure if there is a compatibility issue (like the one with MySQL with rails 2.2) but i get an error when i try to start the ruby server (ruby script/server).

steps taken:
installed ruby (1.8.6)
updated gems (1.3.5)
installed rails (2.3.4)
installed postgreSQL
installed gem ruby-postgres (0.7.1.2006.04.06)
created the generic code
performed "ruby script/server" just to see if any error comes up

got a succession of errors of missing dll (libpq & msvcr70) i was able to download it from the net but now im getting the error of "the procedure entry point PQescapeBytea could not be located in the dynamic link library libpq.dll"

please help me out and thank you for your time and consideration

Erol Fornoles

unread,
Nov 24, 2009, 9:09:55 AM11/24/09
to Philippine Ruby Users Group (PRUG/PhRUG)
Instead of downloading, you can copy the DLL's from your PostgreSQL
install directory to your Ruby's bin directory instead.

Greg Moreno

unread,
Nov 24, 2009, 12:45:32 PM11/24/09
to ruby...@googlegroups.com
> got a succession of errors of missing dll (libpq & msvcr70) i was able to
> download it from the net but now im getting the error of "the procedure
> entry point PQescapeBytea could not be located in the dynamic link library
> libpq.dll"

Looks like a wrong dll version. Look libpql.dll in your postgres
installation directory. Then include the directory where you found it
in your PATH.

- Greg

Joseph Emmanuel Dayo

unread,
Nov 24, 2009, 5:10:54 AM11/24/09
to ruby...@googlegroups.com
seems you tried to use an outdated postgre client dll

--

You received this message because you are subscribed to the Google Groups "Philippine Ruby Users Group (PRUG/PhRUG)" group.
To post to this group, send email to ruby...@googlegroups.com.
To unsubscribe from this group, send email to ruby-phil+...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/ruby-phil?hl=en.

Jason Patrick Agujo

unread,
Nov 25, 2009, 12:56:06 AM11/25/09
to ruby...@googlegroups.com
ill try to set it up later, im now learning on fedora 12 flatform and it was easier to install. thank you guys for the info.
Reply all
Reply to author
Forward
0 new messages