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

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

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