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

Re: error "11"

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

In response to

  • error "11" at 2000-12-21 22:30:16 from David Merrill

pgsql-novice by date

Next:From: Nabil SayeghDate: 2000-12-22 14:12:58
Subject: Re: error "11"
Previous:From: David MerrillDate: 2000-12-22 13:44:22
Subject: Re: error "11"

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