similar to: CentOS 4.4 - postgis / postgres Issue

I need to make a simple read-only web query page that allows the user to enter in a longitude and latitude and get a list of areas within which those coordinates occur. I have a postgis (postgresql) databases that contain shape files for county, township, range and section. I can query these databases in the following way from within postgresql in the database county county=# SELECT name_lc

Hi. I''m announcing a Rails Engine for presenting maps based on your own data, either rendered by Mapserver, or pulled directly out of geometric database tables stored by PostGIS. There''s a demo here: http://ivygis.mgxkernel.com:3000/canada which shows a tiled, draggable version of a Mapserver demo map, with mouse-sensitive park polygons and railroads (SVG in Firefox 1.5+,

Just wanted to post this in case someone else was faced with the same problem. It''s database-specific code, worse, it''s specific to a particular * version* of a particular *extension* to a particular database, wires in SQL, and uses eval on a string of data from the database! So, you know, I''m getting coal in my stocking from DHH this year. I can deal. (After the

Hi all, I'm looking for a fix in postgis, which seems to be fixed already in postgis-2.0.7-2.el7. However that package seems to be 'stuck' in the epel7-testing repository: https://koji.fedoraproject.org/koji/buildinfo?buildID=750618 https://bodhi.fedoraproject.org/updates/FEDORA-EPEL-2016-b6c229157e Is there a reason that the package is not pushed to stable yet? Or can it be

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

Hello, This post is to announce a new release of the Spatial Adapter for Rails, which is a plugin that adds support for columns of geometric types (point, linestring, polygon,etc...) to ActiveRecord. Currently the only supported databases are MySql and PostGIS. With this release, geometric columns should behave like columns of any other basic types in all areas: migration, data access, dumping

For those of you looking to add some spatial functionality to your Ruby or Ruby on Rails app, there''s a new project called GeoRuby. It''s pretty new (at v0.0.1), but the basic functionality works and it''s available under the fab MIT license. There was some interest in this on the postgis-users list, so I figured the Rails list might like to know too. Check out:

The MabLab at the University of Florida's Fort Lauderdale Research and Education Center (Davie, FL) is looking to fill an immediate opening for the position of a Biological Scientist. We are looking for an enthusiastic, highly motivated and responsible individual to join an exciting research team focused on spatial ecology, from fine-scale movement and habitat selection to range dynamics.

Hello, I've been trying every now and then to find a cross operating system solution that would let me access PostgreSQL (and PostGIS) from R, or to access R from PostgreSQL. I know of pl/r, which accomplishes the latter, but has yet to be successfully ported to Windows. Similarly, I've tried to use Rdbi and DBI, but I haven't had luck with those on Windows either for connecting to

Hi, I''m running rails 3.0.9 with activerecord 3.0.9 and have three database connections in my rails application - LDAP connection, Oracle and Postgres with PostGIS. I have installed gems GeoRuby v 1.3.4, spatial_adapter v 1.3.1, activerecord-oracle_enhanced-adapter v 1.4.0, ruby-ldap v 0.9.12 , pg v 0.14.0. With both gems the spatial_adapter seem to work well which also is the case

While upgrading Rails 2.0.2 sites to Rails 2.1.1, I encountered a weird postgres adapter problem. Although the old postgresql adapter (aka ruby-postgres) works fine with Rails 2.1.1 on my Mac dev box (running PG 8.2.6) and also works fine with Rails 2.0.2 apps on a Debian etch staging server (running PG 8.2.1), this error occurs when trying to cap deploy 2.1.1 apps on the Debian box:

Dear friends, there is a serious problem with RODBC on R from 2.6.2 to 2.8.0 on a postgresql 8.3 database. Let's say we define an empty dsn called "test", with user "postgres" and password "none". We test the connection with another application, and it works properly. When you call the database using RODBC, you get the following: >

Dear friends, there is a serious problem with RODBC on R from 2.6.2 to 2.8.0 on a postgresql 8.3 database. Let's say we define an empty dsn called "test", with user "postgres" and password "none". We test the connection with another application, and it works properly. When you call the database using RODBC, you get the following: >

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