search

railwayapp-templates / postgres-ssl

MIT License
13 stars 36 forks source link

Legacy pg user / role and extensions are not provided in this image #1

Closed MatteoGauthier closed 10 months ago

MatteoGauthier commented 1 year ago

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 introducing container services and a volume. However, the new database provisioning solution does not respect your documentation and previous versions...

So here are the changes I detected.

Legacy New postgresql image
Plugins timescaledb
Role name / User postgres railway

This is problematic because nowhere does it say that these properties have changed.

In addition, the documentation is not up to date... Capture d’écran 2023-09-29 à 15 48 03

I'm trying to migrate my legacy database to the new ones, but my pg_restore are failing due to these changes.

Btw I love your product !!

melissa-hale commented 1 year ago

Hey @MatteoGauthier thank you so much for this feedback. We have updated the default user to postgres.

As for timescaledb and postgis extension, we will provide a separate template soon that will include these.

ThallesP commented 1 year ago

Hey @MatteoGauthier thank you so much for this feedback. We have updated the default user to postgres.

As for timescaledb and postgis extension, we will provide a separate template soon that will include these.

@melissa-hale Will that be a separate template for each one? Because we use timescale + postgis and i don't want to deal with forks.

melissa-hale commented 10 months ago

Shoot I'm so sorry @ThallesP I missed your question here. You probably already found them, but yes we have a separate image and template that includes timescale and postgis.

https://railway.app/template/timescaledb-postgis https://github.com/railwayapp-templates/timescale-postgis-ssl