Skip site navigation (1) Skip section navigation (2)

BUG #4671: Cluster Initialisation Fails on FreeBSD

From: "Peter Woodward" <peter(at)petew(dot)org(dot)uk>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4671: Cluster Initialisation Fails on FreeBSD
Date: 2009-02-22 10:03:02
Message-ID: 200902221003.n1MA3262012221@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      4671
Logged by:          Peter Woodward
Email address:      peter(at)petew(dot)org(dot)uk
PostgreSQL version: 8.3
Operating system:   FreeBSD 7.0
Description:        Cluster Initialisation Fails on FreeBSD
Details: 

The following script shows that when I try to create the cluster using the
script initdb, then the script fails.

I'd initially installed direct from the ports directory. This failed (with
the same error). I then decided to build directly from the sources. The
build worked, but as before the cluster initialisation script fails.

I also include output from the pg_config commmand.

%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(dot)cse(dot)buffalo(dot)edu:/usr/obj/usr/src/sys/GENERIC  i386
%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"


%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


Thanks,
Peter Woodward

Responses

pgsql-bugs by date

Next:From: Darren ReedDate: 2009-02-22 11:29:54
Subject: Re: could not read block 77 of relation 1663/16385/388818775
Previous:From: Tom LaneDate: 2009-02-22 04:48:48
Subject: Re: BUG #4670: Cannot get domain constraint names from psql

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group