Blog: The Build (Christopher Pettus)


210 blogs updated: 33 min. ago
"Securing PostgreSQL" at PDXPUG PostgreSQL Day 2018
The slides from my presentation, Securing PostgreSQL at PDXPUG PostgreSQL Day 2018 are now available.
0
13-09-2018 06:02:09 The Build (Christopher Pettus) PostgreSQL
CHAR: What is it good for?
In addition to the familiar text types VARCHAR and TEXT, PostgreSQL has a type CHAR. It's little used and that's for a reason. It has some v...
3
04-09-2018 21:52:25 The Build (Christopher Pettus) PostgreSQL
Don't LOCK tables. Just don't.
It's not uncommon that an application needs to serialize access to one or more resources. The temptation is very high to use the LOCK TABLE ...
0
29-08-2018 03:01:41 The Build (Christopher Pettus) PostgreSQL
Three Steps to pg_rewind Happiness
pg_rewind is a utility included with PostgreSQL since 9.x. It's used to "rewind" a server so that it can be attached as a secondary to a pri...
3
09-08-2018 19:54:26 The Build (Christopher Pettus) PostgreSQL
Does anyone really know what time it is?
PostgreSQL has a variety of ways of telling time: now(), statement_timestamp(), and clock_timestamp(). Each has a different sense of when "n...
0
08-08-2018 03:40:45 The Build (Christopher Pettus) PostgreSQL
One of those things: pgbouncer and self-signed certificates
(This is another intermittent series of small things that are easy to forget, and cause irritation in the PostgreSQL world ) Since version 1...
0
23-07-2018 19:15:04 The Build (Christopher Pettus) PostgreSQL
pg_rewind and checkpoints: caution!
pg_rewind, introduced in PostgreSQL 9.5, is a powerful utility solving a particular problem: If you have a promoted a streaming replication ...
0
18-07-2018 18:43:15 The Build (Christopher Pettus) PostgreSQL
That Google Checksum Tool
Google recently released a tool to check on-disk checksums in PostgreSQL. PostgreSQL being hot, and Google being Google, this generated a lo...
0
17-07-2018 20:39:03 The Build (Christopher Pettus) PostgreSQL
One of those things: /tmp/pgpool_status
(This is another intermittent series of small things that are easy to forget, and cause irritation in the PostgreSQL world ) When setting up...
0
17-07-2018 06:54:07 The Build (Christopher Pettus) PostgreSQL
PostgreSQL Replication at PerconaLive 2018
The slides from my talk on PostgreSQL Replication at PerconaLive 2018 are available.
3
10-05-2018 21:39:35 The Build (Christopher Pettus) 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.