Postgis custom version

Hi there, Im trying to create a database of postgis at a custom version (im doing a migration to railway, the old hosting uses this version). But it is reporting this error every time it deploys.
No description
Solution:
deploy the postgres database from the + New button as fast as you can, abort/cancel the active build/deployment set the start command to /bin/sh -c "unset PGPORT; docker-entrypoint.sh postgres --port=5432" replace the image in the service settings...
Jump to solution
22 Replies
Percy
Percy14mo ago
Project ID: c1dd7561-a531-42dd-aacd-2cfeaa266423
Attacler/Bart
Attacler/BartOP14mo ago
c1dd7561-a531-42dd-aacd-2cfeaa266423
Brody
Brody14mo ago
what version are you trying to deploy?
Attacler/Bart
Attacler/BartOP14mo ago
13-master
Solution
Brody
Brody14mo ago
deploy the postgres database from the + New button as fast as you can, abort/cancel the active build/deployment set the start command to /bin/sh -c "unset PGPORT; docker-entrypoint.sh postgres --port=5432" replace the image in the service settings
Attacler/Bart
Attacler/BartOP14mo ago
sneaky, its deploying
Brody
Brody14mo ago
in the future you will be able to swap the image before deploying so you dont have to do that dance
Attacler/Bart
Attacler/BartOP14mo ago
looks good to me but it does not allow me to connect from pgadmin (on my machine)
Attacler/Bart
Attacler/BartOP14mo ago
No description
Brody
Brody14mo ago
what image are you swapping to
Attacler/Bart
Attacler/BartOP14mo ago
No description
Attacler/Bart
Attacler/BartOP14mo ago
No description
Attacler/Bart
Attacler/BartOP14mo ago
it also tells me that its running on the correct port
Brody
Brody14mo ago
not the correct port one second
Attacler/Bart
Attacler/BartOP14mo ago
ah i might have an idea why
Brody
Brody14mo ago
i do too, one second set the start command to
/bin/sh -c "unset PGPORT; docker-entrypoint.sh postgres --port=5432"
/bin/sh -c "unset PGPORT; docker-entrypoint.sh postgres --port=5432"
Attacler/Bart
Attacler/BartOP14mo ago
that works, thank you!
Brody
Brody14mo ago
no problem! do you plan on removing the tcp proxy from the service?
Attacler/Bart
Attacler/BartOP14mo ago
i dont think so, my client also needs to have access to it from his pc is there any downside?
Brody
Brody14mo ago
postgres doesnt like it
2023-10-27 17:51:38.529 GMT [1] FATAL: invalid value for parameter "port": ""
2023-10-27 17:51:38.529 GMT [1] FATAL: invalid value for parameter "port": ""
updated start command so that you can remove the tcp proxy without issues you might not need to disable the tcp proxy for this database, but i think its a good think to know
Attacler/Bart
Attacler/BartOP14mo ago
ah right thank you very much for the quick help!
Brody
Brody14mo ago
no problem!
Want results from more Discord servers?
Add your server