similar to: Linux - Rails - PostgreSQL partitioning

Hi, A bit off-topic, but I''m about to set up a remote Linux server for Rails, with postgres and probably Lighttpd. The server has two 120GB hard drives, one of which will just be for nightly backups of the other. I don''t intend to have any untrusted user accounts on the server. The server will be dedicated to my own applications. I''ll want to support lots of www

I am in a holding pattern while client decides upon changes and so I am working some things out internally so it seems to me that indexing frequently searched table fields might be useful. I am using postgres and via postgres, I have added an index to one of my tables whose index is the same name as the column name. The ''find'' screen I am using this to judge populates a number

I'm building a database/application server with a Dual-Opteron 64 bit system. I need to run PHP4, Apache, and Postgres 8.1, but I'm having conflicts with Postgres 8.1 and PHP 4 that comes with CentOS. History: 1) I installed Apache and PHP with yum. 2) I then installed PostgreSQL 8.1 RPMs from the PG website. 3) Then, I tried to install php-pgsql with yum - and it didn't work,

Hi all, I installed Rails 3.0 + PostgreSQL 8.4. Installed the gem postgre-pr I added " gem ''postgres-pr'' " to my Gemfile I defined my database.yml with: # PostgreSQL 8.4 development: adapter: postgresql encoding: unicode database: testdb pool: 5 username: test password: ****** I run rails server which starts, but application environment returns this error:

Dear list, I have a small issue with dovecot talking to a postgresql server: If my postgres server get restarted, dovecot fails to reconnect to the postgres server. I run dovecot 0.99.9.1 (which is actually a cvs version of dovecot, of may 9 2003) I have the same postgres version for the server as I use for the libraries. Is it hard to get auto-reconnect to work? Kind regards, Maikel

When i try it start my ruby server i get a error that looks like rails server Could not find pg-0.12.2 in any of the sources Run `bundle install` to install missing gems. I dont know what to do Thanks for all the help -- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this

Hello everyone. I''m starting with Rails going through the obvious "Getting Started with Rails" guide: http://guides.rubyonrails.org/getting_started.html Everything goes smoothly until the rake db:create command, which returns this strange error message referring to a gem that apparently doesn''t exist: Please install the postgresql adapter: `gem install activerecord-

Hello Everybody, I am trying to configure Asterisk to listen into a database which is created in PostgreSQL. Whenever asterisk starts up, it is unable to connect to the pg database and gives the following error: [cdr_pgsql.so] => (PostgreSQL CDR Backend) == Parsing '/etc/asterisk/cdr_pgsql.conf': Found Jun 24 21:20:53 DEBUG[1074494336]: cdr_pgsql.c:284 my_load_module: cdr_pgsql:

Hi all I am just about to start a project using rails and am trying to setup my enviroment with postgres as the database. I have installed postgres 8.3.1 from source and am now having trouble installing the ruby- postgres gem. The following is the output trace I am getting, looks like a problem with headers/includes, any help is greatly appreciated. Thanks Simon sudo gem install ruby-postgres

OS - CentOS4 PostgreSQL = 8.0.3 I think that I need to locate a custom pam module to use in pg_hba.conf that will allow phpPgAdmin to authenticate users against /etc/password (shadow). I cannot seem to find a straight forward reference to such a beast either in the documentation or on the web. The pam modules that I have found through google seem to be intended to allow one to authenticate

I get these errors : gem install pg -- --with-pgsql-include-dir=''/usr/include/pgsql'' -- with-pgsql-lib-dir=''/usr/lib/pgsql'' Building native extensions. This could take a while... ERROR: Error installing pg: ERROR: Failed to build gem native extension. /usr/bin/ruby extconf.rb --with-pgsql-include-dir=/usr/include/pgsql -- with-pgsql-lib-dir=/usr/lib/pgsql

Hi there, I''ve been trying for a few hours now to get RoR and postgresql talking - but I''m very confused about what''s going on (I''m running windows btw). I haven''t created a database in postgresql (I''m assuming that RoR will do that?) my database.yml looks like this: production: adapter: ruby-postgres database: rails_production

Hi there. I''m having a problem here: I''m trying to install pg-0.7.9.2008.10.05 (The last version), but I get this... PATH=/opt/PostgreSQL/8.3/bin:$PATH gem install pg Building native extensions. This could take a while... ERROR: Error installing pg: ERROR: Failed to build gem native extension. /usr/local/bin/ruby extconf.rb install pg checking for main() in -lpq...

I need to enable pg support on one of my CentOS servers. I know nothing about PHP but DRUPAL requires a DB backend and we have standardized on pg rather than mysql. The PHP.net page devoted to the subject of pg says that to enable pg support PHP must be built with the flag "--with-pgsql[=DIR]" and that the required support extension must be loaded via the /etc/php.ini file with the

gem install pg give the following error, please help how can i solve this Building native extensions. This could take a while... ERROR: Error installing pg: ERROR: Failed to build gem native extension. /home/saravanan/.rvm/rubies/ruby-1.9.3-p194/bin/ruby extconf.rb checking for pg_config... yes Using config values from /usr/bin/pg_config checking for libpq-fe.h... yes checking for

I work on a fairly large website that uses Ruby 1.8.6 and Rails 1.2.3. We cannot upgrade as it will hopelessly break our code. We are working on a new version in Java but for the next year at least we are stuck with the legacy system. We use the latest version of Postgresql for the database using the postgres-pr gem. I am attempting to implement cron tasks within the system using Rufus Scheduler,

Hi guys, need some clarification on whether there is a config file sourced by the init script to determine where PGDATA is located. Right now, it seems like it's not sourced from anywhere by located on the init file itself. Appreciate if you guys can let me know if this is the correct place for altering it.

I've been using RPMs for PG 8.1 from CentosPlus for some time now. I've been very happy with them, and they've been wonderfully stable. http://mirror.centos.org/centos/4/centosplus/x86_64/RPMS/ But now 8.2 is out. Are there any plans to support PG 8.2 in CentosPlus, or should I go ahead with RPMS directly from PG?

Is there any reason to avoid using postgresql for small web apps? That is, is it''s overhead so large that the lighter MySQL will work substantially better for small apps on small machines? Or are they very similar in performance and configuration? I''ve used MySQL but postgresql has its appeals and I''m wondering if I need to keep MySQL around at all. On the other

please help me in this... I am unable to install pg gem file [root@vdimc04 ~]# gem install pg -v ''0.12.0'' /usr/local/lib/ruby/1.9.1/yaml.rb:56:in `<top (required)>'': It seems your ruby installation is missing psych (for YAML output). To eliminate this warning, please install libyaml and reinstall your ruby. Fetching: rake-compiler-0.8.1.gem (100%) Fetching: