R
Railway14mo ago
Mattèo

Does timescaledb and PostGIS are installed on the postgres-ssl image ?

The extensions seem to not be installed, whereas the documentation notes that these plugins are included. I'm trying to migrate a database made with the included PostgreSQL service (created several months ago) to the installation with the default PostgreSQL image (postgres-ssl).
No description
No description
11 Replies
Percy
Percy14mo ago
Project ID: N/A
Mattèo
Mattèo14mo ago
N/A
Mattèo
Mattèo14mo ago
with previous postgresql service
No description
Mattèo
Mattèo14mo ago
with new railway postgresql image (postgres-ssl)
No description
Mattèo
Mattèo14mo ago
Also postgres role name is not the same.... I can't restore several of my databases
No description
No description
Mattèo
Mattèo14mo ago
GitHub
Legacy pg Role Name and extensions are not provided in this image ·...
Hey Railway team, I've been using the database provisioning service included with Railway (Postgres) for several months, and recently you've changed your methodology (which is very good) by...
Brody
Brody14mo ago
the documentation states they are no longer included though I do understand how this is very disruptive, you should just be able to swap the image out for an image that does have those extensions, if you want the same exact image, they used timescale/timescaledb-postgis:latest-pg13
Mattèo
Mattèo14mo ago
Thanks for your reply, I will use the timescaledb image 👍 And for the role name, did you plan to rename to postgres ? I think, it might be useful in the documentation to have the info
Brody
Brody14mo ago
I'm not too sure if the data the new image already wrote to the volume would cause issues using the image I just linked, so you might want to deploy the new template and abort the deployment before it finishes so you can change the image before any data gets written to the volume PGUSER used to be postgres and now it's railway is that correct?
Mattèo
Mattèo14mo ago
Yes exactly
Brody
Brody14mo ago
ideally that wouldn't make a difference when using reference variables and environment variables all throughout your code I can only see a username change being an issue when hard coding values
Want results from more Discord servers?
Add your server