The guests both have deep roots in the community—Álvaro as a Postgres committer and Boriss as a frequent conference speaker as well as the organizer for thePgBE PostgreSQL User Group Belgium. And they have known each other for decades, since university days...
Raw # Server-side SSL settings for PostgreSQL (when we are installing it). postgres_use_ssl=True postgres_ssl_cert=/path/to/server.crt postgres_ssl_key=/path/to/server.key ,the setup fails at 'TASK [awx_install : Migrate the Tower database schema (may take awhile when upgrading).] w...
postgres=> SELECT 'Josh '||NULL||'Otwell' AS first_name; first_name --- (1 row) postgres=> SELECT NULL||'Josh '||'Otwell' AS first_name; first_name --- (1 row) postgres=> SELECT CONCAT(NULL,'Josh','Otwell') AS first_name; first_name --- JoshOtwell (1 row) Observe that ...
To understandSubtransControlLock(PostgreSQL 13renamed this toSubtransSLRU), we first must understand how subtransactions work in PostgreSQL. In PostgreSQL, a transaction can start via aBEGINstatement, and a subtransaction can be started with a subsequentSAVEPOINTquery. PostgreSQL assigns each of these ...