similar to: Postgres-pr interface not found

Hello, I''m a newbie to rails and I am trying to do the Demo in the November Issue of Linux Journal. Things go fine go fine until I try to connect to my Postgres database (ver 8.1). At this point I get the following error message ---- RoR error and trace back ---- PGError in Admin#index could not connect to server: Permission denied Is the server running on host "localhost"

Hello to everyone, I have a problem that is giving me a headache, and trying to do a project in Ruby on Rails and I need to connect with a Data Base that is en Postgres, the truth is that I didn’t think that it was so hard to connect a DB with postgres because I was working with Msyql and everything was easy. This are the thinks that I have install in my computer. 1. Debian GNU/Linux, kernel

Hi all, my computer decide to take a dirt nap today so I am trying to relaod rails on another machine and I am getting this error message which I can''t make heads or tails about: no such file to load -- postgres RAILS_ROOT: ./script/../config/.. c:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `gem_original_require''

When I run the rake db:migrate command, I get this: C:\testror\depot>rake db:migrate --trace (in C:/testror/depot) ** Invoke db:migrate (first_time) ** Invoke environment (first_time) ** Execute environment ** Execute db:migrate rake aborted! 182: Le systÞme d''exploitation ne peut pas exÚcuter %1. - c:/ruby/ lib/ruby/gem

First of all, I''d like to do what I''ve seen several others here do: thank Ezra and any other contributors for producing a really great plugin. Even though I''m having some minor problems, this is all so approachable and easy to work with and dig into... I hate to think of the hoops you''d need to jump through (both as creator of such a system and as a user) to

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Anyone know what''s going on with ActiveRecord Edge and 1.2RC1 unit tests. I get 13 failures from the "async_exec" method call. ie: test_callback_rollback_in_save(ConcurrentTransactionTest): ActiveRecord::StatementInvalid: NoMethodError: undefined method `async_exec'' for #<PGconn:0xb75a8754>: SET

hello list, yesterday i installed a fresh rails installation with a proper upgrade of gem to version 1.0.1 i saw, there is still a gem package to support postgresql known as postgres-0.7.9.2008.01.09 on rubyforge, its the newest one of stable postgres support for ruby additionally i installed, of course, a the postgres database on my machine to C:\Programme\PostgreSQL\8.2 after setting up a new

Figured it out chaps..not to worry!!! -- Regards Andrew On 05/03/07, Andrew Madu <andrewmadu-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> wrote: > > Hi, > further to my additional email the gem build for postgres did not work, so > I downloaded and copied postgres.so into: > > C:\pgRails\lib\ruby\site_ruby\1.8\i386-msvcrt > > Again, how do I point rails to using this

Is there some special magic that needs to be performed so that the C-based postgres extension library works with the Rails console? I have installed the postgres extension library (replacing the pure Ruby version: postgres-pr) from <http://ruby.scripting.ca/postgres/> Everything works great from WEBrick, but as soon as I fire up the console and try to use it, I get a bus error:

Hi, I''m trying to write a new postgresql adapter which interited the old postgres adapter and I try to use the PGconn class, But I find out I can''t access to some of the exported functions in postgres.so (I''m using LINUX) In fact, only the methode export with rb_define_singleton_method can be used, only function s exported with rb_define_method, the PGconn ruby class

Hi, Im new to both Ruby and Rails, though am impressed by both. I am however stuck on a problem, when trying to run a demo. I''ve setup a postgresql database with a cookbook demo as per OnLamp, returned is the following error message: LoadError in Recipe#new No such file to load -- postgres script/server:48 Has anyone come across this error before? Anyone know how I should go about

Hi! I want to escape binary data correctly either manually or using some pre-defined function that does this for me! I have found on the web: PGconn.escape_bytea but I only get "undefined method". Any ideas, what is the correct way of doing this my self? I''m using Rails (WEBrick) under Windows XP with postgre-pr 0.4.0 I have tried: s_buffer = s_buffer.gsub(/['']/,

I just ported my Rails app from OSX/Linux to Windows XP for the first time. I am running PostgreSQL 8.0 and the postgres-pr 4.0 adapter. Some of the queries in my Rails app work, but for others I get a weird error: ArgumentError: Invalid Ruby/cstring: select sa.name as activity_name, max(sah.created_at) as created_at from site_activity_histories sah, site_activities sa where

Hi everybody, I''m experiencing trouble when trying to use ruby-postgres with a legacy database I need access to. To me it seems the problem is the VARCHAR columns used there as primary keys. On a simple me = User.find(''PS12345'') I get a type error exception with the message ''can''t convert String into Integer''. The trace is:

I forgot to take out the portion that would read in the voicemail boxes from the text file. If you want to leave it in then you could have some voicemail boxes defined in the text voicemail.conf. I do not, so I have removed it. Below is the new patch: *** app_voicemail.c 2004-06-23 07:55:54.000000000 -0600 --- app_voicemail.c.new 2004-06-23 07:55:47.000000000 -0600 *************** *** 49,61 ****

Hello all, I am just getting going on building my system, but I thought I'd send you all a patch that I wrote so the command: show voicemail users issued from the CLI works properly when there is a postgres backend for the voicemail. The current version of the app does not display the voicemail boxes found in a database. It is called in the load_config function. I haven't done

Hi List, first of thank you Ezra for BackgroundRB. Very cool plugin indeed! This is a public service FYI. In case you are running postgres as your database backend and you are seeing the following errors in your backgroundrb.log: ActiveRecord::StatementInvalid: NoMethodError: undefined method `async_query'' for #<PGconn:0x22ed648>: You are using the postgres-pr adapter

I wanted to fix some things up in the trunk, so I set up the databases and ran the unit tests. A bunch fail for postgres, and even more error out. I know of two postgresql adapters: postgres-pr and ruby-postgres. Strangely, they each fail different tests. So if I want to fix things up, which one should I be using? For that matter, which adapter should I be using for production? Finding out

All of the tutorials and the Agile book use MySQL and I''ve got that working. I am now trying to use PostgreSQL and can''t seem to get going. Is my problem the db setup in postgresql? I have installed postgres-pr The error message when I try to access http://localhost:3000/clients when using PostgreSQL (MySQL works fine) ActiveRecord::StatementInvalid (RuntimeError: ERROR

I''ve written a simple Rails migration that adds an index to an existing Postgres table: class AddIndexToEvents < ActiveRecord::Migration > def change > add_index :sf_events, :account_id > end > end However, when I run the migration, it fails due to a syntax error on the CREATE INDEX line. I''m expecting some SQL like this to be generated: CREATE INDEX