Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group