similar to: CentOS-4.3 and PHP PostgreSQL extension.

Hi, How should I use Activerecord to map to a database schemas with Psotgresql? Where can I find the infomation about how to use schemas in Rails? Thanks you very much Saiho __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

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?

I am getting some larger hard drives and will migrate my intranet application onto the new hard drives. I am using CentOS 4. The current setup uses one small boot volume (ext2) and the rest is partitioned into one big LVM. Does it make sense to partition /var/lib/pgsql separately? (thinking mostly in terms of performance) Craig

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

Dear fellow CentOS users, for my few hobby projects (web games + forums) I have been using CentOS 5 (then 6) with Drupal and PostgreSQL plus few custom PHP and Perl scripts written by mysef. Since PostgreSQL version delivered with CentOS package has been a bit dated, I always used the PGDG packages: # rpm -qa | grep -i pgdg pgdg-centos93-9.3-1.noarch

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

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:

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,

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

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:

All, We have a PostgreSQL 8.1.4 in the testing repository. Would everyone who has used it / is using it please reply to this thread. We want to move this to CentOSPlus (this version has been in has been in testing since May, and a version 8 has been in testing since Dec of last year). The repo file is here for testing: http://dev.centos.org/centos/4/CentOS-Testing.repo Thanks, Johnny Hughes

I have discovered that the default init script distributed with pgsql v8.1 sets the listening port to 5432 but does not enable tcp/ip connections. One must add the -i switch to the invocation line in the script. I am not sure if this is an oversight or whether there is another way to tell postmaster to start with tcp/ip listening enabled that I am unaware of. However, I thought that this

Hi All, is there an RPM for 4-1 for postgresql? I did a yum, and the latest is only 7-4 Installing: postgresql-server i386 7.4.8-1.RHEL4.1 base 3.0 M and I need at least 8-* Any ideas where to find an RPM for CentOS4-1? Cheers. Mark Sargent.

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

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

Code -------------- static void consume_results(struct pgsql_db *db) { do { if (!PQconsumeInput(db->pg)) break; if (PQisBusy(db->pg)) return; } while (PQgetResult(db->pg) != NULL); if (PQstatus(db->pg) == CONNECTION_BAD) io_remove_closed(&db->io); else io_remove(&db->io); db->querying = FALSE; if (db->queue != NULL && db->connected)

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

Greetings, A malfunctioning disk this past week accelerated a lingering decision to move to CentOS 6.x from CentOS 5.x. Most of our content is functioning and being presented as it should be. However, there appear to be php-related issues. Basic squirrelmail (a php-dependent package) works correctly. However, drupal, and other php-dependent parts that call postgresql and mysql databases of

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...

Does anyone here know of a repository that has PostgreSQL v.8 for CentOS-4? If so, where is it? Are there caveats that I should know about? Regards, Jim -- *** e-mail is not a secure channel *** mailto:byrnejb.<token>@harte-lyne.ca James B. Byrne Harte & Lyne Limited vox: +1 905 561 1241 9 Brockley Drive fax: +1 905 561 0757 Hamilton, Ontario