Problem getting postgres running.

Andy Doerr
andy(at)hiwd(dot)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(at)AtlantisPublishing(dot)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