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.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
