Re: pkg/41067: time_t change from int to __int64_t breaks PostgreSQL databases

[christos%zoulas.com@localhost (Christos Zoulas)]

The following reply was made to PR pkg/41067; it has been noted by GNATS.

From: christos%zoulas.com@localhost (Christos Zoulas)
To: gnats-bugs%NetBSD.org@localhost, pkg-manager%netbsd.org@localhost, 
gnats-admin%netbsd.org@localhost, 
        pkgsrc-bugs%netbsd.org@localhost
Cc: 
Subject: Re: pkg/41067: time_t change from int to __int64_t breaks PostgreSQL 
databases
Date: Tue, 24 Mar 2009 13:54:57 -0400

 On Mar 24,  5:40pm, tgen%deepbone.net@localhost (tgen%deepbone.net@localhost) 
wrote:
 -- Subject: pkg/41067: time_t change from int to __int64_t breaks PostgreSQL 
 
 | FATAL:  incorrect checksum in control file
 | >How-To-Repeat:
 | 1) Create a database on a pre-time_t changes-system;
 | 2) Update NetBSD to post-time_t changes;
 | 3) Compile and install a new PostgreSQL package;
 | 4) Watch PostgreSQL die.
 | >Fix:
 | There are several possible fixes:
 | 
 | - Revert the time_t changes;
 | - Don't update NetBSD to post-time_t changes;
 | - Shake fist at christos and dump the database before updating (and loading
 |   after);
 | - Bug the PostgreSQL people to move to a standard on-disk format independent
 |   of the platform (i.e. don't store time_t values on disk, but a fixed 
format).
 
 http://osdir.com/ml/db.postgresql.announce/2008-02/msg00014.html
 
 christos