ports/132010: PostgreSQL Cluster Initialisation Fails on FreeBSD

[Peter Woodward]

>Number:         132010
>Category:       ports
>Synopsis:       PostgreSQL Cluster Initialisation Fails on FreeBSD
>Confidential:   no
>Severity:       serious
>Priority:       low
>Responsible:    freebsd-ports-bugs
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          sw-bug
>Submitter-Id:   current-users
>Arrival-Date:   Mon Feb 23 15:10:02 UTC 2009
>Closed-Date:
>Last-Modified:
>Originator:     Peter Woodward
>Release:        7.0
>Organization:
none
>Environment:
%uname -a
FreeBSD thinkpadr31.petew.org 7.0-RELEASE FreeBSD 7.0-RELEASE #0: Sun Feb 24
19:59:52 UTC 2008  root at logan.cse.buffalo.edu:/usr/obj/usr/src/sys/GENERIC  i386
>Description:
Following a build from the ports collection of PostgreSQL 8.3, the cluster initialisation script fails. The following log illustrates the problem
-------------------script log 1------------------------------
%whoami
postgres
%initdb -D /usr/local/pgsql/data
The files belonging to this database system will be owned by user
"postgres".
This user must also own the server process.
 
The database cluster will be initialized with locale C.
The default database encoding has accordingly been set to SQL_ASCII.
The default text search configuration will be set to "english".
 
fixing permissions on existing directory /usr/local/pgsql/data ... ok
creating subdirectories ... ok
selecting default max_connections ... 40
selecting default shared_buffers/max_fsm_pages ... 20MB/128000
creating configuration files ... ok
creating template1 database in /usr/local/pgsql/data/base/1 ... ok
initializing pg_authid ... ok
initializing dependencies ... ok
creating system views ... ok
loading system objects' descriptions ... ok
creating conversions ... FATAL:  could not access file
"$libdir/ascii_and_mic": No such file or directory
STATEMENT:  CREATE OR REPLACE FUNCTION ascii_to_mic (INTEGER, INTEGER,
CSTRING, INTERNAL, INTEGER) RETURNS VOID AS '$libdir/ascii_and_mic',
'ascii_to_mic' LANGUAGE C STRICT;
 
child process exited with exit code 1
initdb: removing contents of data directory "/usr/local/pgsql/data"
-------------------script log 1------------------------------

I've executed the pg_config command and have included this here as it may provide some clues. Note that the library itself (ascii_to_mic.o) *is* built.

-------------------script log 2------------------------------
%pg_config
BINDIR = /usr/local/bin
DOCDIR = /usr/local/share/doc/postgresql
INCLUDEDIR = /usr/local/include
PKGINCLUDEDIR = /usr/local/include/postgresql
INCLUDEDIR-SERVER = /usr/local/include/postgresql/server
LIBDIR = /usr/local/lib
PKGLIBDIR = /usr/local/lib/postgresql
LOCALEDIR = /usr/local/share/locale
MANDIR = /usr/local/man
SHAREDIR = /usr/local/share/postgresql
SYSCONFDIR = /usr/local/etc/postgresql
PGXS = /usr/local/lib/postgresql/pgxs/src/makefiles/pgxs.mk
CONFIGURE = '--with-libraries=/usr/local/lib'
'--with-includes=/usr/local/include' '--enable-thread-safety'
'--with-docdir=/usr/local/share/doc/postgresql' '--with-openssl'
'--with-system-tzdata=/usr/share/zoneinfo' '--enable-nls'
'--prefix=/usr/local' '--mandir=/usr/local/man' '--infodir=/usr/local/info/'
'--build=i386-portbld-freebsd7.0' 'CC=cc' 'CFLAGS=-O2 -fno-strict-aliasing
-pipe ' 'LDFLAGS= -pthread -rpath=/usr/lib:/usr/local/lib'
'build_alias=i386-portbld-freebsd7.0'
CC = cc
CPPFLAGS = -I/usr/local/include
CFLAGS = -O2 -fno-strict-aliasing -pipe  -Wall -Wmissing-prototypes
-Wpointer-arith -Winline -Wdeclaration-after-statement -Wendif-labels
-fno-strict-aliasing -fwrapv
CFLAGS_SL = -fPIC -DPIC
LDFLAGS = -pthread -rpath=/usr/lib:/usr/local/lib -L/usr/local/lib
-Wl,-R'/usr/local/lib'
LDFLAGS_SL = 
LIBS = -lpgport -lintl -lssl -lcrypto -lz -lreadline -lcrypt -lm 
VERSION = PostgreSQL 8.3.6
-------------------script log 2------------------------------

I have submitted this log to the postgresql online 
pgsql-bugs-owner at postgresql.org (bug number #4671) and they don't have an idea of how to resolve this


>How-To-Repeat:
The problem occurs continuously and can be repeated at will.
>Fix:


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