----- Original Message -----
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 -----
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
