Re: error "11"

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@lupercalia.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.