ports/141135: databases/postgresql84-server is compiling without vital flag

[Eugene M. Zheganin]

>Number:         141135
>Category:       ports
>Synopsis:       databases/postgresql84-server is compiling without vital flag
>Confidential:   no
>Severity:       non-critical
>Priority:       low
>Responsible:    freebsd-ports-bugs
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          sw-bug
>Submitter-Id:   current-users
>Arrival-Date:   Thu Dec 03 12:40:00 UTC 2009
>Closed-Date:
>Last-Modified:
>Originator:     Eugene M. Zheganin
>Release:        7.2-RELEASE
>Organization:
Norma JSC.
>Environment:
FreeBSD ns.hq.norma.perm.ru 7.2-RELEASE-p4 FreeBSD 7.2-RELEASE-p4 #0: Tue Oct 27 19:56:38 YEKT 2009     emz at ns.hq.norma.perm.ru:/usr/obj/usr/src/sys/HQ  i386
>Description:
The port databases/postgresql84-server now is building without the default HAVE_INT64_TIMESTAMP, which is now gone to the config menu. However, 8.4.0 had this flag set by default. This makes simple upgrade 8.4.0 -> 8.4.1 not that simple, as it now requires one more port rebuilding after realising what causes the inability of the server to start.
>How-To-Repeat:
Get a 8.4.0 datadir. Try to upgrade to 8.4.1 without a database dump (as none is needed along with the minor version upgrade). You will get a message like

===Cut===
Dec  3 17:08:17 ns postgres[24286]: [2-1] FATAL:  database files are incompatible with server
Dec  3 17:08:17 ns postgres[24286]: [2-2] DETAIL:  The database cluster was initialized with HAVE_INT64_TIMESTAMP but the server
was compiled without HAVE_INT64_TIMESTAMP.
Dec  3 17:08:17 ns postgres[24286]: [2-3] HINT:  It looks like you need to recompile or initdb.
===Cut===
>Fix:


>Release-Note:
>Audit-Trail:
>Unformatted: