backup postgres s3
yanzaum
TRIALOP

2 years ago

how to correctly connect postgres backup to s3?

0 Replies

yanzaum
TRIALOP

2 years ago

Is this error after deploy due to the wrong database credential?
/run/postgresql:5432 - no response


brody
EMPLOYEE

2 years ago

I'd deploy this template and pair it with Cloudflare R2


brody
EMPLOYEE

2 years ago

make sure it's deployed into the project with the postgres database so that you can use the private database url


yanzaum
TRIALOP

2 years ago

ok, I'll switch to R2


yanzaum
TRIALOP

2 years ago

in the database env I set it to get it automatically
${{ DATABASE_URL }}


brody
EMPLOYEE

2 years ago

you'd need to use a namespace in that reference


yanzaum
TRIALOP

2 years ago

Does cloudflare r2 have no plan without adding credit card?


brody
EMPLOYEE

2 years ago

it requires you to add a credit card


yanzaum
TRIALOP

2 years ago

ok, where do I get the cloudflare credentials?


brody
EMPLOYEE

2 years ago

you have to generate them through cloudflare's website


yanzaum
TRIALOP

2 years ago

BACKUPDATABASEURL is ${{ Postgres.DATABASE_PRIVATE_URL }}?


brody
EMPLOYEE

2 years ago

assuming your database is in the same project and named Postgres that is correct


yanzaum
TRIALOP

2 years ago

the database is in the same project


yanzaum
TRIALOP

2 years ago

deploy logs
/run/postgresql:5432 - no response


brody
EMPLOYEE

2 years ago

click the eye icon on the backup URL variable, does it show correctly?


yanzaum
TRIALOP

2 years ago

yes


yanzaum
TRIALOP

2 years ago

private or public url?


yanzaum
TRIALOP

2 years ago

I will copy and paste


brody
EMPLOYEE

2 years ago

do not copy and paste please


yanzaum
TRIALOP

2 years ago

ok


yanzaum
TRIALOP

2 years ago

1233442255491039500


yanzaum
TRIALOP

2 years ago

it imported correctly


brody
EMPLOYEE

2 years ago

are you sure the backup url service variable on the CRON service shows correctly when you click it's eye icon


yanzaum
TRIALOP

2 years ago

yes


yanzaum
TRIALOP

2 years ago

If I send the project code within the railway, would it be better for you to follow it?


brody
EMPLOYEE

2 years ago

I don't work for Railway, I can't view your project


brody
EMPLOYEE

2 years ago

can you provide some context on this screenshot please?


yanzaum
TRIALOP

2 years ago

I got the env from the database and got the env from postgres backup and compared


yanzaum
TRIALOP

2 years ago

just to confirm if it was identical


brody
EMPLOYEE

2 years ago

screenshot of your deployment logs please


yanzaum
TRIALOP

2 years ago

1233443565670109400


yanzaum
TRIALOP

2 years ago

1233443616760926200


brody
EMPLOYEE

2 years ago

screenshot of the project please


yanzaum
TRIALOP

2 years ago

1233444299417583600


yanzaum
TRIALOP

2 years ago

It's all in the same project


brody
EMPLOYEE

2 years ago

hmmm so why are you getting that error, very strange, I will test this myself when I'm back at the computer and get back to you


yanzaum
TRIALOP

2 years ago

ok


brody
EMPLOYEE

2 years ago

i can no reproduce this issue unless i setup my BACKUP_DATABASE_URL variable incorrectly


Loading...