• Home

  • Custom Ecommerce
  • Application Development
  • Database Consulting
  • Cloud Hosting
  • Systems Integration
  • Legacy Business Systems
  • Security & Compliance
  • GIS

  • Expertise

  • About Us
  • Our Team
  • Clients
  • Blog
  • Careers

  • CasePointer

  • VisionPort

  • Contact
  • Our Blog

    Ongoing observations by End Point Dev people

    Blog posts by

    Greg Sabino Mullane

    Using tail_n_mail after hours

    October 23, 2017

    Working on production systems

    September 27, 2017

    Postgres migrating SQL_ASCII to UTF-8 with fix_latin

    July 21, 2017

    Amazon AWS upgrades to Postgres with Bucardo

    June 6, 2017

    The mystery of the disappearing SSH key

    April 13, 2017

    Postgres WAL files: best compression methods

    March 28, 2017

    Postgres statistics and the pain of analyze

    December 7, 2016

    Postgres connection service file

    October 26, 2016

    Postgres schema differences and views

    October 14, 2016

    pg_healer: repairing Postgres problems automatically

    September 19, 2016

    Disabling Postgres constraints for pg_dump

    July 13, 2016

    Postgres migration speedup with table change analysis

    June 13, 2016

    Bucardo replication workarounds for extremely large Postgres updates

    May 31, 2016

    Postgres concurrent indexes and the curse of IIT

    April 28, 2016

    MediaWiki extension EmailDiff: notification emails improved

    March 11, 2016

    Bonked By Basic_auth Because Bcrypt

    February 9, 2016

    Postgres 9.5: three little things

    January 28, 2016

    MediaWiki major upgrade process

    January 13, 2016

    Postgres checksum performance impact

    December 31, 2015

    Broken wikis due to PHP and MediaWiki “namespace” conflicts

    November 9, 2015

    MediaWiki extension.json change in 1.25

    October 17, 2015

    Pgbouncer user and database pool_mode with Scaleway

    September 24, 2015

    Bucardo replication from Postgres to sqlite and mariadb using pgbench

    August 12, 2015

    Selectively firing Postgres triggers

    July 15, 2015

    How fast is pg_upgrade anyway?

    July 1, 2015

    MediaWiki complete test wiki via cloning

    June 6, 2015

    Postgres “unsupported frontend protocol” mystery

    May 28, 2015

    Connected to PgBouncer or Postgres?

    May 18, 2015

    Postgres searchable release notes—​one page with all versions

    March 11, 2015

    Postgres ON_ERROR_ROLLBACK explained

    February 24, 2015

    Postgres pg_dump implicit cast problem patched!

    February 16, 2015

    Postgres custom casts and pg_dump

    February 10, 2015

    One-time password SSH solutions

    February 2, 2015

    Postgres session_replication role - Bucardo and Slony’s powerful ally

    January 28, 2015

    SSH one-time passwords (otpw) on chromebook

    January 21, 2015

    DBD::Pg escaping placeholders with backslashes

    January 12, 2015

    DBD::Pg: one ping to rule them all

    January 7, 2015

    Bucardo replication trigger enabling

    December 22, 2014

    When Postgres will not start

    November 24, 2014

    Finding specific Git commit at a point in time

    November 10, 2014

    Prevent MediaWiki showing PHP version with new extension: ControlSpecialVersion

    October 29, 2014

    Postgres copy schema with pg_dump

    October 9, 2014

    MediaWiki minor upgrade with patches

    October 2, 2014

    Solving pg_xlog out of disk space problem on Postgres

    September 25, 2014

    Ubuntu upgrade gotchas

    August 16, 2014

    PostgreSQL conflict handling with Bucardo and multiple data sources

    July 24, 2014

    Version differences via GitHub from the command line

    July 9, 2014

    Version 5 of Bucardo database replication system

    June 23, 2014

    DBD::Pg, array slices, and pg_placeholder_nocolons

    May 25, 2014

    git checkout at a specific date

    May 19, 2014

    MediaWiki extensions and wfLoadExtensionMessages

    May 9, 2014

    Custom plans prepared statements in PostgreSQL 9.2

    April 28, 2014

    Chrome, onmousemove, and MediaWiki JavaScript

    April 18, 2014

    DBD::Pg prepared statement change

    February 28, 2014

    DBD::Pg 3.0.0 and the utf8 flag

    February 19, 2014

    Perl PostgreSQL driver DBD::Pg 3.0.0 released

    February 7, 2014

    Changing Postgres pg_dump warnings into errors with sed

    October 28, 2013

    Automating checking for new versions of PostgreSQL

    July 3, 2013

    Debugging obscure Postgres problems with strace

    June 20, 2013

    SSH ProxyCommand with netcat and socat

    April 24, 2013

    Detecting table rewrites with the ctid column

    November 26, 2012

    Postgres alter column problems and solutions

    November 9, 2012

    Postgres system triggers error: permission denied

    October 25, 2012

    PL/Perl multiplicity issues with PostgreSQL: the Highlander restriction

    September 4, 2012

    Postgres log_statement='all' should be your default

    June 30, 2012

    College District presentation

    June 14, 2012

    Detecting Postgres SQL Injection

    June 10, 2012

    Monitoring many Postgres files at once with tail_n_mail

    May 8, 2012

    Puppet custom facts and Ruby plugins to set a homedir

    March 21, 2012

    The Mystery of The Zombie Postgres Row

    March 14, 2012

    Perl, UTF-8, and binmode on filehandles

    February 21, 2012

    Tracking down PostgreSQL XYZ error: tablespace, database, and relfilnode

    February 14, 2012

    Protecting and auditing your secure PostgreSQL data

    January 30, 2012

    Finding PostgreSQL temporary_file problems with tail_n_mail

    November 10, 2011

    Using the new version of imapfilter with mutt

    October 17, 2011

    Viewing schema changes over time with check_postgres

    October 5, 2011

    PostgreSQL Serializable and Repeatable Read Switcheroo

    September 28, 2011

    Bucardo PostgreSQL replication to other tables with customname

    September 5, 2011

    PostgreSQL log analysis / PGSI

    August 19, 2011

    Changing postgresql.conf from a script

    August 10, 2011

    Debian Postgres readline psql problem and the solutions

    August 2, 2011

    DBD::Pg UTF-8 for PostgreSQL server_encoding

    June 20, 2011

    MongoDB replication from Postgres using Bucardo

    June 12, 2011

    Bucardo multi-master for PostgreSQL

    June 6, 2011

    Postgres Bug Tracking - Help Wanted!

    May 29, 2011

    DBD::Pg and the libpq COPY bug

    May 13, 2011

    NOTIFY vs Prepared Transactions in Postgres (the Bucardo solution)

    May 3, 2011

    Postgres query caching with DBIx::Cache

    April 25, 2011

    DBD::Pg query cancelling in Postgres

    April 4, 2011

    Postgres Build Farm Animal Differences

    March 29, 2011

    check_postgres without Nagios (Postgres checkpoints)

    January 21, 2011

    DBD::Pg, UTF-8, and Postgres client_encoding

    January 13, 2011

    SSH config wildcards and multiple Postgres servers per client

    January 7, 2011

    Upgrading old versions of Postgres

    October 11, 2010

    Postgres configuration best practices

    September 27, 2010

    Listen/Notify improvements in PostgreSQL 9.0

    September 21, 2010

    Perl Testing - stopping the firehose

    September 13, 2010

    Tail_n_mail and the log_line_prefix curse

    August 6, 2010

    pgcrypto pg_cipher_exists errors on upgrade from PostgreSQL 8.1

    June 10, 2010

    Postgres Conference — PGCon2010 — Day Two

    May 24, 2010

    Page 1 of 2 • Next page