mandeepsingh.hashnode.devHow to Fix a Corrupted `.git/config` File — `fatal: bad config line 1` Error## Introduction You're working on a project, you type `git status`, and suddenly: ``` fatal: bad config line 1 in file .git/config ``` Every git command is broken. You didn't change anything. What 1d ago·5 min read
mandeepsingh.hashnode.devHow to Create a New PostgreSQL User for an Existing Database (Without Using postgres)1️⃣ Enter the PostgreSQL container docker exec -it postgres_pgvector psql -U postgres 2️⃣ Create a new user (role) Choose a strong password 👇 CREATE USER ai_user WITH PASSWORD 'ai_user_password'; 3️⃣ Grant access to the database GRANT CONNECT ON...Jan 27·1 min read
mandeepsingh.hashnode.devAssign Full permission DB user to DB in POSTGRES✅ STEP 1: postgres se login karo docker exec -it postgres_pgvector psql -U postgres \c bowlful_db ✅ STEP 2: Database-level full access GRANT ALL PRIVILEGES ON DATABASE bowlful_db TO bowlful_user; ✅ STEP 3: Schema ownership + access ALTER SCHEMA ...Jan 12·1 min read
mandeepsingh.hashnode.devHow to Automatically Kill Idle pgAdmin Connections in PostgreSQL (Best Practice)Problem:PostgreSQL connection pool exhaustion caused by pgAdmin keeping idle connections open, especially on small servers (1GB–2GB RAM). 🧠 Why this happens pgAdmin: Opens multiple connections Keeps them in idle state Does NOT auto-close quickly ...Dec 19, 2025·2 min read
mandeepsingh.hashnode.devPostgreSQL connection pool exhaustion error (postgreSQL + pgAdmin) both on dockerYou’re hitting PostgreSQL connection pool exhaustion, meaning: Your app opens more DB connections than Postgres (or your pool) allows, and they’re not being released fast enough. Below is a practical, code-level investigation + fixes tailored to wh...Dec 17, 2025·4 min read
