Integer Overflow, User-Friendly Permissions, Dump & Logical Replication, Worker Config | Scaling Postgres 255

Episode 255 March 05, 2023 00:17:43
Integer Overflow, User-Friendly Permissions, Dump & Logical Replication, Worker Config | Scaling Postgres 255
Scaling Postgres
Integer Overflow, User-Friendly Permissions, Dump & Logical Replication, Worker Config | Scaling Postgres 255

Mar 05 2023 | 00:17:43

/

Hosted By

Creston Jamison

Show Notes

In this episode of Scaling Postgres, we discuss how to detect & handle integer overflows, a wish for user-friendly permissions, using a dump to start logical replication and configuring background workers.

To get the show notes as well as get notified of new episodes, visit: 

https://www.scalingpostgres.com/episodes/255-integer-overflow-user-friendly-permissions-dump-logical-replication-worker-config/

Other Episodes

Episode 403

February 08, 2026 00:16:22
Episode Cover

Mitigate Retry Storms? | Scaling Postgres 403

In this episode of Scaling Postgres, we discuss a potential way to mitigate retry storms or orphan DB sessions with client_connection_check_interval, checkpoint configuration, skip...

Listen

Episode 159

April 04, 2021 00:09:32
Episode Cover

Tablespaces, Streaming Replication, More Postgres 14, Security | Scaling Postgres 159

In this episode of Scaling Postgres, we discuss when to use tablespaces, setting up streaming replication, features coming in Postgres 14 and implementing security....

Listen

Episode 41

December 03, 2018 00:14:26
Episode Cover

Sequential UUIDs, Runnning Totals, Read Committed, TOAST | Scaling Postgres 41

In this episode of Scaling Postgres, we review articles covering sequential UUIDs, running totals with window functions, read committed vs repeatable read and TOAST....

Listen