Re: database does not exist in system catalog
От | Kathi Arthur |
---|---|
Тема | Re: database does not exist in system catalog |
Дата | |
Msg-id | 00c801c11eb5$424b4eb0$3204a8c0@ITPC03 обсуждение исходный текст |
Ответ на | database does not exist in system catalog ("Kathi Arthur" <karthur@coloradomtn.edu>) |
Список | pgsql-general |
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 MorganTo: Kathi ArthurSent: Monday, August 06, 2001 2:07 PMSubject: Re: [GENERAL] database does not exist in system catalogIs 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 ArthurCc: Kathi ArthurSent: Monday, August 06, 2001 2:47 PMSubject: [GENERAL] database does not exist in system catalogPlease 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 ArthurColorado Mountain College
В списке pgsql-general по дате отправления: