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

a year 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! 🙏

2 Replies

juzi19
HOBBYOP

a year ago

1df4e5dd-6753-4179-9848-e69bccf5eda3


juzi19
HOBBYOP

a year 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!


Welcome!

Sign in to your Railway account to join the conversation.

Loading...