/explore

Click through on any links that interest you or select the planets on the right to continue exploring the Outer Web.
You are here

 eradman.com
Eric Radman : PostgreSQL Administrative Queries
| | www.depesz.com
Is my autovacuum configured properly? - select * from depesz;
2.2 parsecs away

Travel
| | [AI summary] The article discusses how to properly configure PostgreSQL's autovacuum to optimize performance and prevent issues related to database bloat and vacuuming tasks.
| | www.geekytidbits.com
Postgres Privilege Helper Queries | Geeky Tidbits
2.8 parsecs away

Travel
| | Recently, I have been trying to get a better understanding of how privileges work in Postgres and one thing I wanted was an easy way to inspect the current privileges for roles/users, databases, schemas, and tables.
| | taylorbrazelton.com
Quick Postgres Database Backup
1.2 parsecs away

Travel
| | [AI summary] A concise guide provides SQL commands for quickly backing up, cloning, and isolating a Postgres database for testing purposes.
| | epicserve.com
Fix GitHub Action Docker Compose Permission Errors | Epicserve
19.2 parsecs away

Travel
| I was working on my Django Base Site project when I discovered a test was failing in a GitHub Action when trying to run Django's collectstatic manager command. It was failing in Python with the error, PermissionError: [Errno 13] Permission denied: '/srv/app/collected_static'.