Re: missing schemas from template1 - Mailing list pgsql-admin

From Tom Lane
Subject Re: missing schemas from template1
Date
Msg-id 25662.1103216481@sss.pgh.pa.us
Whole thread Raw
In response to Re: missing schemas from template1  (drdani@mazsola.iit.uni-miskolc.hu)
Responses Re: missing schemas from template1
List pgsql-admin
drdani@mazsola.iit.uni-miskolc.hu writes:
> On Thu, 16 Dec 2004, Tom Lane wrote:
>> Uh ... what schemas are you expecting to find there?

> In normal cases there are:

> information_schema
> pg_catalog
> pg_temp1
> pg_toast
> public

> schemas. Without them the database is not really usefull. When I
> create the first database (as copy of template1 of course) it misses
> those schemas. I don't know what is the normal way to create them if
> `initdb' didn't do it (it just said it did...)

It's difficult to believe that those aren't there, or that the database
would appear to work if they were not.  Are you able to do, say, "select
* from pg_namespace"?

            regards, tom lane

pgsql-admin by date:

Previous
From: "Donald Fraser"
Date:
Subject: Re: Notifications
Next
From: Michael Fuhr
Date:
Subject: Re: Notifications