Re: database does not exist in system catalog - Mailing list pgsql-general
From | P. Dwayne Miller |
---|---|
Subject | Re: database does not exist in system catalog |
Date | |
Msg-id | 3B6F0DE7.D26E6FF1@espgroup.net Whole thread Raw |
In response to | database does not exist in system catalog ("Kathi Arthur" <karthur@coloradomtn.edu>) |
List | pgsql-general |
How did you create this database? Kathi Arthur wrote: > This is a multi-part message in MIME format. > > ------=_NextPart_000_00B0_01C11E7E.4FFBA910 > Content-Type: text/plain; charset="iso-8859-1" > Content-Transfer-Encoding: quoted-printable > > 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 ser= > vs (all very helpful!). But after most of the night Friday and most of las= > t night, I still don't get it... > > I have a database that is already created and sitting out there. I can't a= > ccess 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 alread= > y 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 t= > o the data dictionary (system catalog)? Right now, all I can access is tem= > plate1. > > I'm running PostgreSQL 7.0.2 on an alpha running FreeBSD. > > Help! TIA. > > Kathi Arthur > Colorado Mountain College > karthur@coloradomtn.edu > > ------=_NextPart_000_00B0_01C11E7E.4FFBA910 > Content-Type: text/html; charset="iso-8859-1" > Content-Transfer-Encoding: quoted-printable > > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> > <HTML><HEAD> > <META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-1"> > <META content=3D"MSHTML 5.50.4616.200" name=3DGENERATOR> > <STYLE></STYLE> > </HEAD> > <BODY bgColor=3D#ffffff> > <DIV><FONT face=3DArial size=3D2>Please bear with me for a stupid new-user= > =20 > question. I've tried to solve my problem by looking at the online=20 > documentation, FAQs and archived list servs (all very helpful!). But = > after=20 > most of the night Friday and most of last night, I still don't get=20 > it...</FONT></DIV> > <DIV><FONT face=3DArial size=3D2></FONT> </DIV> > <DIV><FONT face=3DArial size=3D2>I have a database that is already created = > and=20 > sitting out there. I can't access it (Fatal 1: Database "my db"= > does=20 > not exist in the system catalog").</FONT></DIV> > <DIV><FONT face=3DArial size=3D2></FONT> </DIV> > <DIV><FONT face=3DArial size=3D2>I don't want to run CREATE DATABASE becaus= > e the=20 > table schemas I want already exist. I don't care about the data -- ju= > st=20 > the schemas and attributes.</FONT></DIV> > <DIV><FONT face=3DArial size=3D2></FONT> </DIV> > <DIV><FONT face=3DArial size=3D2>Can you help me figure out what steps I ne= > ed to go=20 > through to add this db to the data dictionary (system catalog)? Right= > now,=20 > all I can access is template1.</FONT></DIV> > <DIV><FONT face=3DArial size=3D2></FONT> </DIV> > <DIV><FONT face=3DArial size=3D2>I'm running PostgreSQL 7.0.2 on an alpha r= > unning=20 > FreeBSD.</FONT></DIV> > <DIV><FONT face=3DArial size=3D2></FONT> </DIV> > <DIV><FONT face=3DArial size=3D2>Help! TIA.</FONT></DIV> > <DIV><FONT face=3DArial size=3D2></FONT> </DIV> > <DIV><FONT face=3DArial size=3D2>Kathi Arthur</FONT></DIV> > <DIV><FONT face=3DArial size=3D2>Colorado Mountain College</FONT></DIV> > <DIV><FONT face=3DArial size=3D2><A=20 > href=3D"mailto:karthur@coloradomtn.edu">karthur@coloradomtn.edu</A></FONT><= > /DIV></BODY></HTML> > > ------=_NextPart_000_00B0_01C11E7E.4FFBA910--
pgsql-general by date: