Tag Archives: postgresql

Fedora 29 / pgadmin4.3 Bug: ‘psycopg2.extensions.Column’ object has no attribute ‘_asdict’

There’s a bit of a lag in the Fedora RPMs from PostgreSQL’s repositories, so I thought I’d post this up in case anyone else out there runs into the error message in the subject of this post. To fix it … Continue reading

Posted in Information Technology | Tagged , , | Leave a comment

Installing PL/R on RHEL/CentOS 6 with PostgreSQL 9.4

It’s pretty simple, but it involves building software from source and the lack of any explicit documentation for a typical RHEL/CentOS 6 system using the PostgreSQL RPMs was something of a pain in the butt, so here’s the process: First, make sure you take … Continue reading

Posted in Information Technology | Tagged , , , , | Leave a comment

Reconfiguring Java for R

If anyone should attempt to create a connection to a database using the Java Database Connectivity (JDBC) package in R, that person might encounter something such as the following: > library(RJDBC) Loading required package: DBI Loading required package: rJava > … Continue reading

Posted in Information Technology | Tagged , , | Leave a comment

Installing the TIGER Geocoder with RHEL 6.6, PostgreSQL 9.4, PostGIS 2.1.7, and the TIGER 2013 Census Data

Yeah, I know we’re stuck with the TIGER 2013 census data, but the 2014 data doesn’t work easily with PostGIS 2.1.7; PostGIS 2.2, which is still in development, will support the 2014 dataset.  So, for now, we’re using the 2013 … Continue reading

Posted in Information Technology | Tagged , | 2 Comments

Restoring or Migrating OTRS to a New System

The Process (OTRS 4.0.8 on Fedora 21 Server with PostgreSQL) On the original system (from which you are migrating), execute the OTRS backup utility (as described here) and make the resulting tar.gz archive available to the target system (to which … Continue reading

Posted in Information Technology | Tagged , , | Leave a comment