sqlalchemy.exc.OperationalError: (psycopg.OperationalError) connection failed: FATAL: role "ai" does not exist about phidata

[ashpreetbedi]

@justinqcai this happens when you already have a PgVector volume meaning the init db couldn't create the ai role. No worries the easiest path for us is to use a different name for the PgVector database. Update your cookbook/knowledge/resources.py file to:

from phi.docker.app.postgres import PgVectorDb
from phi.docker.resources import DockerResources

# -*- PgVector running on port 5532:5432
vector_db = PgVectorDb(
    name="knowledge-db",
    pg_user="ai",
    pg_password="ai",
    pg_database="ai",
    host_port=5532,
)

# -*- DockerResources
dev_docker_resources = DockerResources(apps=[vector_db])

Then run phi start cookbook/knowledge/resources.py -y and it should work

I've update the resources file in the cookbook as well so you can just pull from main to get the new code.

Let me know if you still face an issue :)

[justinqcai]

Awesome, thanks! It looks like the resources file in /cookbook/rag and the whole folder in general looks to be a duplicate, just wanted to bring that up as well before closing this thread out. Probably worth updating that resources file as well or simply removing the duplicate folder

[ashpreetbedi]

@justinqcai that is correct, the duplicates are intentional as users usually look for RAG/PDF cookbooks which are the duplicates but make it easier for users to search. im open to suggestions here :)

[justinqcai]

@ashpreetbedi That makes sense, in that case my only suggestion would be to update that file with the same changes you made here so users can run the RAG cookbook properly! Thanks Ash

[ashpreetbedi]

Very good idea @justinqcai, will do that