I don't know if this is a port bug or what.
I had been happily using Postgres95 (yes 95) with the intention of upgrading
to Postgresql 6.something when I got a 'round tuit'. Well my hand was forced
this weekend when the host machine died a horrible death. I got the latest
release (6.3.2) and it compiles just fine under FreeBSD 2.2.6. However, it
won't run nearly as well. The install and initdb seem to work fine and the
postmaster will start. As soon as I try to 'psql template1', the postmaster
crashes with a 'bad system call' dump. When debug level 3, the following
output is received (sorry for the length) and postmaster dies (the lock file
is still in /tmp).
Any ideas??
FindBackend: searching PATH ...
ValidateBackend: can't stat "/usr/home/postgres/bin/postgres"
ValidateBackend: can't stat "/sbin/postgres"
ValidateBackend: can't stat "/usr/sbin/postgres"
ValidateBackend: can't stat "/bin/postgres"
ValidateBackend: can't stat "/usr/bin/postgres"
ValidateBackend: can't stat "/usr/contrib/bin/postgres"
ValidateBackend: can't stat "/usr/contrib/mh/bin/postgres"
FindBackend: found "/usr/local/pgsql/bin/postgres" using PATH
binding ShmemCreate(key=52e2c1, size=758344)
postmaster: ServerLoop: handling reading 4
postmaster: ServerLoop: handling reading 4
postmaster: ServerLoop: handling writing 4
postmaster: BackendStartup: environ dump:
-----------------------------------------
TERM=ansi
PATH=/usr/home/postgres/bin:/sbin:/usr/sbin:/bin:/usr/bin:/usr/contrib/b
in:/usr/contrib/mh/bin:/usr/local/pgsql/bin:/usr/local/bin:/usr/local/pgsql/
bin:
.
SHELL=/usr/local/bin/tcsh
HOME=/usr/home/postgres
LOGNAME=postgres
USER=postgres
HOSTTYPE=FreeBSD
VENDOR=intel
OSTYPE=FreeBSD
MACHTYPE=i386
SHLVL=1
PWD=/usr/home/postgres/postgres95/src
GROUP=user
HOST=web.kw.igs.net
REMOTEHOST=ttyB14.kw.igs.net
EDITOR=vi
EXINIT=set autoindent
PAGER=more
BLOCKSIZE=1k
NNTPSERVER=news.kw.igs.net
RNINIT=/usr/home/postgres/.rninit
WWW_HOME=http://www.kw.igs.net/
MANPATH=/usr/local
PGLIB=/usr/local/pgsql/lib
PGDATA=/usr/local/pgsql/data
LD_LIBRARY_PATH=/usr/local/pgsql/lib
POSTPORT=5432
POSTID=2147483647
POSTID=2147483647
PG_USER=postgres
IPC_KEY=5432000
-----------------------------------------
postmaster child[0]: execv(/usr/local/pgsql/bin/postgres, -p, -d3, -P4, -v
65536
, template1, )
postmaster: BackendStartup: pid 27750 user postgres db template1 socket 4
FindBackend: found "/usr/local/pgsql/bin/postgres" using argv[0]
---debug info---
Quiet = f
Noversion = f
timings = f
dates = Normal
bufsize = 64
sortmem = 512
query echo = f
DatabaseName = [template1]
----------------
InitPostgres()..
postmaster: reaping dead processes...
postmaster: CleanupProc: pid 27750 exited with status 140
postmaster: CleanupProc: reinitializing shared memory and semaphores
Bad system call (core dumped)
