How 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';