5d77fb37-1fba-4a55-bbd3-e0fab8243723

it looks like that error states the cert is outdated?

try switching the image tag to 16 and set a REGENERATE_CERTS variable to true

Brody - you're the best. I'll try that.

qq -- we're on Vpg15 ts2.12. Will the same variable work there to regenerate the certs or is it only 16?

at this moment Melissa has only implemented it for railways postgres 16 image with the self signed certs, are you using a railway image for postgres?

Yes we're using the Railway image.

But I think it's #15

can you link me to its ghcr listing?

https://ghcr.io/railwayapp-templates/timescale-postgis-ssl

thanks, at this time this is the only image that supports regenerating the certs -

cc @Melissa

To make sure I understand, this change would upgrade us from 15 to 16.

you are using a timescale-postgis image, it does not support regenerating the self signed cert

oh, I set it up a long time ago from some demo. We aren't using the timescale features.

then you could deploy a new postgres database and copy over the data?

Can you point to a guide for moving the volume?

I saw there's no S/FTP support and that you have to mount a container to access the volume.

There is no file browser, or direct file download. To access your files, you must do so via the attached service's mount point
https://docs.railway.app/reference/volumes
I'm not certain how to migrate the data.

I guess I could backup and restore with pgutils?

yeah anything that can dump and restore, like pgdump and pgrestore