From: | David Merrill <dmerrill(at)lupercalia(dot)net> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: error "11" |
Date: | 2000-12-22 13:55:59 |
Message-ID: | 20001222085559.B5483@lupercalia.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Thu, Dec 21, 2000 at 05:30:16PM -0500, David Merrill wrote:
> I am getting a strange error from psql:
>
> psql: connectDBStart() -- connect() failed: Connection refused
> Is the postmaster running at 'localhost'
> and accepting connections on Unix socket '5432'?
>
> Yes, the postmaster is running. I can run psql -l and get a list of my
> databases just fine.
>
> This is from the log file:
>
> Server process (pid 18539) exited with status 11 at Thu Dec 21 16:45:54 2000
> Terminating any active server processes...
> Server processes were terminated at Thu Dec 21 16:45:54 2000
> Reinitializing shared memory and semaphores
> 001221.16:45:54.490 [18540] DEBUG: Data Base System is starting up at Thu Dec 21 16:45:54 2000
> 001221.16:45:54.490 [18540] DEBUG: Data Base System was interrupted being in production at Thu Dec 21 16:45:47 2000
> 001221.16:45:54.497 [18540] DEBUG: Data Base System is in production state at Thu Dec 21 16:45:54 2000
> Smart Shutdown request at Thu Dec 21 16:47:28 2000
> 001221.16:47:28.607 [18632] DEBUG: Data Base System shutting down at Thu Dec 21 16:47:28 2000
> 001221.16:47:28.614 [18632] DEBUG: Data Base System shut down at Thu Dec 21 16:47:28 2000
>
> Which I hope will shed some light on the problem.
>
> I have not only restarted my postgresql service, I have rebooted the
> machine just to make sure. And ruined my previously stellar uptime. :-)
I have some more information this morning.
I tried creating and working with a new database, and it works fine.
psql -l does not show my old database, but when I try to create it, I
get the message
createdb gnc_db<enter>
ERROR: CREATE DATABASE: unable to create database directory
'/var/lib/pgsql/data/base/gnc_db': File exists
createdb: database creation failed
so it now looks to me like a partially deleted database is still
hanging around. I am afraid to go deleting anything. And there is
a gnc_db directory where the error message indicates.
Any advice on how I might proceed? What will happen if I delete that
directory?
--
Dr. David C. Merrill http://www.lupercalia.net
Linux Documentation Project dmerrill(at)lupercalia(dot)net
Collection Editor & Coordinator http://www.linuxdoc.org
Finger me for my public key
From your silence, you will sing.
From your burdens, grow your wings.
From | Date | Subject | |
---|---|---|---|
Next Message | Nabil Sayegh | 2000-12-22 14:12:58 | Re: error "11" |
Previous Message | David Merrill | 2000-12-22 13:44:22 | Re: error "11" |