DB Time Differs From PHP Time

[CarlosinFL]

I've upgraded my installation today and also switched to a new database (PostgreSQL) however during the installer, I get an error that tells me my database time differs from my PHP time.

DB Time:  NOT OK (Database time differs s from PHP time)

I checked my PHP.ini file in Linux and it just tells me:

Code Select Expand

[Date]
; Defines the default timezone used by the date functions
date.timezone = America/New_York


Can someone please tell me what is wrong? I checked my database server and it shows the correct time in both PostgreSQL and on Linux:

Code Select Expand

postgres=# SELECT current_time;
       timetz      
--------------------
 14:32:34.115421-04
(1 row)

postgres=# SELECT current_date;
    date    
------------
 2011-08-23
(1 row)


Code Select Expand

cmennens@db1:~$ date
Tue Aug 23 14:32:54 EDT 2011


Can anyone please tell me what I'm missing here?

[CarlosinFL]

Anyone know what this means and how to fix it? I've verified my database and system time on Linux are correct and they are:

[ATTACH=CONFIG]1736[/ATTACH]

Code Select Expand

[root@ideweb1 config]# date
Fri Aug 26 09:15:56 EDT 2011


Code Select Expand

postgres=# SELECT current_date;                                                                                                                                   date    
------------
 2011-08-26
(1 row)

postgres=# SELECT current_time;
       timetz      
--------------------
 10:16:50.827416-04
(1 row)


[Julius Caesar]

One hour difference often has something to do with a DST (Daylight Saving Time)-setting. Check your configs for that

[CarlosinFL]

Check my configurations in RC or PHP? I don't understand? My database time is obviously right and my PHP time is set to US/Eastern.

[Julius Caesar]

Check my configurations in RC or PHP? I don't understand? My database time is obviously right and my PHP time is set to US/Eastern.

Well, first check the time-zone in RC, and if it's automatic, check your PHP-config.