Migrate from Heroku Postgres to Crunchy Bridge

Craig announces a new tool for automatically migrating Heroku Postgres databases to Crunchy Bridge.

Postgres Not Starting: The Case of the Missing Output

Greg debugs Postgres that is not starting and there are no logs, no pg_ctl start up file, and no output anywhere.

PostGIS Clustering with K-Means

Paul has a primer on using clustering in PostGIS with the K-means algorithm. He uses a global population density map and offers some tips for geocentric and weighted clustering.

The Rest is History: Investigations of WAL History Files

Brian steps through reviewing WAL history files and a sample recovery scenario.

Connecting QGIS to Postgres and PostGIS

Elizabeth reviews the basics of how to use Postgres and PostGIS together with QGIS. She includes instructions for loading data from QGIS into Postgres, going the other way and loading Postgres data into QGIS, and writing layers in QGIS using SQL.

Upcoming events

Crunchy Data has team members at these upcoming events:

USDA HQ Tech Expo, Washington, D.C., March 12 

Nordic PGDay, Oslo, Norway, March 12

pgDay Paris, March 14

PGDay Chicago, April 26

Red Hat Summit, Denver, May 6

PyCon US, Pittsburg, May 17

KubeCon NA, Salt Lake City, November 12