Re: database does not exist in system catalog

Len --

No, the db is actually called "bullprod" -- I just didn't want to explain the history behind THAT name!

I'll play around with the pg_dumpall but I think I have bigger problems than that...

Thanks for the hint!

-- Kathi
----- 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(at)coloradomtn(dot)edu