How to get into PSQL container (cli)
Project ID: 3337bbd9-871e-41a3-a35e-ace982a5dc04
I would like to get into my Postgres container and drop a FK because it's giving me errors.
How can I do such thing?
19 Replies
Project ID:
3337bbd9-871e-41a3-a35e-ace982a5dc04you would use the psql command line tool locally, or any other software that would allow you to run queries on your database, like dbgate
Oh so i use the env variables to connect to it via local cmd?
yep!
I have another problem now it seems haha.
Because I already tried some things, i decided to remove Postgres to spin up a new one.
But it's been stuck on this for like a few minutes now and a new one won't spin up
theres an ongoing incident, please keep an eye on #🚨｜incidents
Oh thanks! Seems like I accidentally hid that :kekw:
it happens
the incident was resolved, are you still facing this issue?
Yeah the issue is fixed now.
I have one last question.
Is there a way to get back a volume I deleted?
unless you took a backup, no
How can I make a backup?
well if you didnt, its far too late now. but the answer depends on the type of app
I want to make a backup of the Postgres data
pg_dump
I'm sorry?
What do you mean?
google can be a very helpful resource when something is said that you may not understand
You could have said it's a command lol
Is there a way to run such command every 30 minutes or so?
this template runs pg_dump under the hood and uploads the backup to s3 storage https://railway.app/template/I4zGrH
Oh thanks