How to get into PSQL container (cli)
jcode
PROOP

2 years ago

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?

21 Replies

2 years ago

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


jcode
PROOP

2 years ago

Oh so i use the env variables to connect to it via local cmd?


2 years ago

yep!


jcode
PROOP

2 years ago

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


2 years ago

theres an ongoing incident, please keep an eye on <#846875565357006878>


jcode
PROOP

2 years ago

Oh thanks! Seems like I accidentally hid that <:kekw:788259314607325204>


2 years ago

it happens


2 years ago

the incident was resolved, are you still facing this issue?


jcode
PROOP

2 years ago

Yeah the issue is fixed now.
I have one last question.
Is there a way to get back a volume I deleted?


2 years ago

unless you took a backup, no


jcode
PROOP

2 years ago

How can I make a backup?


2 years ago

well if you didnt, its far too late now. but the answer depends on the type of app


jcode
PROOP

2 years ago

I want to make a backup of the Postgres data


2 years ago

pg_dump


jcode
PROOP

2 years ago

I'm sorry?


jcode
PROOP

2 years ago

What do you mean?


2 years ago

google can be a very helpful resource when something is said that you may not understand


jcode
PROOP

2 years ago

You could have said it's a command lol


jcode
PROOP

2 years ago

Is there a way to run such command every 30 minutes or so?


2 years ago

this template runs pg_dump under the hood and uploads the backup to s3 storage


jcode
PROOP

2 years ago

Oh thanks


Loading...