Forum OpenACS Q&A: postgresql current_timestamp
and I compared it to the system's date function. PostgreSQL's time
is about 3 hours ahead of the system time! How can I synchronize the
Add this to your postgres user's .bash_rc file:
DEFAULT sets the time zone to your local time zone (the one that your operating system defaults to).
That doesn't work. It still registers the timezone as -04. HPUX is a bitch to work with. Aghhhh! :)
Anyway, are you sure PGTZ or TZ are set correctly (I don't know if my Linux syntax will work on your machine - have you changed it so it'll work on HP-UX?)?