MSMandeep Singhinmandeepsingh.hashnode.dev·Apr 1 · 4 min readFrom Docker PostgreSQL Backup to Production Restore (Without Permission Headaches)If you’ve ever tried moving a PostgreSQL database from Docker to another server, you’ve probably hit this nightmare: ❌ “role does not exist” ❌ “permission denied for table” ❌ “type vector does not 00
MSMandeep Singhinmandeepsingh.hashnode.dev·Mar 25 · 1 min readStruggling with PostgreSQL Permissions? Here’s the Real Fix (Not GRANT)So even if you gave ALL PRIVILEGES, it’s not enough for ALTER. ✅ Fix (change ownership) Run this as postgres (or superuser) inside Docker: docker exec -it postgres_pgvector psql -U postgres -d nutr00
MSMandeep Singhinmandeepsingh.hashnode.dev·Mar 12 · 2 min readStep-by-Step Guide: Create PostgreSQL Database, User, and Grant Privileges on UbuntuHere is the correct way to create a PostgreSQL database, user, and give full permissions on Ubuntu. 1️⃣ Login to PostgreSQL sudo -i -u postgres psql 2️⃣ Create Database CREATE DATABASE "the-ai-shift00
MSMandeep Singhinmandeepsingh.hashnode.dev·Feb 23 · 5 min readHow 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 00
MSMandeep Singhinmandeepsingh.hashnode.dev·Jan 27 · 2 min readHow 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'; 00
