similar to: Anyone done postgres replication with slony?

Whats available for doing near-realtime master->slave file replication between two CentOS systems? Cronjobs running rsync won't cut it. Ideally, I'd like something that works like SLONY-I does for Postgres databases, where all file system block level transactions on the master get replicated to the 2nd system on a 'as fast as practical' basis (a second or two of lag

Hi, Anyone got any cool tricks for converting a Rails site (in this case, a typo installation) from a mysql database to a postgresql database? I''ve got it almost working -- I''m doing a SQL dump from mysql and loading it into postgres. However, mysql does booleans as a tinyint with 0 = false and 1 = true. When I try to import that into a postgres database that expects booleans

I need to do some precise math, going to 12-14 decimal places, so I''m using BigDecimal. How can I store this in a db? I''m using postgresql 8.1.0, if that matters at all. I found a plugin [1] but it gives me the error "You have a nil object when you didn''t expect it! The error occurred while evaluating nil.each_pair," with no line number. The plugin itself

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

After upgrading to 1.1, I can''t run any unit tests. Apparently when I run rake test_units, it uses a migration to set up the database. Unfortunately when it runs the migration, it''s adding not null constraints to every field, even though I haven''t got that set up. I''m using the ruby-postgres (0.7.1.2005.12.21) adapter with PostgreSQL 8.1.0. I''m

Rails/Postgres Gurus, Question: Is it possible to use Postgres schemas within a Rails app to separate tables and data between two different apps? Problem Set: I am thinking of combining two apps. I want to share some data (certain tables) between them, but I want the migrations and other activities to be separated. I don''t want any table changes in one app to impact the other.

Hi guys, I''ve been able to successfully install the postgres adapter for a remote database machine to get rails up. My machine is running on Fedora 2. Rails version 1.1.2. Is my yml config correct? I am getting this error when I execute script/generate scaffold service_contents content : exists app/controllers/ exists app/helpers/ create app/views/spiel exists

Hello list, I''ve got a Postgres table defined as create table A ( id serial primary key, names varchar(10)[], val float[] ) Although I *could* split out the names/val arrays into one or more separate tables with one-to-many relations back to table A, the actual business problem is such that I''d prefer not to do so if I can avoid it. Is there any way of reading/writing

unix-odbc with Asterisk Realtime is one good way to use a different backend DB than MySQL. I haven't heard of "bit rot" problems running it over long times, but I'd like to if there are any. I'm particularly interested in seeing reports of Asterisk Realtime backed by Postgres. The problem with pointing dialplan DB functions like Set(DB) at unix-odbc (or any relational

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

Hello everyone, I''m trying to migrate a working app from Postgres to MySQL, and I''m trying to use a migration to get it done rather than alter all my database table creation scripts to MySQL syntax. I''ve done loads of work with Postgres, but am a real newbie with MySQL... I did a ''rake db_schema_dump'' from my Postgres app, and got a nice looking

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'm seeing a condition on FreeBSD 9.1 (built October 24th) where I/O seems to hang on any local zpools after several hours of hosting a large-ish Postgres database. The database occupies about 14TB of a 38TB zpool with a single SSD ZIL. The OS is on a ZFS boot disk. The system also has 24GB of physical memory. Smartmon tools reports no errors on any disks attached to the system, and IPMI

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

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