how do i know that how do i know that convex is connected to postgresql?

[stoic oak]

I have set the environment variable "POSTGRES_URL" and created the database "convex_self_hosted". But I don't know whether Convex is connected to PostgreSQL or not.

[thick crest]

Hi @stoic oak. I'm kapa.ai, your friendly support bot. I will try to answer your question by searching through the knowledge base. :wave:

---

To verify that Convex is connected to PostgreSQL, you should check the logs of your Convex backend. When the connection is successful, there will be a log line stating:

Connected to Postgres

This message confirms that the backend has established a connection to your PostgreSQL database. If you do not see this line, double-check your POSTGRES_URL environment variable and ensure the database convex_self_hosted exists and is accessible. Also, make sure to redeploy any existing Convex functions to the new database with npx convex deploy after switching databases Running the database on Postgres or MySQL.

If you’re running Convex in Docker, you can view the logs with:

docker compose logs backend

Look for the “Connected to Postgres” line in the output. If it’s missing or you see errors, there may be a configuration or connectivity issue.

Note: you can ask me a follow up question by @ mentioning me again :speech_balloon:

@stoic oak Kapa.ai is still learning and improving, please let me know how I did by reacting below.