Database is shutting down

Поиск
Список
Период
Сортировка
От Anshuman Kanwar
Тема Database is shutting down
Дата
Msg-id D5CB6754A6DAD511A42E00D0B7A07191C589A1@dopey.corp.expertcity.com
обсуждение исходный текст
Ответы Re: Database is shutting down  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-novice
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

В списке pgsql-novice по дате отправления:

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: Size of the Postgres DB
Следующее
От: ghaverla@freenet.edmonton.ab.ca
Дата:
Сообщение: 7.1 -> 7.2 on Debian