Problem getting postgres running.

Andy Doerr
andy@hiwd.net

FreeBSD 2.2.2

FreeBSD AtlantisPublishing.COM 2.2.2-RELEASE FreeBSD 2.2.2-RELEASE #0: Thu
Apr  9 15:22:39 CDT 1998
rfinn@AtlantisPublishing.COM:/usr/src/sys/compile/ATLANTIS  i386

CPU: Pentium Pro (199.44-MHz 686-class CPU)
  Origin = "GenuineIntel"  Id = 0x619  Stepping=9

Features=0xf9ff<FPU,VME,DE,PSE,TSC,MSR,PAE,MCE,CX8,<b11>,MTRR,PGE,MCA,CMOV>
real memory  = 100663296 (98304K bytes)
avail memory = 95109120 (92880K bytes)

Postgresql 6.0

gcc version 2.7.2.1

gmake
GNU Make version 3.75

runtime backend


postmaster dies following attempted access to a database

the database has been running fine for some time now.  then last night it
started doing this.  I have recompiled postgres and that does not seem to
work.  anyone out there have any ideas?  Please let me know,  this it
critical to me.



following is all the information I can think of to give you


on my screen:
Atlantis /usr/devel/pgsql/bin $ start.tcl
Atlantis /usr/devel/pgsql/bin $ psql template1
        ---debug info---
        Quiet =        f
        Noversion =    f
        stable    =    f
        timings   =    f
        dates     =    Normal
        bufsize   =    64
        query echo =   f
        multiplexed backend? =  f
        DatabaseName = [template1]
        ----------------

        InitPostgres()..
Connection to database 'template1' failed.
PQexec() -- Request was sent to backend, but backend closed the channel
before responding.  This probably means the backend terminated abnormally
before or while processing the request.

Atlantis /usr/devel/pgsql/bin $ ps -aux |grep post
postgres  4666  0.0  0.8   724  764  p3  R+   31Dec69    0:00.00  (bash)
postgres  4542  0.0  0.8   724  764  p3  S     9:13AM    0:00.20 su (bash)
postgres  4665  0.0  0.3   660  284  p3  R+    9:33AM    0:00.00 ps -aux
Atlantis /usr/devel/pgsql/bin $
...

#contents of start.tcl
id group postgres
id user postgres

cd /usr/devel/pgsql

exec ./bin/postmaster -d 3 -D/usr/devel/pgsql/data 2>&1|tee server.log &

#end start.tcl


#start server.log from previous run
FindBackend: found "/usr/devel/pgsql/./bin/postgres" using argv[0]
binding ShmemCreate(key=9428cec, size=758552)
./bin/postmaster: ServerLoop: 1 sockets pending
./bin/postmaster: ServerLoop: connect on 4
./bin/postmaster: ServerLoop:   nSelected=0
./bin/postmaster: ServerLoop:       port 4 pending
./bin/postmaster: ServerLoop: 1 sockets pending
./bin/postmaster: ServerLoop:   nSelected=1
./bin/postmaster: ServerLoop:       port 4 pending
./bin/postmaster: ServerLoop:       handling 4
./bin/postmaster: BackendStartup: environ dump:
-----------------------------------------
    IMAKEINCLUDE=-I/usr/lib/X11/config
    ENV=/home/andy/.bashrc
    HOSTNAME=AtlantisPublishing.COM
    LOGNAME=andy
    SSH_TTY=/dev/ttyp3
    MAIL=/var/mail/andy
    LD_LIBRARY_PATH=/usr/devel/jpd/lib/i386
    MACHTYPE=i386-unknown-freebsd2.2
    PAGER=less
    CLASSPATH=/usr/devel/jdk/classes.zip
    TERM=xterm
    HOSTTYPE=i386

PATH=/sbin:/usr/sbin:/home/andy/bin:/usr/bin:/bin:/usr/local/bin:/usr/X11R6/
bin:/usr/local/bin:.:/usr/contrib/bin:/bin:/usr/local/etc/httpd/bin:/open_intern
et/arch/i386-unknown-freebsd2.1/bin/:/open_internet/arch/i386-unknown-freebsd2.1
/lib:/usr/devel/bin:/usr/devel/jdk/bin:/usr/devel/pgsql/bin
    HOME=/root
    SHELL=/usr/local/bin/bash
    PS1=Atlantis $PWD $
    USER=andy
    _4448_GNU_nonoption_argv_flags_=0
    _4542_GNU_nonoption_argv_flags_=000
    BLOCKSIZE=1k
    EXINIT=set aw ai ts=4 sw=4
    DISPLAY=archimedes:0.0
    SSH_CLIENT=206.109.147.74 1015 22
    OSTYPE=freebsd2.2
    SHLVL=3
    EDITOR=vi
    CVSROOT=/usr/cvs
    _=/usr/devel/pgsql/bin/start.tcl
    _4765_GNU_nonoption_argv_flags_=0
    POSTPORT=5432
    POSTID=2147483647
    PG_USER=postgres
    PGDATA=/usr/devel/pgsql/data
-----------------------------------------
./bin/postmaster child[4768]: execv(/usr/devel/pgsql/./bin/postgres, -p,
-d3, -P
4, template1, )
./bin/postmaster: BackendStartup: pid 4768 user postgres db template1
socket 4
./bin/postmaster: ServerLoop:       done with 4
FindBackend: found "/usr/devel/pgsql/./bin/postgres" using argv[0]
./bin/postmaster: reaping dead processes...
./bin/postmaster: CleanupProc: pid 4768 exited with status 140
./bin/postmaster: CleanupProc: reinitializing shared memory and semaphores

#ls of data/base

Atlantis /usr/devel/pgsql $ ls data/base/
drwxr-x---  12 postgres  postgres   512 Jun  1 17:41 .
drwxr-x---   3 postgres  postgres   512 Jul 19  1997 ..
drwxr-x---   2 postgres  postgres  1024 Apr 30 15:01 andy
drwx------   2 postgres  postgres  1024 May  6 12:07 damon
drwxr-x---   2 postgres  postgres  3584 Jun 11 00:02 hiwd
drwxr-x---   2 postgres  postgres  1024 Jan 30 12:30 khollis
drwx------   2 postgres  postgres  1024 Jun  8 15:00 ncato
drwxr-x---   2 postgres  postgres  1024 Apr 23 10:36 neobot
drwxr-x---   2 postgres  postgres  1024 Jun 11 08:21 postgres
drwxr-x---   2 postgres  postgres  1024 Jun 11 00:12 rfinn
drwxr-x---   2 postgres  postgres  1024 Jun 11 09:10 template1
drwx------   2 postgres  postgres  1536 Jun 10 21:55 whitaker

Atlantis /usr/devel/pgsql $ ls -la data/base/template1/
total 1125
drwxr-x---   2 postgres  postgres    1024 Jun 11 09:10 .
drwxr-x---  12 postgres  postgres     512 Jun  1 17:41 ..
-rw-r-----   1 postgres  postgres       4 Jul 19  1997 PG_VERSION
-rw-r-----   1 postgres  postgres    8192 Jul 19  1997 pg_aggregate
-rw-r-----   1 postgres  postgres    8192 Jul 19  1997 pg_am
-rw-r-----   1 postgres  postgres   16384 Jul 19  1997 pg_amop
-rw-r-----   1 postgres  postgres    8192 Jul 19  1997 pg_amproc
-rw-r-----   1 postgres  postgres   65536 Jul 19  1997 pg_attnameind
-rw-r-----   1 postgres  postgres   40960 Jul 19  1997 pg_attnumind
-rw-r-----   1 postgres  postgres   40960 Jul 19  1997 pg_attrelidind
-rw-r-----   1 postgres  postgres   73728 Jul 19  1997 pg_attribute
-rw-r-----   1 postgres  postgres    8192 Jul 19  1997 pg_class
-rw-r-----   1 postgres  postgres   16384 Jul 19  1997 pg_classnameind
-rw-r-----   1 postgres  postgres   16384 Jul 19  1997 pg_classoidind
-rw-r-----   1 postgres  postgres    8192 Jul 19  1997 pg_index
-rw-r-----   1 postgres  postgres       0 Jul 19  1997 pg_inheritproc
-rw-r-----   1 postgres  postgres       0 Jul 19  1997 pg_inherits
-rw-r-----   1 postgres  postgres    1878 Jul 19  1997 pg_internal.init
-rw-r-----   1 postgres  postgres       0 Jul 19  1997 pg_ipl
-rw-r-----   1 postgres  postgres    8192 Jul 19  1997 pg_language
-rw-r-----   1 postgres  postgres       0 Jul 19  1997 pg_listener
-rw-r-----   1 postgres  postgres    8192 Jul 19  1997 pg_opclass
-rw-r-----   1 postgres  postgres   49152 Jul 19  1997 pg_operator
-rw-r-----   1 postgres  postgres    8192 Jul 19  1997 pg_parg
-rw-r-----   1 postgres  postgres  106496 Jul 19  1997 pg_proc
-rw-r-----   1 postgres  postgres   40960 Jul 19  1997 pg_procidind
-rw-r-----   1 postgres  postgres   57344 Jul 19  1997 pg_procnameind
-rw-r-----   1 postgres  postgres   40960 Jul 19  1997 pg_procsrcind
-rw-r-----   1 postgres  postgres       0 Jul 19  1997 pg_rewrite
-rw-r-----   1 postgres  postgres       0 Jul 19  1997 pg_statistic
-rw-r-----   1 postgres  postgres   16384 Jul 19  1997 pg_type
-rw-r-----   1 postgres  postgres   16384 Jul 19  1997 pg_typeidind
-rw-r-----   1 postgres  postgres   16384 Jul 19  1997 pg_typenameind
-rw-r-----   1 postgres  postgres       0 Jul 19  1997 pg_version
-rw-------   1 postgres  postgres  450560 Jun 11 09:45 postgres.core