Re: missing schemas from template1

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: drdani(at)mazsola(dot)iit(dot)uni-miskolc(dot)hu
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: missing schemas from template1
Date: 2004-12-16 17:01:21
Message-ID: 25662.1103216481@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

drdani(at)mazsola(dot)iit(dot)uni-miskolc(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Sam Mortimer 2004-12-16 17:07:01 Re: robust way of moving tables to a different disk??
Previous Message Donald Fraser 2004-12-16 17:01:04 Re: Notifications