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).
11 Replies
Project ID:
N/A
N/A
with previous postgresql service
with new railway postgresql image (postgres-ssl)
Also postgres role name is not the same.... I can't restore several of my databases
Here is the github issue : https://github.com/railwayapp-templates/postgres-ssl/issues/1
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...
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
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
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?Yes exactly
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