Re: Adding 3 hours while inserting data into table

On 08/07/2014 07:49 AM, Gaurav Tiwari G wrote:
> Hi,
>
> 1. Postgres configuration might be the suspect area but as we are not
> specifying any timezone related property.

I was not talking about Postgres, it is not the application but the
server. I was referring to whatever Java application you are running
against Postgres.

>
> 2. We are using Postgres Jdbc4 driver.
>
> 3. When Application starts everything is running fine, but after few
> minutes issue occurs and issue remain persist until application restart.
> Once the application restarted everything is working fine for few request.
>
> One more point, as DB is deployed on GMT+3 hr (Saudi Arabic where
> timezone is Asia/Riyadh).
>
> So we need to set the timzone in postgres.conf by *timezone =
> 'Asia/Riyadh' *in**postgres.conf. So will it make any sense or is there
> any way to do so. ??**

From previous posts the timezone is set to the correct one, as Postgres
is picking up the machines timezone environment variable.

Dates and times are a complex subject with a lot of moving parts. To
help narrow down the number of parts we really need to see what is being
provided to the Postgres server and what the result is. Otherwise ,
there will not be any progress to a solution.

>
> Regards,
>
> Gaurav Tiwari
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com