https://prefect.io logo
Title
r

Rabea Yousof

11/07/2022, 11:20 AM
Hi everyone, i'm trying to use postgres database as prefect backend, I added the connection string and i stared the orion, all tables created at my db but missing fields, and got this error. can anyone help me?
t

Tim Galvin

11/07/2022, 12:23 PM
Is there anything in the database of importance to you at the moment? If not you could try
prefect orion database reset
r

Rabea Yousof

11/07/2022, 12:25 PM
it's did't drop the tables
i tried again
t

Tim Galvin

11/07/2022, 12:48 PM
That is odd. How have you installed postgres? When in doubt, I tend to delete the entire
pgdata
folder I set postgres up to use. This is not problem for me at the moment as my stuff is purely dev, so these tables mean nothing to me
You might have to get your hands dirty on the postgres shell to get things back to a nice state
r

Rabea Yousof

11/07/2022, 12:50 PM
yes i will try, thank you very much
t

Tim Galvin

11/07/2022, 12:54 PM
This is no problem -- I do not think I did too much 😛