Thread: make unsuccessful on mac os x 10.2
My guess is that the new compiler in 10.2 is not compatible with postgres. Here is the output from configure and make: [mikef-ti:/database/postgresql-7.2.2] mikef% ./configure --with-java loading cache ./config.cache checking host system type... powerpc-apple-darwin6.0 checking which template to use... darwin checking whether to build with locale support... no checking whether to build with recode support... no checking whether to build with multibyte character support... no checking whether NLS is wanted... no checking for default port number... 5432 checking for default soft limit on number of connections... 32 checking for gcc... (cached) gcc checking whether the C compiler (gcc ) works... yes checking whether the C compiler (gcc ) is a cross-compiler... no checking whether we are using GNU C... (cached) yes checking whether gcc accepts -g... (cached) yes using CFLAGS=-g -O2 checking whether the C compiler (gcc -traditional-cpp -g -O2 ) works... yes checking whether the C compiler (gcc -traditional-cpp -g -O2 ) is a cross-compiler... no checking for Cygwin environment... (cached) no checking for mingw32 environment... (cached) no checking for executable suffix... (cached) no checking how to run the C preprocessor... (cached) gcc -traditional-cpp -E checking whether gcc -traditional-cpp needs -traditional... (cached) no checking whether to build with Tcl... no checking whether to build with Tk... no checking whether to build Perl modules... no checking whether to build Python modules... no checking whether to build Java/JDBC tools... yes checking for jakarta-ant... no checking for ant... /java/jakarta-ant-1.5/bin/ant checking whether /java/jakarta-ant-1.5/bin/ant works... yes checking whether to build with PAM support... no checking whether to build the ODBC driver... no checking whether to build C++ modules... no using CPPFLAGS= using LDFLAGS= checking for mawk... (cached) awk checking for flex... (cached) /usr/bin/flex checking whether ln -s works... (cached) yes checking for ld used by GCC... (cached) /usr/bin/ld checking if the linker (/usr/bin/ld) is GNU ld... (cached) no checking for ranlib... (cached) ranlib checking for lorder... (cached) lorder checking for tar... (cached) /usr/bin/tar checking for bison... (cached) bison -y checking for perl... (cached) /usr/bin/perl checking for readline... (cached) no checking for library containing using_history... (cached) no checking for main in -lbsd... (cached) no checking for setproctitle in -lutil... (cached) no checking for main in -lm... (cached) yes checking for main in -ldl... (cached) no checking for main in -lsocket... (cached) no checking for main in -lnsl... (cached) no checking for main in -lipc... (cached) no checking for main in -lIPC... (cached) no checking for main in -llc... (cached) no checking for main in -ldld... (cached) no checking for main in -lld... (cached) no checking for main in -lcompat... (cached) no checking for main in -lBSD... (cached) no checking for main in -lgen... (cached) no checking for main in -lPW... (cached) no checking for main in -lresolv... (cached) no checking for main in -lunix... (cached) no checking for library containing crypt... (cached) none required checking for __inet_ntoa in -lbind... (cached) no checking for inflate in -lz... (cached) yes checking for library containing fdatasync... (cached) no checking for crypt.h... (cached) no checking for dld.h... (cached) no checking for endian.h... (cached) no checking for fp_class.h... (cached) no checking for getopt.h... (cached) no checking for ieeefp.h... (cached) no checking for pwd.h... (cached) yes checking for sys/ipc.h... (cached) yes checking for sys/pstat.h... (cached) no checking for sys/select.h... (cached) yes checking for sys/sem.h... (cached) yes checking for sys/socket.h... (cached) yes checking for sys/shm.h... (cached) yes checking for sys/types.h... (cached) yes checking for sys/un.h... (cached) yes checking for termios.h... (cached) yes checking for kernel/OS.h... (cached) no checking for kernel/image.h... (cached) no checking for SupportDefs.h... (cached) no checking for netinet/in.h... (cached) yes checking for netinet/tcp.h... yes checking whether string.h and strings.h may both be included... (cached) yes checking for readline/readline.h... (cached) no checking for readline.h... (cached) no checking for readline/history.h... (cached) no checking for history.h... (cached) no checking for working const... (cached) yes checking for inline... (cached) inline checking for preprocessor stringizing operator... (cached) yes checking for signed types... (cached) yes checking for volatile... (cached) yes checking whether struct tm is in sys/time.h or time.h... (cached) time.h checking for tm_zone in struct tm... (cached) yes checking for union semun... (cached) yes checking for struct cmsgcred... (cached) no checking for struct fcred... (cached) no checking for struct sockcred... (cached) no checking for struct sockaddr_un... (cached) yes checking for int timezone... (cached) no checking types of arguments for accept()... (cached) int, struct sockaddr *, int * checking whether gettimeofday takes only one argument... (cached) no checking for 8-bit clean memcmp... (cached) yes checking for fcvt... (cached) yes checking for getopt_long... (cached) no checking for memmove... (cached) yes checking for pstat... (cached) no checking for setproctitle... (cached) no checking for setsid... (cached) yes checking for sigprocmask... (cached) yes checking for sysconf... (cached) yes checking for waitpid... (cached) yes checking for dlopen... (cached) no checking for fdatasync... (cached) no checking for PS_STRINGS... (cached) no checking for snprintf... (cached) yes checking for vsnprintf... (cached) yes checking for isinf... (cached) yes checking for getrusage... (cached) yes checking for srandom... (cached) yes checking for gethostname... (cached) yes checking for random... (cached) yes checking for inet_aton... (cached) yes checking for strerror... (cached) yes checking for strdup... (cached) yes checking for strtol... (cached) yes checking for strtoul... (cached) yes checking for strcasecmp... (cached) yes checking for cbrt... (cached) yes checking for rint... (cached) yes checking for rl_completion_append_character... no checking for rl_completion_matches... (cached) no checking for rl_filename_completion_function... (cached) no checking for finite... yes checking for sigsetjmp... yes checking for optreset... (cached) yes checking test program... ok checking whether long int is 64 bits... (cached) no checking whether long long int is 64 bits... (cached) yes checking whether snprintf handles 'long long int' as %lld... yes checking for strtoll... (cached) yes checking for strtoull... (cached) yes checking for atexit... (cached) yes checking size of unsigned long... (cached) 4 checking alignment of short... (cached) 2 checking alignment of int... (cached) 4 checking alignment of long... (cached) 4 checking alignment of long long int... (cached) 4 checking alignment of double... (cached) 4 checking for int8... (cached) no checking for uint8... (cached) no checking for int64... (cached) no checking for uint64... (cached) no checking for sig_atomic_t... (cached) yes checking for POSIX signal interface... (cached) yes checking for onsgmls... no checking for nsgmls... no updating cache ./config.cache creating ./config.status creating GNUmakefile creating src/GNUmakefile creating src/Makefile.global creating src/backend/port/Makefile creating src/include/pg_config.h src/include/pg_config.h is unchanged linking ./src/backend/port/dynloader/darwin.c to src/backend/port/dynloader.c linking ./src/backend/port/dynloader/darwin.h to src/include/dynloader.h linking ./src/include/port/darwin.h to src/include/pg_config_os.h linking ./src/makefiles/Makefile.darwin to src/Makefile.port linking ./src/backend/port/tas/dummy.s to src/backend/port/tas.s [mikef-ti:/database/postgresql-7.2.2] mikef% make make -C doc all make[1]: Nothing to be done for `all'. make -C src all make -C backend all make -C access all make -C common SUBSYS.o make[4]: `SUBSYS.o' is up to date. make -C gist SUBSYS.o make[4]: `SUBSYS.o' is up to date. make -C hash SUBSYS.o make[4]: `SUBSYS.o' is up to date. make -C heap SUBSYS.o make[4]: `SUBSYS.o' is up to date. make -C index SUBSYS.o make[4]: `SUBSYS.o' is up to date. make -C nbtree SUBSYS.o make[4]: `SUBSYS.o' is up to date. make -C rtree SUBSYS.o make[4]: `SUBSYS.o' is up to date. make -C transam SUBSYS.o make[4]: `SUBSYS.o' is up to date. make -C bootstrap all make[3]: Nothing to be done for `all'. make -C catalog all make[3]: Nothing to be done for `all'. make -C parser all make[3]: Nothing to be done for `all'. make -C commands all make[3]: Nothing to be done for `all'. make -C executor all make[3]: Nothing to be done for `all'. make -C lib all make[3]: Nothing to be done for `all'. make -C libpq all make[3]: Nothing to be done for `all'. make -C main all make[3]: Nothing to be done for `all'. make -C nodes all make[3]: Nothing to be done for `all'. make -C optimizer all make -C geqo SUBSYS.o make[4]: `SUBSYS.o' is up to date. make -C path SUBSYS.o make[4]: `SUBSYS.o' is up to date. make -C plan SUBSYS.o make[4]: `SUBSYS.o' is up to date. make -C prep SUBSYS.o make[4]: `SUBSYS.o' is up to date. make -C util SUBSYS.o make[4]: `SUBSYS.o' is up to date. make -C port all make -C darwin all gcc -traditional-cpp -g -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -I../../../../src/include -c -o sem.o sem.c In file included from sem.c:30: ../../../../src/include/port/darwin/sem.h:66: warning: `union semun' declared inside parameter list ../../../../src/include/port/darwin/sem.h:66: warning: its scope is only this definition or declaration, which is probably not what you want ../../../../src/include/port/darwin/sem.h:66: warning: parameter has incomplete type sem.c:67: warning: `union semun' declared inside parameter list sem.c:68: parameter `arg' has incomplete type make[4]: *** [sem.o] Error 1 make[3]: *** [darwin.dir] Error 2 make[2]: *** [port-recursive] Error 2 make[1]: *** [all] Error 2 make: *** [all] Error 2 [mikef-ti:/database/postgresql-7.2.2] mikef% Michael Fortin
Get 7.3beta1 for OSX 10.2. --------------------------------------------------------------------------- Michael Fortin wrote: > My guess is that the new compiler in 10.2 is not compatible with > postgres. Here is the output from configure and make: > > [mikef-ti:/database/postgresql-7.2.2] mikef% ./configure --with-java > loading cache ./config.cache > checking host system type... powerpc-apple-darwin6.0 > checking which template to use... darwin > checking whether to build with locale support... no > checking whether to build with recode support... no > checking whether to build with multibyte character support... no > checking whether NLS is wanted... no > checking for default port number... 5432 > checking for default soft limit on number of connections... 32 > checking for gcc... (cached) gcc > checking whether the C compiler (gcc ) works... yes > checking whether the C compiler (gcc ) is a cross-compiler... no > checking whether we are using GNU C... (cached) yes > checking whether gcc accepts -g... (cached) yes > using CFLAGS=-g -O2 > checking whether the C compiler (gcc -traditional-cpp -g -O2 ) works... > yes > checking whether the C compiler (gcc -traditional-cpp -g -O2 ) is a > cross-compiler... no > checking for Cygwin environment... (cached) no > checking for mingw32 environment... (cached) no > checking for executable suffix... (cached) no > checking how to run the C preprocessor... (cached) gcc -traditional-cpp > -E > checking whether gcc -traditional-cpp needs -traditional... (cached) no > checking whether to build with Tcl... no > checking whether to build with Tk... no > checking whether to build Perl modules... no > checking whether to build Python modules... no > checking whether to build Java/JDBC tools... yes > checking for jakarta-ant... no > checking for ant... /java/jakarta-ant-1.5/bin/ant > checking whether /java/jakarta-ant-1.5/bin/ant works... yes > checking whether to build with PAM support... no > checking whether to build the ODBC driver... no > checking whether to build C++ modules... no > using CPPFLAGS= > using LDFLAGS= > checking for mawk... (cached) awk > checking for flex... (cached) /usr/bin/flex > checking whether ln -s works... (cached) yes > checking for ld used by GCC... (cached) /usr/bin/ld > checking if the linker (/usr/bin/ld) is GNU ld... (cached) no > checking for ranlib... (cached) ranlib > checking for lorder... (cached) lorder > checking for tar... (cached) /usr/bin/tar > checking for bison... (cached) bison -y > checking for perl... (cached) /usr/bin/perl > checking for readline... (cached) no > checking for library containing using_history... (cached) no > checking for main in -lbsd... (cached) no > checking for setproctitle in -lutil... (cached) no > checking for main in -lm... (cached) yes > checking for main in -ldl... (cached) no > checking for main in -lsocket... (cached) no > checking for main in -lnsl... (cached) no > checking for main in -lipc... (cached) no > checking for main in -lIPC... (cached) no > checking for main in -llc... (cached) no > checking for main in -ldld... (cached) no > checking for main in -lld... (cached) no > checking for main in -lcompat... (cached) no > checking for main in -lBSD... (cached) no > checking for main in -lgen... (cached) no > checking for main in -lPW... (cached) no > checking for main in -lresolv... (cached) no > checking for main in -lunix... (cached) no > checking for library containing crypt... (cached) none required > checking for __inet_ntoa in -lbind... (cached) no > checking for inflate in -lz... (cached) yes > checking for library containing fdatasync... (cached) no > checking for crypt.h... (cached) no > checking for dld.h... (cached) no > checking for endian.h... (cached) no > checking for fp_class.h... (cached) no > checking for getopt.h... (cached) no > checking for ieeefp.h... (cached) no > checking for pwd.h... (cached) yes > checking for sys/ipc.h... (cached) yes > checking for sys/pstat.h... (cached) no > checking for sys/select.h... (cached) yes > checking for sys/sem.h... (cached) yes > checking for sys/socket.h... (cached) yes > checking for sys/shm.h... (cached) yes > checking for sys/types.h... (cached) yes > checking for sys/un.h... (cached) yes > checking for termios.h... (cached) yes > checking for kernel/OS.h... (cached) no > checking for kernel/image.h... (cached) no > checking for SupportDefs.h... (cached) no > checking for netinet/in.h... (cached) yes > checking for netinet/tcp.h... yes > checking whether string.h and strings.h may both be included... > (cached) yes > checking for readline/readline.h... (cached) no > checking for readline.h... (cached) no > checking for readline/history.h... (cached) no > checking for history.h... (cached) no > checking for working const... (cached) yes > checking for inline... (cached) inline > checking for preprocessor stringizing operator... (cached) yes > checking for signed types... (cached) yes > checking for volatile... (cached) yes > checking whether struct tm is in sys/time.h or time.h... (cached) time.h > checking for tm_zone in struct tm... (cached) yes > checking for union semun... (cached) yes > checking for struct cmsgcred... (cached) no > checking for struct fcred... (cached) no > checking for struct sockcred... (cached) no > checking for struct sockaddr_un... (cached) yes > checking for int timezone... (cached) no > checking types of arguments for accept()... (cached) int, struct > sockaddr *, int * > checking whether gettimeofday takes only one argument... (cached) no > checking for 8-bit clean memcmp... (cached) yes > checking for fcvt... (cached) yes > checking for getopt_long... (cached) no > checking for memmove... (cached) yes > checking for pstat... (cached) no > checking for setproctitle... (cached) no > checking for setsid... (cached) yes > checking for sigprocmask... (cached) yes > checking for sysconf... (cached) yes > checking for waitpid... (cached) yes > checking for dlopen... (cached) no > checking for fdatasync... (cached) no > checking for PS_STRINGS... (cached) no > checking for snprintf... (cached) yes > checking for vsnprintf... (cached) yes > checking for isinf... (cached) yes > checking for getrusage... (cached) yes > checking for srandom... (cached) yes > checking for gethostname... (cached) yes > checking for random... (cached) yes > checking for inet_aton... (cached) yes > checking for strerror... (cached) yes > checking for strdup... (cached) yes > checking for strtol... (cached) yes > checking for strtoul... (cached) yes > checking for strcasecmp... (cached) yes > checking for cbrt... (cached) yes > checking for rint... (cached) yes > checking for rl_completion_append_character... no > checking for rl_completion_matches... (cached) no > checking for rl_filename_completion_function... (cached) no > checking for finite... yes > checking for sigsetjmp... yes > checking for optreset... (cached) yes > checking test program... ok > checking whether long int is 64 bits... (cached) no > checking whether long long int is 64 bits... (cached) yes > checking whether snprintf handles 'long long int' as %lld... yes > checking for strtoll... (cached) yes > checking for strtoull... (cached) yes > checking for atexit... (cached) yes > checking size of unsigned long... (cached) 4 > checking alignment of short... (cached) 2 > checking alignment of int... (cached) 4 > checking alignment of long... (cached) 4 > checking alignment of long long int... (cached) 4 > checking alignment of double... (cached) 4 > checking for int8... (cached) no > checking for uint8... (cached) no > checking for int64... (cached) no > checking for uint64... (cached) no > checking for sig_atomic_t... (cached) yes > checking for POSIX signal interface... (cached) yes > checking for onsgmls... no > checking for nsgmls... no > updating cache ./config.cache > creating ./config.status > creating GNUmakefile > creating src/GNUmakefile > creating src/Makefile.global > creating src/backend/port/Makefile > creating src/include/pg_config.h > src/include/pg_config.h is unchanged > linking ./src/backend/port/dynloader/darwin.c to > src/backend/port/dynloader.c > linking ./src/backend/port/dynloader/darwin.h to src/include/dynloader.h > linking ./src/include/port/darwin.h to src/include/pg_config_os.h > linking ./src/makefiles/Makefile.darwin to src/Makefile.port > linking ./src/backend/port/tas/dummy.s to src/backend/port/tas.s > [mikef-ti:/database/postgresql-7.2.2] mikef% make > make -C doc all > make[1]: Nothing to be done for `all'. > make -C src all > make -C backend all > make -C access all > make -C common SUBSYS.o > make[4]: `SUBSYS.o' is up to date. > make -C gist SUBSYS.o > make[4]: `SUBSYS.o' is up to date. > make -C hash SUBSYS.o > make[4]: `SUBSYS.o' is up to date. > make -C heap SUBSYS.o > make[4]: `SUBSYS.o' is up to date. > make -C index SUBSYS.o > make[4]: `SUBSYS.o' is up to date. > make -C nbtree SUBSYS.o > make[4]: `SUBSYS.o' is up to date. > make -C rtree SUBSYS.o > make[4]: `SUBSYS.o' is up to date. > make -C transam SUBSYS.o > make[4]: `SUBSYS.o' is up to date. > make -C bootstrap all > make[3]: Nothing to be done for `all'. > make -C catalog all > make[3]: Nothing to be done for `all'. > make -C parser all > make[3]: Nothing to be done for `all'. > make -C commands all > make[3]: Nothing to be done for `all'. > make -C executor all > make[3]: Nothing to be done for `all'. > make -C lib all > make[3]: Nothing to be done for `all'. > make -C libpq all > make[3]: Nothing to be done for `all'. > make -C main all > make[3]: Nothing to be done for `all'. > make -C nodes all > make[3]: Nothing to be done for `all'. > make -C optimizer all > make -C geqo SUBSYS.o > make[4]: `SUBSYS.o' is up to date. > make -C path SUBSYS.o > make[4]: `SUBSYS.o' is up to date. > make -C plan SUBSYS.o > make[4]: `SUBSYS.o' is up to date. > make -C prep SUBSYS.o > make[4]: `SUBSYS.o' is up to date. > make -C util SUBSYS.o > make[4]: `SUBSYS.o' is up to date. > make -C port all > make -C darwin all > gcc -traditional-cpp -g -O2 -Wall -Wmissing-prototypes > -Wmissing-declarations -I../../../../src/include -c -o sem.o sem.c > In file included from sem.c:30: > ../../../../src/include/port/darwin/sem.h:66: warning: `union semun' > declared inside parameter list > ../../../../src/include/port/darwin/sem.h:66: warning: its scope is > only this definition or declaration, which is probably not what you want > ../../../../src/include/port/darwin/sem.h:66: warning: parameter has > incomplete type > sem.c:67: warning: `union semun' declared inside parameter list > sem.c:68: parameter `arg' has incomplete type > make[4]: *** [sem.o] Error 1 > make[3]: *** [darwin.dir] Error 2 > make[2]: *** [port-recursive] Error 2 > make[1]: *** [all] Error 2 > make: *** [all] Error 2 > [mikef-ti:/database/postgresql-7.2.2] mikef% > > > Michael Fortin > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073
Oh, that's a strange error. I thought our beta1 worked on OSX 10.2. You are on 10.2, right? Do have have any environment variables starting with LC_*? --------------------------------------------------------------------------- Michael Fortin wrote: > Bruce, > Thanks for the reply. It installed fine but when I ran initdb this was > the output: > > [mikef-ti:/usr/local/pgsql] postgres% bin/initdb > 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 en_US. > This locale setting will prevent the use of indexes for pattern matching > operations. If that is a concern, rerun initdb with the collation order > set to "C". For more information see the Administrator's Guide. > > Fixing permissions on existing directory /usr/local/pgsql/data... ok > creating directory /usr/local/pgsql/data/base... ok > creating directory /usr/local/pgsql/data/global... ok > creating directory /usr/local/pgsql/data/pg_xlog... ok > creating directory /usr/local/pgsql/data/pg_clog... ok > creating template1 database in /usr/local/pgsql/data/base/1... Failed > to initialize lc_time to '' > ok > creating configuration files... ok > initializing pg_shadow... Failed to initialize lc_time to '' > ok > enabling unlimited row size for system tables... Failed to initialize > lc_time to '' > ok > initializing pg_depend... Failed to initialize lc_time to '' > ok > creating system views... Failed to initialize lc_time to '' > ok > loading pg_description... Failed to initialize lc_time to '' > ok > creating conversions... Failed to initialize lc_time to '' > ok > setting privileges on built-in objects... Failed to initialize lc_time > to '' > ok > vacuuming database template1... Failed to initialize lc_time to '' > ok > copying template1 to template0... Failed to initialize lc_time to '' > ok > > Success. You can now start the database server using: > > bin/postmaster -D /usr/local/pgsql/data > or > bin/pg_ctl -D /usr/local/pgsql/data -l logfile start > > --------------- > > It failed on startup afterwards. I tried the --lc-time 'en_US' flag > but it made no difference. > > Any other suggestions would be appreciated. > > Thanks, Michael > > > > > On Monday, September 9, 2002, at 10:18 PM, Bruce Momjian wrote: > > > > > Get 7.3beta1 for OSX 10.2. > > > > ----------------------------------------------------------------------- > > ---- > > > > Michael Fortin wrote: > >> My guess is that the new compiler in 10.2 is not compatible with > >> postgres. Here is the output from configure and make: > >> > >> [mikef-ti:/database/postgresql-7.2.2] mikef% ./configure --with-java > >> loading cache ./config.cache > >> checking host system type... powerpc-apple-darwin6.0 > >> checking which template to use... darwin > >> checking whether to build with locale support... no > >> checking whether to build with recode support... no > >> checking whether to build with multibyte character support... no > >> checking whether NLS is wanted... no > >> checking for default port number... 5432 > >> checking for default soft limit on number of connections... 32 > >> checking for gcc... (cached) gcc > >> checking whether the C compiler (gcc ) works... yes > >> checking whether the C compiler (gcc ) is a cross-compiler... no > >> checking whether we are using GNU C... (cached) yes > >> checking whether gcc accepts -g... (cached) yes > >> using CFLAGS=-g -O2 > >> checking whether the C compiler (gcc -traditional-cpp -g -O2 ) > >> works... > >> yes > >> checking whether the C compiler (gcc -traditional-cpp -g -O2 ) is a > >> cross-compiler... no > >> checking for Cygwin environment... (cached) no > >> checking for mingw32 environment... (cached) no > >> checking for executable suffix... (cached) no > >> checking how to run the C preprocessor... (cached) gcc > >> -traditional-cpp > >> -E > >> checking whether gcc -traditional-cpp needs -traditional... (cached) > >> no > >> checking whether to build with Tcl... no > >> checking whether to build with Tk... no > >> checking whether to build Perl modules... no > >> checking whether to build Python modules... no > >> checking whether to build Java/JDBC tools... yes > >> checking for jakarta-ant... no > >> checking for ant... /java/jakarta-ant-1.5/bin/ant > >> checking whether /java/jakarta-ant-1.5/bin/ant works... yes > >> checking whether to build with PAM support... no > >> checking whether to build the ODBC driver... no > >> checking whether to build C++ modules... no > >> using CPPFLAGS= > >> using LDFLAGS= > >> checking for mawk... (cached) awk > >> checking for flex... (cached) /usr/bin/flex > >> checking whether ln -s works... (cached) yes > >> checking for ld used by GCC... (cached) /usr/bin/ld > >> checking if the linker (/usr/bin/ld) is GNU ld... (cached) no > >> checking for ranlib... (cached) ranlib > >> checking for lorder... (cached) lorder > >> checking for tar... (cached) /usr/bin/tar > >> checking for bison... (cached) bison -y > >> checking for perl... (cached) /usr/bin/perl > >> checking for readline... (cached) no > >> checking for library containing using_history... (cached) no > >> checking for main in -lbsd... (cached) no > >> checking for setproctitle in -lutil... (cached) no > >> checking for main in -lm... (cached) yes > >> checking for main in -ldl... (cached) no > >> checking for main in -lsocket... (cached) no > >> checking for main in -lnsl... (cached) no > >> checking for main in -lipc... (cached) no > >> checking for main in -lIPC... (cached) no > >> checking for main in -llc... (cached) no > >> checking for main in -ldld... (cached) no > >> checking for main in -lld... (cached) no > >> checking for main in -lcompat... (cached) no > >> checking for main in -lBSD... (cached) no > >> checking for main in -lgen... (cached) no > >> checking for main in -lPW... (cached) no > >> checking for main in -lresolv... (cached) no > >> checking for main in -lunix... (cached) no > >> checking for library containing crypt... (cached) none required > >> checking for __inet_ntoa in -lbind... (cached) no > >> checking for inflate in -lz... (cached) yes > >> checking for library containing fdatasync... (cached) no > >> checking for crypt.h... (cached) no > >> checking for dld.h... (cached) no > >> checking for endian.h... (cached) no > >> checking for fp_class.h... (cached) no > >> checking for getopt.h... (cached) no > >> checking for ieeefp.h... (cached) no > >> checking for pwd.h... (cached) yes > >> checking for sys/ipc.h... (cached) yes > >> checking for sys/pstat.h... (cached) no > >> checking for sys/select.h... (cached) yes > >> checking for sys/sem.h... (cached) yes > >> checking for sys/socket.h... (cached) yes > >> checking for sys/shm.h... (cached) yes > >> checking for sys/types.h... (cached) yes > >> checking for sys/un.h... (cached) yes > >> checking for termios.h... (cached) yes > >> checking for kernel/OS.h... (cached) no > >> checking for kernel/image.h... (cached) no > >> checking for SupportDefs.h... (cached) no > >> checking for netinet/in.h... (cached) yes > >> checking for netinet/tcp.h... yes > >> checking whether string.h and strings.h may both be included... > >> (cached) yes > >> checking for readline/readline.h... (cached) no > >> checking for readline.h... (cached) no > >> checking for readline/history.h... (cached) no > >> checking for history.h... (cached) no > >> checking for working const... (cached) yes > >> checking for inline... (cached) inline > >> checking for preprocessor stringizing operator... (cached) yes > >> checking for signed types... (cached) yes > >> checking for volatile... (cached) yes > >> checking whether struct tm is in sys/time.h or time.h... (cached) > >> time.h > >> checking for tm_zone in struct tm... (cached) yes > >> checking for union semun... (cached) yes > >> checking for struct cmsgcred... (cached) no > >> checking for struct fcred... (cached) no > >> checking for struct sockcred... (cached) no > >> checking for struct sockaddr_un... (cached) yes > >> checking for int timezone... (cached) no > >> checking types of arguments for accept()... (cached) int, struct > >> sockaddr *, int * > >> checking whether gettimeofday takes only one argument... (cached) no > >> checking for 8-bit clean memcmp... (cached) yes > >> checking for fcvt... (cached) yes > >> checking for getopt_long... (cached) no > >> checking for memmove... (cached) yes > >> checking for pstat... (cached) no > >> checking for setproctitle... (cached) no > >> checking for setsid... (cached) yes > >> checking for sigprocmask... (cached) yes > >> checking for sysconf... (cached) yes > >> checking for waitpid... (cached) yes > >> checking for dlopen... (cached) no > >> checking for fdatasync... (cached) no > >> checking for PS_STRINGS... (cached) no > >> checking for snprintf... (cached) yes > >> checking for vsnprintf... (cached) yes > >> checking for isinf... (cached) yes > >> checking for getrusage... (cached) yes > >> checking for srandom... (cached) yes > >> checking for gethostname... (cached) yes > >> checking for random... (cached) yes > >> checking for inet_aton... (cached) yes > >> checking for strerror... (cached) yes > >> checking for strdup... (cached) yes > >> checking for strtol... (cached) yes > >> checking for strtoul... (cached) yes > >> checking for strcasecmp... (cached) yes > >> checking for cbrt... (cached) yes > >> checking for rint... (cached) yes > >> checking for rl_completion_append_character... no > >> checking for rl_completion_matches... (cached) no > >> checking for rl_filename_completion_function... (cached) no > >> checking for finite... yes > >> checking for sigsetjmp... yes > >> checking for optreset... (cached) yes > >> checking test program... ok > >> checking whether long int is 64 bits... (cached) no > >> checking whether long long int is 64 bits... (cached) yes > >> checking whether snprintf handles 'long long int' as %lld... yes > >> checking for strtoll... (cached) yes > >> checking for strtoull... (cached) yes > >> checking for atexit... (cached) yes > >> checking size of unsigned long... (cached) 4 > >> checking alignment of short... (cached) 2 > >> checking alignment of int... (cached) 4 > >> checking alignment of long... (cached) 4 > >> checking alignment of long long int... (cached) 4 > >> checking alignment of double... (cached) 4 > >> checking for int8... (cached) no > >> checking for uint8... (cached) no > >> checking for int64... (cached) no > >> checking for uint64... (cached) no > >> checking for sig_atomic_t... (cached) yes > >> checking for POSIX signal interface... (cached) yes > >> checking for onsgmls... no > >> checking for nsgmls... no > >> updating cache ./config.cache > >> creating ./config.status > >> creating GNUmakefile > >> creating src/GNUmakefile > >> creating src/Makefile.global > >> creating src/backend/port/Makefile > >> creating src/include/pg_config.h > >> src/include/pg_config.h is unchanged > >> linking ./src/backend/port/dynloader/darwin.c to > >> src/backend/port/dynloader.c > >> linking ./src/backend/port/dynloader/darwin.h to > >> src/include/dynloader.h > >> linking ./src/include/port/darwin.h to src/include/pg_config_os.h > >> linking ./src/makefiles/Makefile.darwin to src/Makefile.port > >> linking ./src/backend/port/tas/dummy.s to src/backend/port/tas.s > >> [mikef-ti:/database/postgresql-7.2.2] mikef% make > >> make -C doc all > >> make[1]: Nothing to be done for `all'. > >> make -C src all > >> make -C backend all > >> make -C access all > >> make -C common SUBSYS.o > >> make[4]: `SUBSYS.o' is up to date. > >> make -C gist SUBSYS.o > >> make[4]: `SUBSYS.o' is up to date. > >> make -C hash SUBSYS.o > >> make[4]: `SUBSYS.o' is up to date. > >> make -C heap SUBSYS.o > >> make[4]: `SUBSYS.o' is up to date. > >> make -C index SUBSYS.o > >> make[4]: `SUBSYS.o' is up to date. > >> make -C nbtree SUBSYS.o > >> make[4]: `SUBSYS.o' is up to date. > >> make -C rtree SUBSYS.o > >> make[4]: `SUBSYS.o' is up to date. > >> make -C transam SUBSYS.o > >> make[4]: `SUBSYS.o' is up to date. > >> make -C bootstrap all > >> make[3]: Nothing to be done for `all'. > >> make -C catalog all > >> make[3]: Nothing to be done for `all'. > >> make -C parser all > >> make[3]: Nothing to be done for `all'. > >> make -C commands all > >> make[3]: Nothing to be done for `all'. > >> make -C executor all > >> make[3]: Nothing to be done for `all'. > >> make -C lib all > >> make[3]: Nothing to be done for `all'. > >> make -C libpq all > >> make[3]: Nothing to be done for `all'. > >> make -C main all > >> make[3]: Nothing to be done for `all'. > >> make -C nodes all > >> make[3]: Nothing to be done for `all'. > >> make -C optimizer all > >> make -C geqo SUBSYS.o > >> make[4]: `SUBSYS.o' is up to date. > >> make -C path SUBSYS.o > >> make[4]: `SUBSYS.o' is up to date. > >> make -C plan SUBSYS.o > >> make[4]: `SUBSYS.o' is up to date. > >> make -C prep SUBSYS.o > >> make[4]: `SUBSYS.o' is up to date. > >> make -C util SUBSYS.o > >> make[4]: `SUBSYS.o' is up to date. > >> make -C port all > >> make -C darwin all > >> gcc -traditional-cpp -g -O2 -Wall -Wmissing-prototypes > >> -Wmissing-declarations -I../../../../src/include -c -o sem.o sem.c > >> In file included from sem.c:30: > >> ../../../../src/include/port/darwin/sem.h:66: warning: `union semun' > >> declared inside parameter list > >> ../../../../src/include/port/darwin/sem.h:66: warning: its scope is > >> only this definition or declaration, which is probably not what you > >> want > >> ../../../../src/include/port/darwin/sem.h:66: warning: parameter has > >> incomplete type > >> sem.c:67: warning: `union semun' declared inside parameter list > >> sem.c:68: parameter `arg' has incomplete type > >> make[4]: *** [sem.o] Error 1 > >> make[3]: *** [darwin.dir] Error 2 > >> make[2]: *** [port-recursive] Error 2 > >> make[1]: *** [all] Error 2 > >> make: *** [all] Error 2 > >> [mikef-ti:/database/postgresql-7.2.2] mikef% > >> > >> > >> Michael Fortin > >> > >> > >> ---------------------------(end of > >> broadcast)--------------------------- > >> TIP 6: Have you searched our list archives? > >> > >> http://archives.postgresql.org > >> > > > > -- > > Bruce Momjian | http://candle.pha.pa.us > > pgman@candle.pha.pa.us | (610) 359-1001 > > + If your life is a hard drive, | 13 Roberts Road > > + Christ can be your backup. | Newtown Square, Pennsylvania > > 19073 > > > > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073
Bruce, Thanks for the reply. It installed fine but when I ran initdb this was the output: [mikef-ti:/usr/local/pgsql] postgres% bin/initdb 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 en_US. This locale setting will prevent the use of indexes for pattern matching operations. If that is a concern, rerun initdb with the collation order set to "C". For more information see the Administrator's Guide. Fixing permissions on existing directory /usr/local/pgsql/data... ok creating directory /usr/local/pgsql/data/base... ok creating directory /usr/local/pgsql/data/global... ok creating directory /usr/local/pgsql/data/pg_xlog... ok creating directory /usr/local/pgsql/data/pg_clog... ok creating template1 database in /usr/local/pgsql/data/base/1... Failed to initialize lc_time to '' ok creating configuration files... ok initializing pg_shadow... Failed to initialize lc_time to '' ok enabling unlimited row size for system tables... Failed to initialize lc_time to '' ok initializing pg_depend... Failed to initialize lc_time to '' ok creating system views... Failed to initialize lc_time to '' ok loading pg_description... Failed to initialize lc_time to '' ok creating conversions... Failed to initialize lc_time to '' ok setting privileges on built-in objects... Failed to initialize lc_time to '' ok vacuuming database template1... Failed to initialize lc_time to '' ok copying template1 to template0... Failed to initialize lc_time to '' ok Success. You can now start the database server using: bin/postmaster -D /usr/local/pgsql/data or bin/pg_ctl -D /usr/local/pgsql/data -l logfile start --------------- It failed on startup afterwards. I tried the --lc-time 'en_US' flag but it made no difference. Any other suggestions would be appreciated. Thanks, Michael On Monday, September 9, 2002, at 10:18 PM, Bruce Momjian wrote: > > Get 7.3beta1 for OSX 10.2. > > ----------------------------------------------------------------------- > ---- > > Michael Fortin wrote: >> My guess is that the new compiler in 10.2 is not compatible with >> postgres. Here is the output from configure and make: >> >> [mikef-ti:/database/postgresql-7.2.2] mikef% ./configure --with-java >> loading cache ./config.cache >> checking host system type... powerpc-apple-darwin6.0 >> checking which template to use... darwin >> checking whether to build with locale support... no >> checking whether to build with recode support... no >> checking whether to build with multibyte character support... no >> checking whether NLS is wanted... no >> checking for default port number... 5432 >> checking for default soft limit on number of connections... 32 >> checking for gcc... (cached) gcc >> checking whether the C compiler (gcc ) works... yes >> checking whether the C compiler (gcc ) is a cross-compiler... no >> checking whether we are using GNU C... (cached) yes >> checking whether gcc accepts -g... (cached) yes >> using CFLAGS=-g -O2 >> checking whether the C compiler (gcc -traditional-cpp -g -O2 ) >> works... >> yes >> checking whether the C compiler (gcc -traditional-cpp -g -O2 ) is a >> cross-compiler... no >> checking for Cygwin environment... (cached) no >> checking for mingw32 environment... (cached) no >> checking for executable suffix... (cached) no >> checking how to run the C preprocessor... (cached) gcc >> -traditional-cpp >> -E >> checking whether gcc -traditional-cpp needs -traditional... (cached) >> no >> checking whether to build with Tcl... no >> checking whether to build with Tk... no >> checking whether to build Perl modules... no >> checking whether to build Python modules... no >> checking whether to build Java/JDBC tools... yes >> checking for jakarta-ant... no >> checking for ant... /java/jakarta-ant-1.5/bin/ant >> checking whether /java/jakarta-ant-1.5/bin/ant works... yes >> checking whether to build with PAM support... no >> checking whether to build the ODBC driver... no >> checking whether to build C++ modules... no >> using CPPFLAGS= >> using LDFLAGS= >> checking for mawk... (cached) awk >> checking for flex... (cached) /usr/bin/flex >> checking whether ln -s works... (cached) yes >> checking for ld used by GCC... (cached) /usr/bin/ld >> checking if the linker (/usr/bin/ld) is GNU ld... (cached) no >> checking for ranlib... (cached) ranlib >> checking for lorder... (cached) lorder >> checking for tar... (cached) /usr/bin/tar >> checking for bison... (cached) bison -y >> checking for perl... (cached) /usr/bin/perl >> checking for readline... (cached) no >> checking for library containing using_history... (cached) no >> checking for main in -lbsd... (cached) no >> checking for setproctitle in -lutil... (cached) no >> checking for main in -lm... (cached) yes >> checking for main in -ldl... (cached) no >> checking for main in -lsocket... (cached) no >> checking for main in -lnsl... (cached) no >> checking for main in -lipc... (cached) no >> checking for main in -lIPC... (cached) no >> checking for main in -llc... (cached) no >> checking for main in -ldld... (cached) no >> checking for main in -lld... (cached) no >> checking for main in -lcompat... (cached) no >> checking for main in -lBSD... (cached) no >> checking for main in -lgen... (cached) no >> checking for main in -lPW... (cached) no >> checking for main in -lresolv... (cached) no >> checking for main in -lunix... (cached) no >> checking for library containing crypt... (cached) none required >> checking for __inet_ntoa in -lbind... (cached) no >> checking for inflate in -lz... (cached) yes >> checking for library containing fdatasync... (cached) no >> checking for crypt.h... (cached) no >> checking for dld.h... (cached) no >> checking for endian.h... (cached) no >> checking for fp_class.h... (cached) no >> checking for getopt.h... (cached) no >> checking for ieeefp.h... (cached) no >> checking for pwd.h... (cached) yes >> checking for sys/ipc.h... (cached) yes >> checking for sys/pstat.h... (cached) no >> checking for sys/select.h... (cached) yes >> checking for sys/sem.h... (cached) yes >> checking for sys/socket.h... (cached) yes >> checking for sys/shm.h... (cached) yes >> checking for sys/types.h... (cached) yes >> checking for sys/un.h... (cached) yes >> checking for termios.h... (cached) yes >> checking for kernel/OS.h... (cached) no >> checking for kernel/image.h... (cached) no >> checking for SupportDefs.h... (cached) no >> checking for netinet/in.h... (cached) yes >> checking for netinet/tcp.h... yes >> checking whether string.h and strings.h may both be included... >> (cached) yes >> checking for readline/readline.h... (cached) no >> checking for readline.h... (cached) no >> checking for readline/history.h... (cached) no >> checking for history.h... (cached) no >> checking for working const... (cached) yes >> checking for inline... (cached) inline >> checking for preprocessor stringizing operator... (cached) yes >> checking for signed types... (cached) yes >> checking for volatile... (cached) yes >> checking whether struct tm is in sys/time.h or time.h... (cached) >> time.h >> checking for tm_zone in struct tm... (cached) yes >> checking for union semun... (cached) yes >> checking for struct cmsgcred... (cached) no >> checking for struct fcred... (cached) no >> checking for struct sockcred... (cached) no >> checking for struct sockaddr_un... (cached) yes >> checking for int timezone... (cached) no >> checking types of arguments for accept()... (cached) int, struct >> sockaddr *, int * >> checking whether gettimeofday takes only one argument... (cached) no >> checking for 8-bit clean memcmp... (cached) yes >> checking for fcvt... (cached) yes >> checking for getopt_long... (cached) no >> checking for memmove... (cached) yes >> checking for pstat... (cached) no >> checking for setproctitle... (cached) no >> checking for setsid... (cached) yes >> checking for sigprocmask... (cached) yes >> checking for sysconf... (cached) yes >> checking for waitpid... (cached) yes >> checking for dlopen... (cached) no >> checking for fdatasync... (cached) no >> checking for PS_STRINGS... (cached) no >> checking for snprintf... (cached) yes >> checking for vsnprintf... (cached) yes >> checking for isinf... (cached) yes >> checking for getrusage... (cached) yes >> checking for srandom... (cached) yes >> checking for gethostname... (cached) yes >> checking for random... (cached) yes >> checking for inet_aton... (cached) yes >> checking for strerror... (cached) yes >> checking for strdup... (cached) yes >> checking for strtol... (cached) yes >> checking for strtoul... (cached) yes >> checking for strcasecmp... (cached) yes >> checking for cbrt... (cached) yes >> checking for rint... (cached) yes >> checking for rl_completion_append_character... no >> checking for rl_completion_matches... (cached) no >> checking for rl_filename_completion_function... (cached) no >> checking for finite... yes >> checking for sigsetjmp... yes >> checking for optreset... (cached) yes >> checking test program... ok >> checking whether long int is 64 bits... (cached) no >> checking whether long long int is 64 bits... (cached) yes >> checking whether snprintf handles 'long long int' as %lld... yes >> checking for strtoll... (cached) yes >> checking for strtoull... (cached) yes >> checking for atexit... (cached) yes >> checking size of unsigned long... (cached) 4 >> checking alignment of short... (cached) 2 >> checking alignment of int... (cached) 4 >> checking alignment of long... (cached) 4 >> checking alignment of long long int... (cached) 4 >> checking alignment of double... (cached) 4 >> checking for int8... (cached) no >> checking for uint8... (cached) no >> checking for int64... (cached) no >> checking for uint64... (cached) no >> checking for sig_atomic_t... (cached) yes >> checking for POSIX signal interface... (cached) yes >> checking for onsgmls... no >> checking for nsgmls... no >> updating cache ./config.cache >> creating ./config.status >> creating GNUmakefile >> creating src/GNUmakefile >> creating src/Makefile.global >> creating src/backend/port/Makefile >> creating src/include/pg_config.h >> src/include/pg_config.h is unchanged >> linking ./src/backend/port/dynloader/darwin.c to >> src/backend/port/dynloader.c >> linking ./src/backend/port/dynloader/darwin.h to >> src/include/dynloader.h >> linking ./src/include/port/darwin.h to src/include/pg_config_os.h >> linking ./src/makefiles/Makefile.darwin to src/Makefile.port >> linking ./src/backend/port/tas/dummy.s to src/backend/port/tas.s >> [mikef-ti:/database/postgresql-7.2.2] mikef% make >> make -C doc all >> make[1]: Nothing to be done for `all'. >> make -C src all >> make -C backend all >> make -C access all >> make -C common SUBSYS.o >> make[4]: `SUBSYS.o' is up to date. >> make -C gist SUBSYS.o >> make[4]: `SUBSYS.o' is up to date. >> make -C hash SUBSYS.o >> make[4]: `SUBSYS.o' is up to date. >> make -C heap SUBSYS.o >> make[4]: `SUBSYS.o' is up to date. >> make -C index SUBSYS.o >> make[4]: `SUBSYS.o' is up to date. >> make -C nbtree SUBSYS.o >> make[4]: `SUBSYS.o' is up to date. >> make -C rtree SUBSYS.o >> make[4]: `SUBSYS.o' is up to date. >> make -C transam SUBSYS.o >> make[4]: `SUBSYS.o' is up to date. >> make -C bootstrap all >> make[3]: Nothing to be done for `all'. >> make -C catalog all >> make[3]: Nothing to be done for `all'. >> make -C parser all >> make[3]: Nothing to be done for `all'. >> make -C commands all >> make[3]: Nothing to be done for `all'. >> make -C executor all >> make[3]: Nothing to be done for `all'. >> make -C lib all >> make[3]: Nothing to be done for `all'. >> make -C libpq all >> make[3]: Nothing to be done for `all'. >> make -C main all >> make[3]: Nothing to be done for `all'. >> make -C nodes all >> make[3]: Nothing to be done for `all'. >> make -C optimizer all >> make -C geqo SUBSYS.o >> make[4]: `SUBSYS.o' is up to date. >> make -C path SUBSYS.o >> make[4]: `SUBSYS.o' is up to date. >> make -C plan SUBSYS.o >> make[4]: `SUBSYS.o' is up to date. >> make -C prep SUBSYS.o >> make[4]: `SUBSYS.o' is up to date. >> make -C util SUBSYS.o >> make[4]: `SUBSYS.o' is up to date. >> make -C port all >> make -C darwin all >> gcc -traditional-cpp -g -O2 -Wall -Wmissing-prototypes >> -Wmissing-declarations -I../../../../src/include -c -o sem.o sem.c >> In file included from sem.c:30: >> ../../../../src/include/port/darwin/sem.h:66: warning: `union semun' >> declared inside parameter list >> ../../../../src/include/port/darwin/sem.h:66: warning: its scope is >> only this definition or declaration, which is probably not what you >> want >> ../../../../src/include/port/darwin/sem.h:66: warning: parameter has >> incomplete type >> sem.c:67: warning: `union semun' declared inside parameter list >> sem.c:68: parameter `arg' has incomplete type >> make[4]: *** [sem.o] Error 1 >> make[3]: *** [darwin.dir] Error 2 >> make[2]: *** [port-recursive] Error 2 >> make[1]: *** [all] Error 2 >> make: *** [all] Error 2 >> [mikef-ti:/database/postgresql-7.2.2] mikef% >> >> >> Michael Fortin >> >> >> ---------------------------(end of >> broadcast)--------------------------- >> TIP 6: Have you searched our list archives? >> >> http://archives.postgresql.org >> > > -- > Bruce Momjian | http://candle.pha.pa.us > pgman@candle.pha.pa.us | (610) 359-1001 > + If your life is a hard drive, | 13 Roberts Road > + Christ can be your backup. | Newtown Square, Pennsylvania > 19073 >
Yes, it's 10.2. My environment is pretty much out of the box. I did a=20= =20 clean install about a week ago and I really haven't had much time to=20=20 customize it. [mikef-ti:~] mikef% env HOME=3D/Users/mikef SHELL=3D/bin/tcsh USER=3Dmikef LANG=3Den_US PATH=3D/bin:/sbin:/usr/bin:/usr/sbin __CF_USER_TEXT_ENCODING=3D0x1F5:0:0 TERM=3Dvt100 TERMCAP=3D=A1Z=A1Z=A1Z TERM_PROGRAM=3DApple_Terminal TERM_PROGRAM_VERSION=3D81 LOGNAME=3Dmikef HOSTTYPE=3Dmacintosh VENDOR=3Dapple OSTYPE=3Ddarwin MACHTYPE=3Dpowerpc SHLVL=3D1 PWD=3D/Users/mikef GROUP=3Dstaff HOST=3Dmikef-ti.local. [mikef-ti:~] mikef% uname -a Darwin mikef-ti.local. 6.0 Darwin Kernel Version 6.0: Sat Jul 27=20=20 13:18:52 PDT 2002; root:xnu/xnu-344.obj~1/RELEASE_PPC Power Macintosh=20= =20 powerpc This are the only log entries produced at startup: Failed to initialize lc_time to '' FATAL: invalid value for option 'LC_TIME': 'en_US' I was looking at $PGDATA/postgresql.conf and the very last line in the=20= =20 file is LC_TIME =3D 'en_US' ,is this a coincidence? When I initially=20= =20 looked at it had no carriage return. I added a few more empty lines=20=20 after it but that made no difference. Any other thoughts? Thanks Michael On Tuesday, September 10, 2002, at 01:03 AM, Bruce Momjian wrote: > > Oh, that's a strange error. I thought our beta1 worked on OSX 10.2. > You are on 10.2, right? > > Do have have any environment variables starting with LC_*? > > -----------------------------------------------------------------------= =20 > ---- > > Michael Fortin wrote: >> Bruce, >> Thanks for the reply. It installed fine but when I ran initdb this=20= =20 >> was >> the output: >> >> [mikef-ti:/usr/local/pgsql] postgres% bin/initdb >> 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 en_US. >> This locale setting will prevent the use of indexes for pattern=20=20 >> matching >> operations. If that is a concern, rerun initdb with the collation=20=20 >> order >> set to "C". For more information see the Administrator's Guide. >> >> Fixing permissions on existing directory /usr/local/pgsql/data... ok >> creating directory /usr/local/pgsql/data/base... ok >> creating directory /usr/local/pgsql/data/global... ok >> creating directory /usr/local/pgsql/data/pg_xlog... ok >> creating directory /usr/local/pgsql/data/pg_clog... ok >> creating template1 database in /usr/local/pgsql/data/base/1... Failed >> to initialize lc_time to '' >> ok >> creating configuration files... ok >> initializing pg_shadow... Failed to initialize lc_time to '' >> ok >> enabling unlimited row size for system tables... Failed to initialize >> lc_time to '' >> ok >> initializing pg_depend... Failed to initialize lc_time to '' >> ok >> creating system views... Failed to initialize lc_time to '' >> ok >> loading pg_description... Failed to initialize lc_time to '' >> ok >> creating conversions... Failed to initialize lc_time to '' >> ok >> setting privileges on built-in objects... Failed to initialize lc_time >> to '' >> ok >> vacuuming database template1... Failed to initialize lc_time to '' >> ok >> copying template1 to template0... Failed to initialize lc_time to '' >> ok >> >> Success. You can now start the database server using: >> >> bin/postmaster -D /usr/local/pgsql/data >> or >> bin/pg_ctl -D /usr/local/pgsql/data -l logfile start >> >> --------------- >> >> It failed on startup afterwards. I tried the --lc-time 'en_US' flag >> but it made no difference. >> >> Any other suggestions would be appreciated. >> >> Thanks, Michael >> >> >> >> >> On Monday, September 9, 2002, at 10:18 PM, Bruce Momjian wrote: >> >>> >>> Get 7.3beta1 for OSX 10.2. >>> >>> ---------------------------------------------------------------------= =20 >>> -- >>> ---- >>> >>> Michael Fortin wrote: >>>> My guess is that the new compiler in 10.2 is not compatible with >>>> postgres. Here is the output from configure and make: >>>> >>>> [mikef-ti:/database/postgresql-7.2.2] mikef% ./configure --with-java >>>> loading cache ./config.cache >>>> checking host system type... powerpc-apple-darwin6.0 >>>> checking which template to use... darwin >>>> checking whether to build with locale support... no >>>> checking whether to build with recode support... no >>>> checking whether to build with multibyte character support... no >>>> checking whether NLS is wanted... no >>>> checking for default port number... 5432 >>>> checking for default soft limit on number of connections... 32 >>>> checking for gcc... (cached) gcc >>>> checking whether the C compiler (gcc ) works... yes >>>> checking whether the C compiler (gcc ) is a cross-compiler... no >>>> checking whether we are using GNU C... (cached) yes >>>> checking whether gcc accepts -g... (cached) yes >>>> using CFLAGS=3D-g -O2 >>>> checking whether the C compiler (gcc -traditional-cpp -g -O2 ) >>>> works... >>>> yes >>>> checking whether the C compiler (gcc -traditional-cpp -g -O2 ) is a >>>> cross-compiler... no >>>> checking for Cygwin environment... (cached) no >>>> checking for mingw32 environment... (cached) no >>>> checking for executable suffix... (cached) no >>>> checking how to run the C preprocessor... (cached) gcc >>>> -traditional-cpp >>>> -E >>>> checking whether gcc -traditional-cpp needs -traditional... (cached) >>>> no >>>> checking whether to build with Tcl... no >>>> checking whether to build with Tk... no >>>> checking whether to build Perl modules... no >>>> checking whether to build Python modules... no >>>> checking whether to build Java/JDBC tools... yes >>>> checking for jakarta-ant... no >>>> checking for ant... /java/jakarta-ant-1.5/bin/ant >>>> checking whether /java/jakarta-ant-1.5/bin/ant works... yes >>>> checking whether to build with PAM support... no >>>> checking whether to build the ODBC driver... no >>>> checking whether to build C++ modules... no >>>> using CPPFLAGS=3D >>>> using LDFLAGS=3D >>>> checking for mawk... (cached) awk >>>> checking for flex... (cached) /usr/bin/flex >>>> checking whether ln -s works... (cached) yes >>>> checking for ld used by GCC... (cached) /usr/bin/ld >>>> checking if the linker (/usr/bin/ld) is GNU ld... (cached) no >>>> checking for ranlib... (cached) ranlib >>>> checking for lorder... (cached) lorder >>>> checking for tar... (cached) /usr/bin/tar >>>> checking for bison... (cached) bison -y >>>> checking for perl... (cached) /usr/bin/perl >>>> checking for readline... (cached) no >>>> checking for library containing using_history... (cached) no >>>> checking for main in -lbsd... (cached) no >>>> checking for setproctitle in -lutil... (cached) no >>>> checking for main in -lm... (cached) yes >>>> checking for main in -ldl... (cached) no >>>> checking for main in -lsocket... (cached) no >>>> checking for main in -lnsl... (cached) no >>>> checking for main in -lipc... (cached) no >>>> checking for main in -lIPC... (cached) no >>>> checking for main in -llc... (cached) no >>>> checking for main in -ldld... (cached) no >>>> checking for main in -lld... (cached) no >>>> checking for main in -lcompat... (cached) no >>>> checking for main in -lBSD... (cached) no >>>> checking for main in -lgen... (cached) no >>>> checking for main in -lPW... (cached) no >>>> checking for main in -lresolv... (cached) no >>>> checking for main in -lunix... (cached) no >>>> checking for library containing crypt... (cached) none required >>>> checking for __inet_ntoa in -lbind... (cached) no >>>> checking for inflate in -lz... (cached) yes >>>> checking for library containing fdatasync... (cached) no >>>> checking for crypt.h... (cached) no >>>> checking for dld.h... (cached) no >>>> checking for endian.h... (cached) no >>>> checking for fp_class.h... (cached) no >>>> checking for getopt.h... (cached) no >>>> checking for ieeefp.h... (cached) no >>>> checking for pwd.h... (cached) yes >>>> checking for sys/ipc.h... (cached) yes >>>> checking for sys/pstat.h... (cached) no >>>> checking for sys/select.h... (cached) yes >>>> checking for sys/sem.h... (cached) yes >>>> checking for sys/socket.h... (cached) yes >>>> checking for sys/shm.h... (cached) yes >>>> checking for sys/types.h... (cached) yes >>>> checking for sys/un.h... (cached) yes >>>> checking for termios.h... (cached) yes >>>> checking for kernel/OS.h... (cached) no >>>> checking for kernel/image.h... (cached) no >>>> checking for SupportDefs.h... (cached) no >>>> checking for netinet/in.h... (cached) yes >>>> checking for netinet/tcp.h... yes >>>> checking whether string.h and strings.h may both be included... >>>> (cached) yes >>>> checking for readline/readline.h... (cached) no >>>> checking for readline.h... (cached) no >>>> checking for readline/history.h... (cached) no >>>> checking for history.h... (cached) no >>>> checking for working const... (cached) yes >>>> checking for inline... (cached) inline >>>> checking for preprocessor stringizing operator... (cached) yes >>>> checking for signed types... (cached) yes >>>> checking for volatile... (cached) yes >>>> checking whether struct tm is in sys/time.h or time.h... (cached) >>>> time.h >>>> checking for tm_zone in struct tm... (cached) yes >>>> checking for union semun... (cached) yes >>>> checking for struct cmsgcred... (cached) no >>>> checking for struct fcred... (cached) no >>>> checking for struct sockcred... (cached) no >>>> checking for struct sockaddr_un... (cached) yes >>>> checking for int timezone... (cached) no >>>> checking types of arguments for accept()... (cached) int, struct >>>> sockaddr *, int * >>>> checking whether gettimeofday takes only one argument... (cached) no >>>> checking for 8-bit clean memcmp... (cached) yes >>>> checking for fcvt... (cached) yes >>>> checking for getopt_long... (cached) no >>>> checking for memmove... (cached) yes >>>> checking for pstat... (cached) no >>>> checking for setproctitle... (cached) no >>>> checking for setsid... (cached) yes >>>> checking for sigprocmask... (cached) yes >>>> checking for sysconf... (cached) yes >>>> checking for waitpid... (cached) yes >>>> checking for dlopen... (cached) no >>>> checking for fdatasync... (cached) no >>>> checking for PS_STRINGS... (cached) no >>>> checking for snprintf... (cached) yes >>>> checking for vsnprintf... (cached) yes >>>> checking for isinf... (cached) yes >>>> checking for getrusage... (cached) yes >>>> checking for srandom... (cached) yes >>>> checking for gethostname... (cached) yes >>>> checking for random... (cached) yes >>>> checking for inet_aton... (cached) yes >>>> checking for strerror... (cached) yes >>>> checking for strdup... (cached) yes >>>> checking for strtol... (cached) yes >>>> checking for strtoul... (cached) yes >>>> checking for strcasecmp... (cached) yes >>>> checking for cbrt... (cached) yes >>>> checking for rint... (cached) yes >>>> checking for rl_completion_append_character... no >>>> checking for rl_completion_matches... (cached) no >>>> checking for rl_filename_completion_function... (cached) no >>>> checking for finite... yes >>>> checking for sigsetjmp... yes >>>> checking for optreset... (cached) yes >>>> checking test program... ok >>>> checking whether long int is 64 bits... (cached) no >>>> checking whether long long int is 64 bits... (cached) yes >>>> checking whether snprintf handles 'long long int' as %lld... yes >>>> checking for strtoll... (cached) yes >>>> checking for strtoull... (cached) yes >>>> checking for atexit... (cached) yes >>>> checking size of unsigned long... (cached) 4 >>>> checking alignment of short... (cached) 2 >>>> checking alignment of int... (cached) 4 >>>> checking alignment of long... (cached) 4 >>>> checking alignment of long long int... (cached) 4 >>>> checking alignment of double... (cached) 4 >>>> checking for int8... (cached) no >>>> checking for uint8... (cached) no >>>> checking for int64... (cached) no >>>> checking for uint64... (cached) no >>>> checking for sig_atomic_t... (cached) yes >>>> checking for POSIX signal interface... (cached) yes >>>> checking for onsgmls... no >>>> checking for nsgmls... no >>>> updating cache ./config.cache >>>> creating ./config.status >>>> creating GNUmakefile >>>> creating src/GNUmakefile >>>> creating src/Makefile.global >>>> creating src/backend/port/Makefile >>>> creating src/include/pg_config.h >>>> src/include/pg_config.h is unchanged >>>> linking ./src/backend/port/dynloader/darwin.c to >>>> src/backend/port/dynloader.c >>>> linking ./src/backend/port/dynloader/darwin.h to >>>> src/include/dynloader.h >>>> linking ./src/include/port/darwin.h to src/include/pg_config_os.h >>>> linking ./src/makefiles/Makefile.darwin to src/Makefile.port >>>> linking ./src/backend/port/tas/dummy.s to src/backend/port/tas.s >>>> [mikef-ti:/database/postgresql-7.2.2] mikef% make >>>> make -C doc all >>>> make[1]: Nothing to be done for `all'. >>>> make -C src all >>>> make -C backend all >>>> make -C access all >>>> make -C common SUBSYS.o >>>> make[4]: `SUBSYS.o' is up to date. >>>> make -C gist SUBSYS.o >>>> make[4]: `SUBSYS.o' is up to date. >>>> make -C hash SUBSYS.o >>>> make[4]: `SUBSYS.o' is up to date. >>>> make -C heap SUBSYS.o >>>> make[4]: `SUBSYS.o' is up to date. >>>> make -C index SUBSYS.o >>>> make[4]: `SUBSYS.o' is up to date. >>>> make -C nbtree SUBSYS.o >>>> make[4]: `SUBSYS.o' is up to date. >>>> make -C rtree SUBSYS.o >>>> make[4]: `SUBSYS.o' is up to date. >>>> make -C transam SUBSYS.o >>>> make[4]: `SUBSYS.o' is up to date. >>>> make -C bootstrap all >>>> make[3]: Nothing to be done for `all'. >>>> make -C catalog all >>>> make[3]: Nothing to be done for `all'. >>>> make -C parser all >>>> make[3]: Nothing to be done for `all'. >>>> make -C commands all >>>> make[3]: Nothing to be done for `all'. >>>> make -C executor all >>>> make[3]: Nothing to be done for `all'. >>>> make -C lib all >>>> make[3]: Nothing to be done for `all'. >>>> make -C libpq all >>>> make[3]: Nothing to be done for `all'. >>>> make -C main all >>>> make[3]: Nothing to be done for `all'. >>>> make -C nodes all >>>> make[3]: Nothing to be done for `all'. >>>> make -C optimizer all >>>> make -C geqo SUBSYS.o >>>> make[4]: `SUBSYS.o' is up to date. >>>> make -C path SUBSYS.o >>>> make[4]: `SUBSYS.o' is up to date. >>>> make -C plan SUBSYS.o >>>> make[4]: `SUBSYS.o' is up to date. >>>> make -C prep SUBSYS.o >>>> make[4]: `SUBSYS.o' is up to date. >>>> make -C util SUBSYS.o >>>> make[4]: `SUBSYS.o' is up to date. >>>> make -C port all >>>> make -C darwin all >>>> gcc -traditional-cpp -g -O2 -Wall -Wmissing-prototypes >>>> -Wmissing-declarations -I../../../../src/include -c -o sem.o sem.c >>>> In file included from sem.c:30: >>>> ../../../../src/include/port/darwin/sem.h:66: warning: `union semun' >>>> declared inside parameter list >>>> ../../../../src/include/port/darwin/sem.h:66: warning: its scope is >>>> only this definition or declaration, which is probably not what you >>>> want >>>> ../../../../src/include/port/darwin/sem.h:66: warning: parameter has >>>> incomplete type >>>> sem.c:67: warning: `union semun' declared inside parameter list >>>> sem.c:68: parameter `arg' has incomplete type >>>> make[4]: *** [sem.o] Error 1 >>>> make[3]: *** [darwin.dir] Error 2 >>>> make[2]: *** [port-recursive] Error 2 >>>> make[1]: *** [all] Error 2 >>>> make: *** [all] Error 2 >>>> [mikef-ti:/database/postgresql-7.2.2] mikef% >>>> >>>> >>>> Michael Fortin >>>> >>>> >>>> ---------------------------(end of >>>> broadcast)--------------------------- >>>> TIP 6: Have you searched our list archives? >>>> >>>> http://archives.postgresql.org >>>> >>> >>> --=20 >>> Bruce Momjian | http://candle.pha.pa.us >>> pgman@candle.pha.pa.us | (610) 359-1001 >>> + If your life is a hard drive, | 13 Roberts Road >>> + Christ can be your backup. | Newtown Square,=20=20 >>> Pennsylvania >>> 19073 >>> >> >> > > --=20 > Bruce Momjian | http://candle.pha.pa.us > pgman@candle.pha.pa.us | (610) 359-1001 > + If your life is a hard drive, | 13 Roberts Road > + Christ can be your backup. | Newtown Square, Pennsylvania=20= =20 > 19073 >
Michael Fortin <pommele@mindspring.com> writes: > This are the only log entries produced at startup: > Failed to initialize lc_time to '' > FATAL: invalid value for option 'LC_TIME': 'en_US' The first of these is a mistake (Peter thought he'd fixed it a month ago, but his fix was incomplete; I believe I've fixed the fix, and am about to reboot into OSX to check). The second is OS X's bug: it ought to take en_US as a legal setting for LC_TIME, but seems not to. It is depressing that Apple evidently didn't fix that in 10.2. See prior discussion http://archives.postgresql.org/pgsql-admin/2002-08/msg00062.php It seems we have not done anything about trying to validate the user's LANG/LC_xxx environment settings, and so initdb is quite capable of accepting settings that will prevent the postmaster from starting. The short-term fix is to fix your LANG before initdb, or tweak the postgresql.conf file after. Oh, and file a bug report with Apple ;-) regards, tom lane
Tom Lane wrote: > Michael Fortin <pommele@mindspring.com> writes: > > This are the only log entries produced at startup: > > Failed to initialize lc_time to '' > > FATAL: invalid value for option 'LC_TIME': 'en_US' > > The first of these is a mistake (Peter thought he'd fixed it a month > ago, but his fix was incomplete; I believe I've fixed the fix, and am > about to reboot into OSX to check). The second is OS X's bug: it ought > to take en_US as a legal setting for LC_TIME, but seems not to. It is > depressing that Apple evidently didn't fix that in 10.2. See prior > discussion > http://archives.postgresql.org/pgsql-admin/2002-08/msg00062.php > > It seems we have not done anything about trying to validate the user's > LANG/LC_xxx environment settings, and so initdb is quite capable of > accepting settings that will prevent the postmaster from starting. > The short-term fix is to fix your LANG before initdb, or tweak the > postgresql.conf file after. And he is getting during initdb: >> The database cluster will be initialized with locale en_US. >> This locale setting will prevent the use of indexes for pattern >> matching >> operations. If that is a concern, rerun initdb with the collation >> order >> set to "C". For more information see the Administrator's Guide. which means that unless he really wants a special locale he should use C locale anyway. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073
Tom Lane writes: > The second is OS X's bug: it ought to take en_US as a legal setting for > LC_TIME, but seems not to. It is depressing that Apple evidently didn't > fix that in 10.2. If it's only LC_TIME we can remove that since we don't use it anyway. -- Peter Eisentraut peter_e@gmx.net
Peter Eisentraut <peter_e@gmx.net> writes: > Tom Lane writes: >> The second is OS X's bug: it ought to take en_US as a legal setting for >> LC_TIME, but seems not to. It is depressing that Apple evidently didn't >> fix that in 10.2. > If it's only LC_TIME we can remove that since we don't use it anyway. No such luck; LC_MONETARY and LC_NUMERIC have the same problem. I'm not sure why Michael saw LC_TIME as the first failure, 'cause all three fail for me on OS X 10.1. regards, tom lane
I finally got 7.3b1 running on 10.2. setting the local to "C" got it to run. Much thanks to all. Michael On Tuesday, September 10, 2002, at 01:16 PM, Bruce Momjian wrote: > Tom Lane wrote: >> Michael Fortin <pommele@mindspring.com> writes: >>> This are the only log entries produced at startup: >>> Failed to initialize lc_time to '' >>> FATAL: invalid value for option 'LC_TIME': 'en_US' >> >> The first of these is a mistake (Peter thought he'd fixed it a month >> ago, but his fix was incomplete; I believe I've fixed the fix, and am >> about to reboot into OSX to check). The second is OS X's bug: it >> ought >> to take en_US as a legal setting for LC_TIME, but seems not to. It is >> depressing that Apple evidently didn't fix that in 10.2. See prior >> discussion >> http://archives.postgresql.org/pgsql-admin/2002-08/msg00062.php >> >> It seems we have not done anything about trying to validate the user's >> LANG/LC_xxx environment settings, and so initdb is quite capable of >> accepting settings that will prevent the postmaster from starting. >> The short-term fix is to fix your LANG before initdb, or tweak the >> postgresql.conf file after. > > And he is getting during initdb: > >>> The database cluster will be initialized with locale en_US. >>> This locale setting will prevent the use of indexes for pattern >>> matching >>> operations. If that is a concern, rerun initdb with the collation >>> order >>> set to "C". For more information see the Administrator's Guide. > > which means that unless he really wants a special locale he should use > C > locale anyway. > > -- > Bruce Momjian | http://candle.pha.pa.us > pgman@candle.pha.pa.us | (610) 359-1001 > + If your life is a hard drive, | 13 Roberts Road > + Christ can be your backup. | Newtown Square, Pennsylvania > 19073 >
Theodore Petrosky wrote: > I am running on OSX 10.2 and it appears to be running > with the caveat that i get the 'Failed to initialize > error on startup. > > [postgres:~] postgres% postmaster -i -D > /Users/postgres/pgdata > Failed to initialize lc_time to '' > LOG: database system was shut down at 2002-09-16 > 09:01:45 EDT > LOG: checkpoint record is at 0/DF9BB8 > LOG: redo record is at 0/DF9BB8; undo record is at > 0/0; shutdown TRUE > LOG: next transaction id: 1106; next oid: 30079 > LOG: database system is ready Yes, that is the same problem he had. Set your local to C instead of en_US and it will work. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073
Bruce Momjian <pgman@candle.pha.pa.us> writes: > Theodore Petrosky wrote: >> I am running on OSX 10.2 and it appears to be running >> with the caveat that i get the 'Failed to initialize >> error on startup. >> >> [postgres:~] postgres% postmaster -i -D >> /Users/postgres/pgdata >> Failed to initialize lc_time to '' >> LOG: database system was shut down at 2002-09-16 >> 09:01:45 EDT >> LOG: checkpoint record is at 0/DF9BB8 >> LOG: redo record is at 0/DF9BB8; undo record is at >> 0/0; shutdown TRUE >> LOG: next transaction id: 1106; next oid: 30079 >> LOG: database system is ready > Yes, that is the same problem he had. Set your local to C instead of en_US > and it will work. The "failed to initialize" notice should be gone as of CVS tip. regards, tom lane