echo $TZ and echo $PGTZ both came up empty. So I exported both as
"EST5EDT" (as root) and restarted postgresql, but still no luck.
Thanks for your prompt attention. I'm going to give more info to Thomas,
but if you have any more suggestions, let me know.
Thanks for your prompt attention,
On 2001.01.12 11:50:20 -0500 Tom Lane wrote:
> Barry Stewart <bstewart(at)smyrnacable(dot)net> writes:
> > I'm using Trustix Secure Linux 1.2 (RedHat based) on a Pentium 200MMX
> > Postgresql 7.02.
> Seems like a fairly vanilla-flavored platform... I'm baffled, to tell
> you the truth. I sent a heads-up to our date/time maven, Thomas
> Lockhart, who might have an idea what's going wrong here.
> > How do I check the TZ/PGTZ variables? On the command
> > line, the date command says:
> > Fri Jan 12 11:37:36 EST 2001
> Try "echo $TZ" at the command line. Given that date output, I'm
> guessing that you'll see "EST5EDT". Just for grins, you might try
> export PGTZ="EST5EDT"
> before starting psql, and then see if the behavior is the same or not.
> Probably won't help but it'd be worth making sure.
> regards, tom lane
In response to
pgsql-novice by date
|Next:||From: Ken Corey||Date: 2001-01-12 18:08:49|
|Subject: Syntax highlighting for plpgsql (in VIM, even)?|
|Previous:||From: Tom Lane||Date: 2001-01-12 16:50:20|
|Subject: Re: Pg subtracts one minute from time |