Обсуждение: Database is shutting down

Поиск
Список
Период
Сортировка

Database is shutting down

От
Anshuman Kanwar
Дата:
Hi everyone,
 I am hoping one of you has faced this before and can shed some light.

Setup
------
OS: FreeBSD
Remote and local connectivity problem.

Problem:
--------

[guna ~] su - postgres
su-2.05a$ pwd
/usr/local/pgsql
su-2.05a$ psql noc postgres              -- ???
psql: FATAL 1:  The database system is shutting down

The same problem occurs if I try connecting from a remote client. Here is my
process list. As you can see, one other host (10.4.1.134) is happily
connected (remote).

su-2.05a$ ps -ax | grep post
67343  ??  I      0:00.03 postmaster: postgres template1 10.4.1.134 idle
(postgres)
67377  ??  I      0:00.19 postmaster: postgres noc 10.4.1.134 idle
(postgres)
67379  ??  I      0:00.04 postmaster: postgres test 10.4.1.134 idle
(postgres)
67381  ??  I      0:02.85 postmaster: postgres noc 10.4.1.134 idle
(postgres)
50215  p3- I      0:00.98 /usr/local/pgsql/bin/postmaster -i (postgres)
50216  p3- I      0:00.03 postmaster: stats buffer process    (postgres)
50217  p3- I      0:00.17 postmaster: stats collector process    (postgres)

Any suggestions?

Thanks in advance.
cheers,
-ansh

Re: Database is shutting down

От
Tom Lane
Дата:
Anshuman Kanwar <Anshuman@expertcity.com> writes:
> su-2.05a$ psql noc postgres              -- ???
> psql: FATAL 1:  The database system is shutting down

> The same problem occurs if I try connecting from a remote client. Here is my
> process list. As you can see, one other host (10.4.1.134) is happily
> connected (remote).

It looks to me like the postmaster has been told to do a graceful
shutdown, which consists in refusing all new connections while waiting
for the existing clients to finish their work and disconnect.  Your
existing clients don't seem to be in any hurry to disconnect, so
you'll have to go do something about them.

            regards, tom lane