When changing glibc versions, it's possible to end up with corrupt indexes in PostgreSQL. Are My Indexes Affected?
If you have a PostgreSQL dump in the custom format you can can view the text format dump (plain SQL...
This card is just about creating simple PostgreSQL dumps. This is no instruction for a backup strategy nor a guide...
Best results in other decks
Performing COUNT(*) on large tables is slow. Sometimes you don’t need the exact number once results exceed a certain...
In Rails 8 the behavior of the rails db:migrate command has changed for fresh databases (see PR #52830).