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?
#How to get into PSQL container (cli)
cyan cobalt
patent gulchBOT
dim timber
you would use the psql command line tool locally, or any other software that would allow you to run queries on your database, like dbgate
cyan cobalt
you would use the psql command line tool locally, or any other software that wou...
Oh so i use the env variables to connect to it via local cmd?
dim timber
yep!
cyan cobalt
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
dim timber
theres an ongoing incident, please keep an eye on #🚨｜incidents
cyan cobalt
Oh thanks! Seems like I accidentally hid that 
dim timber
it happens
dim timber
the incident was resolved, are you still facing this issue?
cyan cobalt
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?
dim timber
unless you took a backup, no
cyan cobalt
How can I make a backup?
dim timber
well if you didnt, its far too late now. but the answer depends on the type of app
cyan cobalt
I want to make a backup of the Postgres data
dim timber
pg_dump
dim timber
google can be a very helpful resource when something is said that you may not understand
cyan cobalt
You could have said it's a command lol
Is there a way to run such command every 30 minutes or so?
dim timber
this template runs pg_dump under the hood and uploads the backup to s3 storage https://railway.app/template/I4zGrH