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
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 |