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

From drdani@mazsola.iit.uni-miskolc.hu
Subject Re: missing schemas from template1
Date
Msg-id Pine.LNX.4.61.0412161754370.20305@mazsola.iit.uni-miskolc.hu
Whole thread Raw
In response to Re: missing schemas from template1  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: missing schemas from template1  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
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...)

Daniel

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: missing schemas from template1
Next
From: "Donald Fraser"
Date:
Subject: Re: Notifications