Set timezone on database level

ALTER DATABASE <your_database_name> SET timezone = 'UTC';

Set timezone on global level

-- This modifies postgresql.auto.conf
ALTER SYSTEM SET timezone = 'UTC';

-- Reload configuration (no restart needed)
SELECT pg_reload_conf();

-- Verify it worked
SHOW timezone;