Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199409270034.RAA04034@nobozo.CS.Berkeley.EDU>
Sender: owner-postman@postgres.Berkeley.EDU
From: wpp@marie.physik.tu-berlin.de (Kai Petzke)
Message-Id: <9409270033.AA00594@marie.physik.tu-berlin.de>
Subject: Re: no response from backend with new dbs
To: alfredos@tamu.edu (alfredos)
Date: Tue, 27 Sep 1994 01:33:20 +0100 (MET)
Cc: postgres@postgres.Berkeley.EDU
In-Reply-To: <9409261431.AA17998@ bush.cs.tamu.edu> from "alfredos" at Sep 26, 94 09:31:51 am
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
Content-Length: 696
Resent-To: postgres-redist@postgres.Berkeley.EDU
Resent-Date: Mon, 26 Sep 94 17:34:39 -0700
Resent-XMts: smtp

> 
> 
> I can use any databases that already exist but when I create
> a new one I get no response from the backend. I have tried 
> killing and restarting the postmaster and ipccleaning without
> any success. Any suggestions anyone?

I can think of two possible reasons:

- your template1 database is corrupted.  template1 holds an empty
  database structure, which is copied to the new database by
  createdb.

- one of your system files, like pg_database, is corrupted.


In either case, I recommend you to "copy out" the complete
database structure, recreate everything from scratch (with
initdb; you won't probably have to recompile postgres), and
re-load the database with "copy in".


Kai

==============================================================================
   To add/remove yourself to/from the POSTGRES mailing list: send mail with 
   the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU"

   If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
   a human will deal with it.  DO NOT post to the "postgres" mailing list.
==============================================================================