Weird DB Shutdowns

From: "Victor" <victord(at)paid(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Weird DB Shutdowns
Date: 2000-11-29 19:26:15
Message-ID: 001101c05a3a$3d795a20$0701a8c0@owml1.md.home.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

localhost[/usr/local/pgsql/data]# psql test dbuser
Password:
psql: The Data Base System is shutting down
localhost[/usr/local/pgsql/data]#

---------------------------------------------------------
I am getting weird DB shutdowns. Anybody experience this before ? Any ideas
welcome. What could this be?

I am running Solaris 7
/etc/system has the following shared memory setting:
set shmsys:shminfo_shmmax = 0xffffffff

test is a test database created for logins, etc.
dbuser is a user in the db. it's password is correctly entered. Sometimes
there are no problems but other times this failure happens.

Could this be something with persistent connections? What settings set the
length of time that a persistent connection will stay open?

Here are the startup settings (data/postmaster.opts):

-p 5432
-D /usr/local/pgsql/data
-B 64
-b /usr/local/pgsql/bin/postgres
-d 3
-i
-N 32

Browse pgsql-admin by date

  From Date Subject
Next Message Thomas Wong 2000-11-30 01:07:05 Re: Perfomance of postgresql-7.0.3-2
Previous Message Karla Peralta 2000-11-29 16:18:48 Perfomance of postgresql-7.0.3-2