[mikef-ti:~] mikef% env
HOME=/Users/mikef
SHELL=/bin/tcsh
USER=mikef
LANG=en_US
PATH=/bin:/sbin:/usr/bin:/usr/sbin
__CF_USER_TEXT_ENCODING=0x1F5:0:0
TERM=vt100
TERMCAP=¡Z¡Z¡Z
TERM_PROGRAM=Apple_Terminal
TERM_PROGRAM_VERSION=81
LOGNAME=mikef
HOSTTYPE=macintosh
VENDOR=apple
OSTYPE=darwin
MACHTYPE=powerpc
SHLVL=1
PWD=/Users/mikef
GROUP=staff
HOST=mikef-ti.local.
[mikef-ti:~] mikef% uname -a
Darwin mikef-ti.local. 6.0 Darwin Kernel Version 6.0: Sat Jul 27 13:18:52 PDT 2002; root:xnu/xnu-344.obj~1/RELEASE_PPC Power Macintosh 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 file is LC_TIME = 'en_US' ,is this a coincidence? When I initially looked at it had no carriage return. I added a few more empty lines 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_*?
---------------------------------------------------------------------------
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
[EMAIL PROTECTED] | (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
[EMAIL PROTECTED] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
