Re: initdb failure with Postgres 8.4.4

On 12/09/2010 03:36 PM, BRUSSER Michael wrote:
> No, we do not use --with-system-tzdata option.
> I looked at the makefile and at the output of pg_config. We may need to do some cleanup there, but I did not pick any clues.
> The problem occurs on all our UNIX platforms.
> Is there anything I could do to shed more light on it?
> I can post the output of pg_config if it helps, or try to run initdb with truss or strace.
>

Yes, please show us the pg_config (and please don't top-post).
cheers
andrew

---------------------------------------------------------------------------------------------------

I tried to build Postgres with minimal options outside of our normal build framework to isolate possible interference, but got the same result.

configure \
--prefix=$prefix \
--without-readline \
--without-zlib \
--without-tcl \
--without-perl \
--disable-rpath \
2>&1 | tee _configure.log

- gmake, gmake check, gmake install -- all clean

- initdb:
initdb -D /home/<local_path>/pgdata -L /home/<local_path>/share -E UTF8 --locale=C \
-d 2> log2 > log1

log1 ends with line
creating template1 database in /home/<local_path>/pgdata/base/1 ...

In log2 I got the same errors as I mentioned earlier:
LOG: could not open directory "/home/<build-path>/.../share/timezone": No such file or directory
... ...

Directories timezone and timezonesets exist in /home/<local_path>/share, pointed to by the -L option
The local share dir has the same contents as the build share dir.

% pg_config
BINDIR = /home/<build-path>/build/Linux/qe_x86_64/bin
DOCDIR = /home/<build-path>/build/Linux/qe_x86_64/share/doc
HTMLDIR = /home/<build-path>/build/Linux/qe_x86_64/share/doc
INCLUDEDIR = /home/<build-path>/build/Linux/qe_x86_64/include
PKGINCLUDEDIR = /home/<build-path>/build/Linux/qe_x86_64/include
INCLUDEDIR-SERVER = /home/<build-path>/build/Linux/qe_x86_64/include/server
LIBDIR = /home/<build-path>/build/Linux/qe_x86_64/lib
PKGLIBDIR = /home/<build-path>/build/Linux/qe_x86_64/lib
LOCALEDIR = /home/<build-path>/build/Linux/qe_x86_64/share/locale
MANDIR = /home/<build-path>/build/Linux/qe_x86_64/share/man
SHAREDIR = /home/<build-path>/build/Linux/qe_x86_64/share
SYSCONFDIR = /home/<build-path>/build/Linux/qe_x86_64/etc
PGXS = /home/<build-path>/build/Linux/qe_x86_64/lib/pgxs/src/makefiles/pgxs.mk
CONFIGURE = '--prefix=/home/<build-path>/build/Linux/qe_x86_64' '--without-readline' '--without-zlib'
CC = gcc
CPPFLAGS = -D_GNU_SOURCE
CFLAGS = -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv
CFLAGS_SL = -fpic
LDFLAGS = -Wl,--as-needed -Wl,-rpath,'/home/<build-path>/build/Linux/qe_x86_64/lib'
LDFLAGS_SL =
LIBS = -lpgport -lcrypt -ldl -lm
VERSION = PostgreSQL 8.4.4

This is probably not helpful, but just in case
% strings initdb | grep <build-path>
/home/<build-path>/build/Linux/qe_x86_64/bin
/home/<build-path>/build/Linux/qe_x86_64/share/man
/home/<build-path>/build/Linux/qe_x86_64/share/doc/
/home/<build-path>/build/Linux/qe_x86_64/share/locale
/home/<build-path>/build/Linux/qe_x86_64/lib
/home/<build-path>/build/Linux/qe_x86_64/include/server
/home/<build-path>/build/Linux/qe_x86_64/include
/home/<build-path>/build/Linux/qe_x86_64/etc
/home/<build-path>/build/Linux/qe_x86_64/share

Thank you,
Michael.

This email and any attachments are intended solely for the use of the individual or entity to whom it is addressed and may be confidential and/or privileged. If you are not one of the named recipients or have received this email in error, (i) you should not read, disclose, or copy it, (ii) please notify sender of your receipt by reply email and delete this email and all attachments, (iii) Dassault Systemes does not accept or assume any liability or responsibility for any use of or reliance on this email.For other languages, go to http://www.3ds.com/terms/email-disclaimer.