Problem under FreeBSD 2.2.6 - Mailing list pgsql-general

From Dave Schwartz
Subject Problem under FreeBSD 2.2.6
Date
Msg-id 000101bd8386$776361a0$5237f8ce@meenie
Whole thread Raw
Responses Re: [GENERAL] Problem under FreeBSD 2.2.6  (The Hermit Hacker <scrappy@hub.org>)
List pgsql-general
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)


pgsql-general by date:

Previous
From: wr@tribe.ping.de
Date:
Subject: Re: [GENERAL] extracting date information?
Next
From: The Hermit Hacker
Date:
Subject: Re: [GENERAL] Problem under FreeBSD 2.2.6