From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | M Tarkeshwar Rao <m(dot)tarkeshwar(dot)rao(at)ericsson(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Cc: | Gaurav Tiwari G <gaurav(dot)g(dot)tiwari(at)ericsson(dot)com> |
Subject: | Re: Adding 3 hours while inserting data into table |
Date: | 2014-08-06 13:11:52 |
Message-ID: | 53E22998.90405@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 08/06/2014 03:50 AM, M Tarkeshwar Rao wrote:
> Hi Team,
>
> We are facing some inconsistence behaviour of Postgres. We have deployed
> our database on a server where timezone is GMT+3 hours.
What Postgres version?
How was Postgres installed and on what OS?
>
> We have application which is running on the same server.
What is the application using to connect to the server, ODBC, JDBC, etc?
>
> When application starts, it is inserting the correct timestamp in the
> table but after running few minutes/hours we have observed that 3 hours
> is added into the timestamp in table. The problem resolved once the
> application restarted.
So once the application is restarted the timestamp offset never changes
or do you have to restart periodically to reset?
>
> Our application is putting correct data (checked by the insert query)
> and in DB it is seen that 3 hours is added. The figure 3 is slightly
> important as the server is deployed GMT+3 hours.
Can you show an example of an INSERT.
>
> Below are some observations and some command output along with table
> structure.
>
> JEDEMM02:/# date;
>
> Tue Aug 5 16:41:52 AST 2014
>
>
> *Property in Postgres.conf*
>
> #timezone = '(defaults to server environment setting)'
Is that the actual setting from postgresql.conf?
There is not a timezone specified?
>
> **
>
> *Table Structure:*
>
> *Column | Type | Modifiers*
>
> *------------------------+-----------------------------+-----------*
>
> *msisdn | character varying(100) |*
>
> *offerid | character varying(100) |*
>
> *expdatetime | timestamp without time zone |*
If you are interested in timezone(time) correctness this should be 'with
timezone'.
> Regards,
>
> M Tarkeshwar Rao
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Alexey Klyukin | 2014-08-06 14:48:22 | Re: Reindex taking forever, and 99% CPU |
Previous Message | vpmm2007 | 2014-08-06 12:34:45 | postgresql referencing and creating types as record |