Cant find user table in production db after deploying to fly.io
In dev I could easily delete users using the Prisma GUI, anyhow after deploy I can't seem to find the table containing the users.
I am accessing postgers through the fly cli with flyctl postgres connect -a myapp-db
postgres=# \dt
Did not find any relations.
postgres=# \d
Did not find any relations.
postgres=# \d "User"
I have a feeling i messed something with the db up.
During dev i didn't have a databsase_url in the env file as i was using the docker db that works out of the box.
I have deployed in that state and got the db connection string in the cli during deployment. I have then entered the string like this for production:
fly secrets set DATABASE_URL='postgres://myapp_server:password@myapp-db.flycast:5432/myapp_server?sslmode=disable' -a myapp-server
I am accessing postgers through the fly cli with flyctl postgres connect -a myapp-db
postgres=# \dt
Did not find any relations.
postgres=# \d
Did not find any relations.
postgres=# \d "User"
I have a feeling i messed something with the db up.
During dev i didn't have a databsase_url in the env file as i was using the docker db that works out of the box.
I have deployed in that state and got the db connection string in the cli during deployment. I have then entered the string like this for production:
fly secrets set DATABASE_URL='postgres://myapp_server:password@myapp-db.flycast:5432/myapp_server?sslmode=disable' -a myapp-server
