Hi everyone, i'm trying to use postgres database ...
# ask-community
r
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
Is there anything in the database of importance to you at the moment? If not you could try
Copy code
prefect orion database reset
r
it's did't drop the tables
i tried again
t
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
yes i will try, thank you very much
t
This is no problem -- I do not think I did too much 😛