PostgreSQL TimeZone Error on Railway — invalid value for parameter "TimeZone": "UTC"

juzi19HOBBY

a month ago

Hey everyone!
I'm having an issue with my Railway PostgreSQL database.
A few weeks ago everything worked perfectly, but now I'm constantly getting the following error when trying to run:

SELECT set_config('TimeZone', 'UTC', false)
ERROR: invalid value for parameter "TimeZone": "UTC"
LOG: could not open directory "/usr/share/zoneinfo": No such file or directory

I'm using USE_TZ = True in Django, and it was working fine until recently.
Has something changed in the database setup or image?
How can I get this working again?

Thanks a lot in advance for any help! 🙏

0 Replies

juzi19HOBBY

a month ago

1df4e5dd-6753-4179-9848-e69bccf5eda3


juzi19HOBBY

a month ago

Hi,

I’ve already checked this with a different PostgreSQL database (also on Railway), and everything works fine there. So it seems to be a database-specific issue with my current instance. It appeared suddenly, and I only noticed it when checking the application.

I really need help resolving this quickly — otherwise, I’d have to migrate the entire database, which would be very painful, and very frustrating

Would appreciate any help or guidance on how to fix this!