similar to: Multiple Postgres idle connections

Bonjour à tous, Je développe une grosse application en Rails 3.2.7 qui est connecté à une BD Postgres 8.4 installée sur la même machine. L''application s''exécute sur Apache avec le module Passenger. L''application est constamment utilisée par une centaine d''utilisateurs et ne pose aucun problème pendant plusieurs heures puis, d''un coup, Rails ne

Hello, I am trying to use the paperclip plugin in my rails app to upload images for posts. I am using Rails 2.0.2 and ruby 1.8.7 on Ubuntu 10.04 os for project specific purposes. I am referring to the following tutorials for this :- 1. http://railscasts.com/episodes/134-paperclip?view=comments 2. http://jimneath.org/2008/04/17/paperclip-attaching-files-in-rails.html I did a git clone on the

Hello all, with great difficulty , I guess I have finally been able to find the appropriate git commit of paperclip which would suit my project''s config which is Ruby 1.8.7 and rails 2.0.2. I am trying to implement a POC before I integrate paperclip in my project. The POC is basically implementing each post with an appropriate image beside it. It seems to pretty much work, its just

Hello all, I am trying to implement a POC wherein I can post a message + image and get the same working via AJAX to display them both for each new entry without the page reloading. I am using a config of Ruby 1.8.7 and Rails 2.0.2 for project specific purposes.. I am also using a pretty old paperclip commit from github for this....I had to suit my proj config requirements mentioned previously..

Hello All, I''m looking to see if I can coerce ActiveRecord to connect to a remote Postgres server via ssl. Htere seems to be a way to do it with MySQL, but I don''t see similar capability in the Postgres Adapter. Has anyone been able to force ActiveRecord to use SSL to connect to a remote Postgres server? Any help would be appreciated because I''m stuck. Mike

Hello all, I am using Rails 2.0.2 and Ruby 1.8.7 and I need to make use of rack middleware for integrating an ajax file upload plugin(https:// github.com/valums/file-uploader) with paperclip in Rails( As given in this tutorial:- http://mooooooooooo.wordpress.com/2010/12/03/paperclip-valums%E2%80%99s-file-uploader-and-middleware-continued/). I have referred to the rack-middleware Railscast by

Hi, Since 1-2 weeks I get a lot of "PGError: server closed the connection unexpectedly" errors and I cant figure out where it is coming from. Haven''t found any solution on Google either. My setup is: Postgres Rails 2.3.9 Passenger Ruby 1.9.2 Thought it might be passenger, so I stopped the spawning, it seems to have helped a bit, but I still get these errors. The errors are

People, I got rails talking to PostgreSQL 8.0 on my Mac! Once upon a time: I''m on a Mac. I want to use postqreSQL 8.0 to backend my rails. I tried a gem install... zmac11:/cd/rubythings/ruby-postgres oracle$ zmac11:/cd/rubythings/ruby-postgres oracle$ zmac11:/cd/rubythings/ruby-postgres oracle$ zmac11:/cd/rubythings/ruby-postgres oracle$ gem install postgres ERROR: While executing

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

I have been struggling for hours trying to connect Rails to postgresql. I have trawled google results - all to no avail! I have installed the postgres gem but it doesn''t appear to install properly: # gem install postgres Attempting local installation of ''postgres'' Local gem file not found: postgres*.gem Attempting remote installation of ''postgres''

I have dovecot running with postgres backend. I am exceeding my maximum database connections (currently 40) with dovecot 0.99.10.9 and postfix and was wondering if dovecot has a parameter to limit the total number of database connections that it will create. Dan

If management server has ipv6 enabled and postgres is not configured to allow localhost access via ::1 the postgres service will fail. --- installer/modules/ovirt/manifests/postgres.pp | 8 +++++++- 1 files changed, 7 insertions(+), 1 deletions(-) diff --git a/installer/modules/ovirt/manifests/postgres.pp b/installer/modules/ovirt/manifests/postgres.pp index 36bcdc0..12b7764 100644 ---

Hello people... In the rails2.pdf Dave T says: Rails works with the DB2, MySQL, Oracle, Postgres,... The database drivers are all written in C and are primarily distributed in source form. Then he lists this site: http://ruby.scripting.ca/postgres/ Then he says, There is a pure-Ruby version of the Postgres adapter available. Download postgres-pr from the Ruby-DBI page at

I''m starting to look at postgres because I''m going to need it for its GIS extensions. But I run in into a problem when trying to install the ruby-postgres gem. I get this error Building native extensions. This could take a while... ERROR: Error installing ruby-postgres: ERROR: Failed to build gem native extension. blah blah blah etc postgres.c:31: error: conflicting types

Give this one a try which will require the user/hosts permissions to be setup prior to starting postgres --- installer/modules/ovirt/manifests/postgres.pp | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/installer/modules/ovirt/manifests/postgres.pp b/installer/modules/ovirt/manifests/postgres.pp index c46b360..381d67c 100644 ---

After installing One-Click Rails and Postgres 8.1 on Windows, I tried to install the pure-ruby postgres adapter by running gem install postgres-pr It installed fine, and I can do this: G:\InstantRails\rails_apps>irb irb(main):001:0> require "rubygems" => true irb(main):002:0> require "postgres" => true But then if I specify in my config/database.yml to use

--- installer/modules/ovirt/manifests/postgres.pp | 7 ++++++- 1 files changed, 6 insertions(+), 1 deletions(-) diff --git a/installer/modules/ovirt/manifests/postgres.pp b/installer/modules/ovirt/manifests/postgres.pp index 6620a88..a711e32 100644 --- a/installer/modules/ovirt/manifests/postgres.pp +++ b/installer/modules/ovirt/manifests/postgres.pp @@ -38,10 +38,15 @@ class

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 Firstly apologies but i have to install an app that uses postgres but i am more a MySQL/Oracle guy so i maybe doing something really wrong here.. I am following instructions for creating a DB user and encountering this # createuser -ADP -U postgres foo Enter password for new user: Enter it again: createuser: could not connect to database template1: FATAL: IDENT authentication failed for

Hi I''m building a Rails app that intereacts with several legacy databases, all on Postgres 7.4 and running into a few quirky problems. I seem to have a lot of inconsistencies w/ quoting field names in Postgres. I''ve written another app from scratch using Postgres and encountered quoting trouble there too. But it seemed tied to the machine I was serving the app from.