PostgreSQL Shutdowns

From: "Victor" <victord(at)paid(dot)com>
To: <pgsql-general(at)PostgreSQL(dot)org>
Subject: PostgreSQL Shutdowns
Date: 2000-12-01 21:53:05
Message-ID: 007901c05be1$15759310$0701a8c0@owml1.md.home.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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-general by date

  From Date Subject
Next Message Martin Jacobs 2000-12-01 22:13:44 Re: strange error (32 512)
Previous Message Joel Burton 2000-12-01 20:52:31 Re: RFC: User reviews of PostgreSQL RI functionality