How to Resolve "PostgreSQL Slow Query Due to Missing Index on JSONB"
A query filtering on data stored inside a JSONB column takes far longer than an equivalent query on a normal indexed column, even on a table that isn't...
Blog
All troubleshooting articles, newest first.
How to Fix "Could Not Connect to Server: Connection Refused" in psql
Running psql fails before you even get to a login prompt, with the connection actively refused rather than timing out or asking for a password. This means...
How to Resolve "ERROR: Relation Does Not Exist" in Multi-Schema PostgreSQL
A query fails claiming a table doesn't exist, even though you can clearly see it when browsing the database. In a PostgreSQL database using multiple schemas,...
How to Fix "Nginx 502 Bad Gateway" Error With PHP-FPM or Node.js
Nginx returns a 502 error page instead of your application's response, which means Nginx itself is running fine but couldn't get a valid response from whatever...
How to Resolve "Nginx 413 Request Entity Too Large" Upload Error
A file upload that should work fails immediately with a 413 status instead of reaching your application code at all. Nginx rejects request bodies larger than...
How to Fix "Nginx 504 Gateway Time-out" on Long Running Requests
A request that takes a while to process — a report generation, a large data export, a slow third-party API call — fails with a 504 instead of eventually...
How to Resolve "nginx: [emerg] bind() to 0.0.0.0:80 failed (98: Address Already in Use)"
Nginx refuses to start or reload, reporting that port 80 (or whatever port it's configured for) is already claimed by something else. This means another...
How to Fix "Nginx 403 Forbidden" Error on Static File Hosting
Nginx returns a 403 error for a static file you're sure exists and should be publicly accessible. Unlike a 404, this means Nginx found something at that path...
How to Resolve "Nginx SSL Certificate Error: x509: Certificate Signed by Unknown Authority"
A client connecting to your Nginx server over HTTPS rejects the certificate as untrusted, even though you're confident you installed a valid certificate from a...