similar to: Setting up RoR with Postgresql ---heeellpp!

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 postgres, changed the necessary settings in both the systemd unit and the

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

Help please. My first attempt at Rails, I''m trying to use PostgreSQL and I''m seeing this error. I''m also new to PostgreSQL, but the default encoding in PostgreSQL appears to be SQL_ASCII. I''m not sure if I should try and get the patch or try and change the PostgreSQL template. Sorry I''m so confused. FWIW, I''ve been a .NET MSSQL developer

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

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

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:

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

We have an application Ruby on rails, which fires a number of queries to the database. I Suspect it is connection timeout error or something When we run the application in development mode, it works as expected. However when we switch to Production mode, we get the following error in Postgre console: -------------------------- LOG: could not receive data from client: No connection could be made

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

Hi guys, I need your help. Here is my database.yml: development: adapter: postgresql database: db username: username password: mypassword # Connect on a TCP socket. Omitted by default since the client uses a # domain socket that doesn''t need configuration. Windows does not have # domain sockets, so uncomment these lines. host: 192.168.22.1 (this is a remote ip in

Is there any reason why AR has never supported foreign-key constraints? I can understand the lack of support for triggers and stored procedures since they are highly dependent on the database to create a wrap API around them. But this is not the case for foreign keys. This is specially important for open-source projects like Redmine/Chiliproject and Gitorious where you shouldn''t be

Me again! I have a recipe that looks like: class postgresql { file { pg_hba_conf: name => "/var/lib/pgsql/data/pg_hba.conf", source => "puppet://puppetmaster/files/workstations/common/var/lib/pgsql/data/pg_hba.conf", owner => postgres, group => postgres, mode => 600, subscribe => [ Package[postgresql] ],

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

Hi List, I am trying to understand what After= means in a unit file. Does it mean after the specified target is up and operational or only that the target has been started? I have something that needs postgres but postgres needs to be operational not just started. Sometimes it can take a bit for postgres to become operational. Thanks, Steve

Puppet 3.3.1 // CentOS release 6.4 (Final) rpm -qa | grep puppet puppetlabs-release-6-7.noarch puppet-3.1.1-1.el6.noarch puppetdb-1.3.0-1.el6.noarch puppet-server-3.1.1-1.el6.noarch puppetdb-terminus-1.3.0-1.el6.noarch Installed from yum packages: Running Transaction Installing : puppetdb-1.3.0-1.el6.noarch

Signed-off-by: Joey Boggs <jboggs at redhat.com> --- installer/modules/ovirt/manifests/freeipa.pp | 8 ++++---- installer/modules/ovirt/manifests/postgres.pp | 12 ++++++------ 2 files changed, 10 insertions(+), 10 deletions(-) diff --git a/installer/modules/ovirt/manifests/freeipa.pp b/installer/modules/ovirt/manifests/freeipa.pp index e5de852..f91cd43 100644 ---

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

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

Hi, I''m having difficulty installing the "postgres" gem. postgres-pr installed fine, but whenever I run: sudo gem install postgres I get: ERROR: While executing gem ... (RuntimeError) ERROR: Failed to build gem native extension. Gem files will remain installed in /usr/lib/ruby/gems/1.8/gems/postgres-0.7.1 for inspection. I''ve had a bit of a poke around, and