Bruce Momjian <bruce@xxxxxxxxxx> wrote: > On Tue, May 27, 2014 at 04:29:19PM +0200, Meik Weißbach wrote: >> How do we determine, whether or not a server is built with >> disable-integer-datetimes? > > pg_upgrade --check will definitely complain about a timestamp storage > mismatch. Odds are your packager built 8.3 with integer timestamps. > Run pg_controldata on the 8.3 cluster and look at: > > Date/time type storage: 64-bit integers > > This shows integer timestamps. All good information; but just for the sake of completeness, if you can get a database connection, you can execute: SHOW integer_datetimes; -- Kevin Grittner EDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
