Обсуждение: Time problem

Hi All,
I have installed postgres 7.1.3 as database.

For my application I have used timestamp as the datatype for date and time.

I am facing the following problem:

1) While inserting data, I do not have any trouble and the time taken is the
system time.
2) In the console when I select data it shows me the correct time.
3) BUT, when I am retrieving data from the sql query (code) and displaying
it, it is inexplicably ahead of the System time by exactly 30 mins.
4) I have tried setting the TIME ZONE variable to all possible combinations
as mentioned in the documentation. But even then if I ask the system to SHOW
TIME ZONE, it says "TIME ZONE IS UNKNOWN".
5) I have tried to find and set the environment variable, but again to no
avail.

I need help to sort this out, since it is throwing my otherwise sensible
application out of gear.

Regards
Jaya

"Jaya Swarup" <jayas@bsil.com> writes:
> 3) BUT, when I am retrieving data from the sql query (code) and displaying
> it, it is inexplicably ahead of the System time by exactly 30 mins.

Sure sounds like you are running in some odd time zone.

> 4) I have tried setting the TIME ZONE variable to all possible combinations
> as mentioned in the documentation. But even then if I ask the system to SHOW
> TIME ZONE, it says "TIME ZONE IS UNKNOWN".

This is bizarre.  Exactly what platform are you running on, and exactly
which "possible combinations" have you tried?

            regards, tom lane

This should be an easy one, but......

We need to start rolling our postgres error logs.  I wondered whether or
not I could pull the rug out from under postgres by just renaming the
pgsql.log to 'date'.log and then recreating (touch pgsql.log) the log.

I then vacuum'd a database (so it would write stuff in the log), and
noticed that the renamed log ('date'.log) was the one written to, not the
new pgsql.log.

Do I have to bounce the cluster to roll the log?   How should I be
performing this task?

--
Naomi Walker
Chief Information Officer
Eldorado Computing, Inc.
602-604-3100  ext 242

Naomi Walker <nwalker@eldocomp.com> writes:
> Do I have to bounce the cluster to roll the log?   How should I be
> performing this task?

There's some discussion of this point in the 7.2 docs:
http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/logfile-maintenance.html

            regards, tom lane