Hi! Make sure you're using the URL provided in the DATABASE_PUBLIC_URL environment variable, not the DATABASE_URL

Can you login to my account?

I cannot.

Can you view the tables if you go to the 'Database' tab?

https://share.zight.com/04uZyJp8

https://share.zight.com/L1uw6N0b

Use the DATABASE_URL in your case

one sec

https://share.zight.com/yAuqADGe

Can you show me the URL?

Just the URL, remove the credentials

postgres://railway:SSSSSSDSDSDSDSDSDSDSDSDSDSD@:/railway

The port is wrong, can you check if you can generate a TCP proxy in the Service settings? You likely don't have one

hold on

yes i can

https://share.zight.com/4guE4278

what shall i enter?

5432

https://share.zight.com/X6u65eDA

Now deploy it

how?

After you created the proxy, should be a floating popup asking you to deploy your changes

ok deploying

🙂

done

Connect to your service over TCP using a proxied domain and port - shall I use this new url?

yes!

i got something like this: trolley.proxy.ererer.net:XXXX. do I copy the XXXX as well or without the XXXX

put the XXXX in the Port field

paswrod authentication failed

check the rest of the credentials, you can find it in the service env vars

PGPASSWORD and PGUSER

im in

100% ok

excellent job

thx you so much!:)

is it safe to keep this setting over long run?

or shall I delete TCP?

For maximum security you can delete the TCP proxy, connect your services using only the private url and use a Tailscale proxy to connect to your DB without publicly exposing it

or I recreate it again when needed:)

thx bro

excellent

That too 😆

How can i check DB size

iirc there's a statistics tab in the PGAdmin client that shows the DB size in bytes

But I could be wrong

You could also just look at this lol

metrics tab on the DB's volume

Yeah but it isn't 100% correct since it is all of the current deployment vol usage and not specific to that DB

Yeah 100% not the "actual byte size" but a tiny quick "around how much"

if I want to revert back to this older deployment can i still do it? https://share.zight.com/9ZupzdkL

Still view data? Yes I believe so

yes

Q: normally how to long does it take for a 5 GB databse to backup via pgadmin?

Depends heavily on your internet speed 😁

Im on super fast internt and still getting stuck with this DB backup...so annyoing...would be super good to have somehow 1 click save or backup

The Railway pro plan provides scheduled backups!

im on the pro plan - but how can i downlaod the backed up file to my local pc?