Skip site navigation (1) Skip section navigation (2)

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: (view raw or whole 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


pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group