Postgres Database Won't Start

craftzman7
HOBBY

a month ago

I (stupidly) upgraded the base image to the postgres 16 template in my project, database refuses to start due to version incompatibiltiy, I roll it back to the old deployment, postgres now complains that private key file "/var/lib/postgresql/data/certs/server.key" must be owned by the database user or root. Any ideas as to how I can fix this?

Solved

0 Replies

craftzman7
HOBBY

a month ago

750a6ff7-b90f-4885-88b9-e69f7ba105be


craftzman7
HOBBY

a month ago

Ugh this is what I get for screwing with things I shouldn't…


craftzman7
HOBBY

a month ago

The dashboard UI just completely broke… what have I done. I applied changes and now there is infinite loading.


craftzman7
HOBBY

a month ago

Okay redeployed with a new database and back to this error…

1386231568816799700


craftzman7
HOBBY

a month ago

😭


craftzman7
HOBBY

a month ago

So much for "it just works"


craftzman7
HOBBY

a month ago

The one time I find someone else with my issue it 404's… https://station.railway.com/questions/new-docker-postgres-image-cannot-connect-4275e855


craftzman7
HOBBY

a month ago

Okay chowned the certs directory to root through filebrowser


craftzman7
HOBBY

a month ago

I doubt this is how this works but here goes nothing


craftzman7
HOBBY

a month ago

Yeah and it didn't work.


craftzman7
HOBBY

a month ago

Well shit… what to do now.


craftzman7
HOBBY

a month ago

Wait. Idea time. Delete certs directory (back it up first of course!) and let the database regenerate it…


craftzman7
HOBBY

a month ago

HEY THE DATABASE IS UP!


craftzman7
HOBBY

a month ago

Time to reconnect my app!!


craftzman7
HOBBY

a month ago

S-s-s-s-olved!


a month ago

!s


Status changed to Solved brody about 1 month ago


Postgres Database Won't Start - Railway Help Station