I do not think this is a server issue, seems like a driver issue. When I connect to the DB from RHEL4 through the driver (running on RHEL4) it works. But, when the driver is running on RHEL3 it fails.
Anyways, here's the output: [EMAIL PROTECTED] pgsql]# pg_controldata `pwd`/data pg_control version number: 812 Catalog version number: 200510211 Database system identifier: 4972362701494942605 Database cluster state: in production pg_control last modified: Thu 11 Jan 2007 04:32:27 AM IST Current log file ID: 0 Next log file segment: 2 Latest checkpoint location: 0/15F3CD0 Prior checkpoint location: 0/15F3B1C Latest checkpoint's REDO location: 0/15F3CD0 Latest checkpoint's UNDO location: 0/0 Latest checkpoint's TimeLineID: 1 Latest checkpoint's NextXID: 5195 Latest checkpoint's NextOID: 25214 Latest checkpoint's NextMultiXactId: 1 Latest checkpoint's NextMultiOffset: 0 Time of latest checkpoint: Thu 11 Jan 2007 04:32:27 AM IST Maximum data alignment: 4 Database block size: 8192 Blocks per segment of large relation: 131072 Bytes per WAL segment: 16777216 Maximum length of identifiers: 64 Maximum columns in an index: 32 Date/time type storage: floating-point numbers Maximum length of locale name: 128 LC_COLLATE: en_US.UTF-8 LC_CTYPE: en_US.UTF-8 [EMAIL PROTECTED] pgsql]# What is IIRC? Thanks Ravi --- Alvaro Herrera <[EMAIL PROTECTED]> wrote: > Ravi wrote: > > > On Red Hat Enterprise Linux AS release 4 (Nahant > Update 3) the milliseconds > > returned is as follows > > > > -2209028400000 = > -25567.458333333333333333333333333 = Jan 1 1900 > > > > On Red Hat Enterprise Linux AS release 3 (Taroon > Update 3) the milliseconds > > returned is as follows > > -2208952800000 = > -25566.583333333333333333333333333 = Jan 2 1900 > > Is one of these compiled with > --enable-integer-datetimes, and the other > not? You can tell by calling pg_controldata, IIRC. > > -- > Alvaro Herrera > http://www.CommandPrompt.com/ > PostgreSQL Replication, Consulting, Custom > Development, 24x7 support > ____________________________________________________________________________________ Need a quick answer? Get one in minutes from people who know. Ask your question on www.Answers.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster