agora inbox for postgres@postgres.berkeley.edu  

help / color / mirror / Atom feed

From: Kai Petzke <wpp@marie.physik.tu-berlin.de>
To: alfredos <alfredos@tamu.edu>
Cc: postgres@postgres.Berkeley.EDU
Subject: Re: no response from backend with new dbs
Date: Tue, 27 Sep 1994 01:33:20 +0100 (MET)
Message-ID: <9409270033.AA00594@marie.physik.tu-berlin.de> (raw)
In-Reply-To: <9409261431.AA17998@ bush.cs.tamu.edu>

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

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: postgres@postgres.berkeley.edu
  Cc: wpp@marie.physik.tu-berlin.de, alfredos@tamu.edu
  Subject: Re: no response from backend with new dbs
  In-Reply-To: <9409270033.AA00594@marie.physik.tu-berlin.de>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox