Tags » PostgreSQL

FreeBSD and pg_upgrade

Thank you kreynolds, your post makes my current job look dead easy. I want to upgrade PostgreSQL from 9.3.12 to 9.5.4, and after checking through all of the… 371 more words

Tech

Easy clock dimension table

We’re currently redesigning our data warehouse, and we’re experimenting with a clock (or time, or time-of-day) dimension to represent the time of day, separate from the date dimension we already use. 347 more words

PostgreSQL

Installing PostgreSQL 9.5 and PostGIS 2.2 on Fedora 24

Here’s the easiest way to get a very up-to-date installation of PostGIS up and running quickly.  First up, set up the Postgres 9.5 repository straight from Postgres: 390 more words

OSGeo

Esri enterprise geodatabase and PostGIS database

PostGIS is an amazing extension to PostgreSQL which makes it possible to manage geospatial data very efficiently. Just in several mouse clicks, after installing the PostgreSQL for your operating system and the PostGIS extension, you will be able to create databases and load geospatial datasets into it for managing later on. 429 more words

ArcGIS Desktop

Installing PostgreSQL on Fedora Core

Surprisingly there are still environments that don’t automate system deployments via Ansible. Although they are fewer and further apart they are still a part of my life; so I need to create a little cheatsheet reminder for myself on how to install PostgreSQL on Fedora Core. 328 more words

PostgreSQL

PostgreSQL core hacking

Following tutorial explains PostgreSQL debugging technique.

1.Getting The Source via Git: Make a clone of the official mirror:
$ git clone git://git.postgresql.org/git/postgresql.git

git clone git://git.postgresql.org/git/postgresql.git… 451 more words

Update table with Spatial joins in PostGIS

Oddly enough, I found doing a spatial join between point and polygon geometries in PostGIS befuddling enough to bother documenting the process.

Data

Two data tables in a PostGIS-enabled PostgreSQL database: 804 more words