search for: posgresql

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

I tried moving a PosgreSQL database to an external harddisk due to lack of space on the main harddisks. Not the ideal solution of course but it should work. However, on CentOS 7 the external harddisk is mounted under /run/media and the user. I copied the postgresql database directory and made sure it is owned recursively by...

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

...hink, so we don''t expect anything to be fully integrated with Ruby or Rails ... we just want to start with a good base. So, is Jasper the best? Are there others that look good? Here''s a short list I''ve compiled: * iReport/Jasper * DataVision * OpenRPT (only works with PosgreSQL currently) There are others, but I haven''t found any others that work on Mac OS X and have a designer tool that looks like an end user could learn to use in relatively little time. Thanks! Jen

Hello, I am planning to build a bigger Internet platform and actually evaluating Java EE and Rails. I have a lot of Java experience and I am quite new to Rails. After playing some weeks with Rails I am sure that it is a mature web framework and I really like the productivtity of Rails. One of the key advantages is that new developers will understand this platform much quicker than all the Java

On Oct 8, 2020, at 15:22, H <agents at meddatainc.com> wrote: > > ?I tried moving a PosgreSQL database to an external harddisk due to lack of space on the main harddisks. Not the ideal solution of course but it should work. However, on CentOS 7 the external harddisk is mounted under /run/media and the user. I copied the postgresql database directory and made sure it is owned recursively by...

...an issue when using px and it screws-up font re-sizing using em''s. I would also submit that there is no right or wrong in this debate, which I think was Joe''s ultimate point. The what-font-size-unit-should-I-use is the web designer''s holy war equivalent to the MySQL v. PosgreSQL debate. :-)

MySQL since version 4.1 can use utf-8 for multilangual tables, and it uses almost the same approach like PosgreSQL where Active Record API writes: ":encoding — An optional client encoding that is using in a SET client_encoding TO <encoding> call on connection." However ActiveRecord API does not mention how to set up optional client encoding for MySQL 4.1... ____________________________________...

I have the 5.x Centos DVD and loaded it. Please be gentle with me, as I'm nominally a FreeBSD kind of guy... :) Anyway, I'm trying to install Postgres and the three libraries in the subject line are missing off the base installation. I figured out how to load gcc using yum, but those libraries aren't there, and I need the former in particular in order to enable SSL for Postgres

Hi All, I set up posgresql on RedHat El4. Below are rpms I installed. [root at LinuxBox etc]# rpm -qa |grep postgres postgresql-libs-7.4.16-1.RHEL4.1 postgresql-devel-7.4.16-1.RHEL4.1 postgresql-7.4.16-1.RHEL4.1 postgresql-python-7.4.16-1.RHEL4.1 postgresql-server-7.4.16-1.RHEL4.1 Then, I did below commands to create a use...

Given that the Document Foundation has now split away from Oracle to continue the development of an independent office suite, do we have any idea which was CentOS and Red Hat are planning to go in this area - OpenOffice or LibreOffice? I know that LibreOffice is not production ready yet - they only have their first beta available, but it's just a matter of (likely a short) time before the

HI. I have instaled a WEB server with Postgresql on CentOS 6.2. PostgreSQL, versin 9.1.3 x64 from EntrrpriseDB base *.run*. PHP with PDO from YUM using reposity versions. On start apache does not get error. PHP LOG under, with PDO error. *PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib64/php/modules/pdo_pgsql.so' - libpq.so.5: failed to map segment from shared

Is there any way of preserving order of ordered factors when storing a table in PostgreSQL? I have been using PostgreSQL and the RPgSQL package to store a large table with answers such as "Strong disagreement", "Strong agreement", "Mild disagreement". "Mild agreement". When reading the table, such answers are turned into factors, apparently in

Hi guys, I am really new to these things like ROR and Postgres. When I was installing ROR 3.0 it says Successfully installed rails 3.0.0 beta 1 gem installed Installing ri document for rails 3.0.0 beta File not Found: lib This is the one which I really dont understand and dont know what to do? Help me out guys plz... And I want to configure the database with postgresql and I want to know how

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

In development and production, I''ve got postgresql constraints that prevent deleting a CaseManager if there is a Client that belongs to that CaseManager. In unit tests...and obviously in my testing db, those restrictions don''t get added. Is it wrong to test for deleting dependent records in unit tests? Craig --~--~---------~--~----~------------~-------~--~----~ You received

I have been trying for a few days to set up a basic user registration/ login system with rails 3 and nearly every single piece of documentation is outdated. Restful_authentication has several git branches, none of which appear to result in a working installation. All of them leave me with "could not find generator authenticated". With Devise: "could not find generator devise"