Re: Could not shut down DB - Mailing list pgsql-admin

From Tom Lane
Subject Re: Could not shut down DB
Date
Msg-id 12880.1464626591@sss.pgh.pa.us
Whole thread Raw
In response to Could not shut down DB  (Nagy László Zsolt <gandalf@shopzeus.com>)
List pgsql-admin
=?UTF-8?Q?Nagy_L=c3=a1szl=c3=b3_Zsolt?= <gandalf@shopzeus.com> writes:
> I could stop it with:
> pg_ctl stop -i i

> but before that:

> May 30 07:21:00 appserver postgres[65202]: [5-1] FATAL:  the database
> system is shutting down
> May 30 07:21:00 appserver postgres[65203]: [5-1] FATAL:  the database
> system is shutting down
> May 30 07:21:00 appserver postgres[65206]: [5-1] FATAL:  the database
> system is shutting down

> It happened in the weekend, and the server log does not contain anything
> except these "FATAL: shutting down" messages, so I'm not able to tell
> when is started. Any idea what could possible cause this error?

Well, the default-until-recently "smart" shutdown mode would wait for
all existing sessions to finish, while not letting any new ones in.
That sure looks like what you have here.

            regards, tom lane


pgsql-admin by date:

Previous
From: Alex Ignatov
Date:
Subject: Re: very slow postgresql startup
Next
From: Michael JOIGNY
Date:
Subject: could not read block 0 in file "base/mydb/myfile": read only 0 of 8192 bytes