Re: database does not exist in system catalog

----- Original Message -----

From: Len Morgan

To: Kathi Arthur

Sent: Monday, August 06, 2001 2:07 PM

Subject: Re: [GENERAL] database does not exist in system catalog

Is your database really called "my db" with the space?  I don't think that is going to work.  You might try just "db" to see if that works.  If it doesn't, you might try and do a pg_dumpall which will dumb ALL of the databases it knows about and then you can use the resulting file to rename "my db" to "mydb" and reload it.  I don't know if that's the problem, but it's worth a shot.

 

len morgan

----- Original Message -----

From: Kathi Arthur

To: PostgreSQL General Listserv

Cc: Kathi Arthur

Sent: Monday, August 06, 2001 2:47 PM

Subject: [GENERAL] database does not exist in system catalog

Please bear with me for a stupid new-user question.  I've tried to solve my problem by looking at the online documentation, FAQs and archived list servs (all very helpful!).  But after most of the night Friday and most of last night, I still don't get it...

 

I have a database that is already created and sitting out there.  I can't access it (Fatal 1:  Database "my db" does not exist in the system catalog").

 

I don't want to run CREATE DATABASE because the table schemas I want already exist.  I don't care about the data -- just the schemas and attributes.

 

Can you help me figure out what steps I need to go through to add this db to the data dictionary (system catalog)?  Right now, all I can access is template1.

 

I'm running PostgreSQL 7.0.2 on an alpha running FreeBSD.

 

Help!  TIA.

 

Kathi Arthur

Colorado Mountain College

karthur@coloradomtn.edu