Now that the PostgreSQL community has released version 16, I thought it would be the perfect opportunity to talk to a wider audience, especially if you did not have the chance to join us in Canada. In my talk, I focused on the exciting new features introduced in version 16, but I also...
PostgreSQL 10, PostgreSQL 11, and PostgreSQL 13 support test_decoding. For more information about test_decoding, see test_decoding introduction.To use test_decoding, set
Next, we enable archive_mode by setting it to on. This setting can only be changed by restarting PostgreSQL, which we want to avoid. It's very likely that we will be using WAL archival in some respect, even if we don't yet know which method to use at this point. This means we al...
The standby connects to the primary, which streams WAL records to the standby as they're generated, without waiting for the WAL file to be filled. PostgreSQL supports two modes of streaming replication: asynchronous and synchronous mode. In this blog, we’ll discuss how to set up s...
Logical decoding is the official name of PostgreSQL’s log-based change data capture feature. If the term logical decoding sounds unfamiliar, you may have heard of wal2json instead. Wal2json is a popular output plugin for logical decoding. People often use ...
postgresql.conf: listen_addresses = '*' wal_level = logical max_wal_senders = 8 max_replication_slots = 4 pg_hba.conf: # TYPE DATABASE USER ADDRESS METHOD host all rep 192.168.100.144/32 md5 We must change the user (in our examplerep), which will be used for replication, and the ...
InPart 1of this series, we discussed core PostgreSQL concepts, when and how to change parameters, database behavior, and their best practices. In this post, we discuss more PostgreSQL key concepts, including simple query protocol, explain plans, how to read explain plans, and tools to...
/postdata/data/postgresql.conf (1 row) vi /oracle/pg_data/postgresql.confarchive_mode = on # enables archiving; off, on, or always # (change requires restart) archive_command = 'cp %p /oracle/pg_data/archive/%f' max_wal_senders = 10 # max number of walsender processes ...
roles-and-grants), [part 2](https://www.tangramvision.com/blog/hands-on-with-postgresql-authorization-part-2-row-level-security)), I realized that, in order to measure the performance impacts of different Row-Level Security policies, I first needed to understand how to accurately time ...
To change the location where thelog filesare stored when the log collector is enabled, you can use the log_directory parameter to specify a custom directory. Note that logging can sometimes be a problem in PostgreSQL. The logging collector will not allow any log messages to be lost, so at...