Our Blog

Ongoing observations by End Point 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

Popular Tags


Archive


Search our blog