Database is shutting down

From: Anshuman Kanwar <Anshuman(at)expertcity(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Database is shutting down
Date: 2002-03-13 01:13:44
Message-ID: D5CB6754A6DAD511A42E00D0B7A07191C589A1@dopey.corp.expertcity.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message ghaverla 2002-03-13 04:16:36 7.1 -> 7.2 on Debian
Previous Message Stephan Szabo 2002-03-13 01:03:07 Re: Size of the Postgres DB