Blog: Hacks o’Clock (Quinn Weaver)

213 blogs updated: 39 min. ago
BDR talk by Mark Wong of 2nd Quadrant
In the Bay Area? This Wednesday, 2018-12-12, Mark Wong from 2nd Quadrant talking about BDR (Bi-Directional Replication, a form of multi-mast...
07-12-2018 00:24:00 Hacks o’Clock (Quinn Weaver) PostgreSQL
Remember your history
PostgreSQL keeps track of which WAL files go with which timelines in small history files. Each time you make a base backup, a history file i...
31-10-2018 07:13:02 Hacks o’Clock (Quinn Weaver) PostgreSQL
It's just an expression
PostgreSQL has lots of great features for text search. In particular, there are a bunch of ways to do case-insensitive searches for text: Th...
30-10-2018 08:18:30 Hacks o’Clock (Quinn Weaver) PostgreSQL
How to set up scram-sha-256 authentication in PostgreSQL
md5: everyone uses it. But it's insecure unsuitable for authentication or password storage. PostgreSQL 10 adds support for SCRAM SHA-256 aut...
24-10-2018 09:13:44 Hacks o’Clock (Quinn Weaver) PostgreSQL
Locks talk this Friday, at PostgresOpen! (2018-09-07)
Attending PostgresOpen? Come join me Friday for a gentle introduction to locks in PostgreSQL. My example-driven talk covers basic lock theor...
06-09-2018 02:50:49 Hacks o’Clock (Quinn Weaver) PostgreSQL
A word of praise for TextBelt
Quite often I need to kick off a long-running process for a client, then resume work immediately once it's done. pg_restore, pg_basebackup, ...
10-07-2017 03:32:25 Hacks o’Clock (Quinn Weaver) PostgreSQL
The PATH of cron
Short version Postgres Plus keeps psql out /usr/bin, so you need to set PATH in your cron jobs (including for WAL-E). Longer version Like al...
08-07-2017 01:46:41 Hacks o’Clock (Quinn Weaver) PostgreSQL
Change autovacuum_freeze_max_age without a restart (sort of…)
This blog post is kind of involved, so I'm giving a short version at the top, with some background for beginners at the bottom. The middle s...
30-03-2017 22:02:28 Hacks o’Clock (Quinn Weaver) PostgreSQL
Blocked by rdsadmin
One of our clients on RDS had a VACUUM FREEZE that was hanging for a long time. "I bet it's waiting on a lock," I thought. Yup, but the curi...
17-01-2016 08:16:31 Hacks o’Clock (Quinn Weaver) PostgreSQL

© Jiri Pinkas | this project on GitHub | related: SQL školení | Top Java Blogs | monitored using: sitemonitoring

Top SQL Blogs is a blog aggregator (with English-written blogs only) focused on MySQL, PostgreSQL, MS-SQL and Oracle databases.