pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
missing schemas from template1
12+ messages / 6 participants
[nested] [flat]

* missing schemas from template1
@ 2004-12-16 11:26  Loránt István <istvan.lorant@sinergy.hu>
  0 siblings, 0 replies; 12+ messages in thread

From: Loránt István @ 2004-12-16 11:26 UTC (permalink / raw)
  To: pgsql-admin

Hi,

Our provider tries to install postgresql 8.0.0-rc1 on a s390 machine (suse 7 or like).
They compiled the source and installed it without problems, and init_db looks to
worked well too. But there is not any schema in template1 database, so we can't
really start our work.

Is it a known problem, or is there a solution for it?

Daniel

^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* missing schemas from template1
@ 2004-12-16 14:38  drdani@mazsola.iit.uni-miskolc.hu
  0 siblings, 2 replies; 12+ messages in thread

From: drdani@mazsola.iit.uni-miskolc.hu @ 2004-12-16 14:38 UTC (permalink / raw)
  To: pgsql-admin

Hi,

Our provider tries to install postgresql 8.0.0-rc1 on a s390 machine 
(suse 7 or like). They compiled the source and installed it without 
problems, and initdb looks to worked well too. But there is not any 
schema in template1 database, so we can't really start our work.

Is it a known problem, is there a solution for it?

Daniel



^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: missing schemas from template1
@ 2004-12-16 16:43  Tom Lane <tgl@sss.pgh.pa.us>
  parent: drdani@mazsola.iit.uni-miskolc.hu
  1 sibling, 1 reply; 12+ messages in thread

From: Tom Lane @ 2004-12-16 16:43 UTC (permalink / raw)
  To: drdani@mazsola.iit.uni-miskolc.hu; +Cc: pgsql-admin

drdani@mazsola.iit.uni-miskolc.hu writes:
> Our provider tries to install postgresql 8.0.0-rc1 on a s390 machine 
> (suse 7 or like). They compiled the source and installed it without 
> problems, and initdb looks to worked well too. But there is not any 
> schema in template1 database, so we can't really start our work.

Uh ... what schemas are you expecting to find there?

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: missing schemas from template1
@ 2004-12-16 16:58  drdani@mazsola.iit.uni-miskolc.hu
  parent: Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 12+ messages in thread

From: drdani@mazsola.iit.uni-miskolc.hu @ 2004-12-16 16:58 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: 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



^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: missing schemas from template1
@ 2004-12-16 17:01  Tom Lane <tgl@sss.pgh.pa.us>
  parent: drdani@mazsola.iit.uni-miskolc.hu
  0 siblings, 1 reply; 12+ messages in thread

From: Tom Lane @ 2004-12-16 17:01 UTC (permalink / raw)
  To: drdani@mazsola.iit.uni-miskolc.hu; +Cc: 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



^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: missing schemas from template1
@ 2004-12-16 17:13  Michael Fuhr <mike@fuhr.org>
  parent: drdani@mazsola.iit.uni-miskolc.hu
  1 sibling, 1 reply; 12+ messages in thread

From: Michael Fuhr @ 2004-12-16 17:13 UTC (permalink / raw)
  To: drdani@mazsola.iit.uni-miskolc.hu; +Cc: pgsql-admin

On Thu, Dec 16, 2004 at 03:38:06PM +0100, drdani@mazsola.iit.uni-miskolc.hu wrote:

> Our provider tries to install postgresql 8.0.0-rc1 on a s390 machine 
> (suse 7 or like). They compiled the source and installed it without 
> problems, and initdb looks to worked well too. But there is not any 
> schema in template1 database, so we can't really start our work.

How are you determining that there are no schemas?  Might you be
using an old client that isn't schema-aware?  Schemas were added
in 7.3, as I recall.

This is a different issue, but you aren't trying to work in template1,
are you?  Template1 is the skeleton used when creating new databases --
you should be using CREATE DATABASE or createdb to create the database
you'll be working in.

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/



^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: missing schemas from template1
@ 2004-12-16 17:48  drdani@mazsola.iit.uni-miskolc.hu
  parent: Michael Fuhr <mike@fuhr.org>
  0 siblings, 1 reply; 12+ messages in thread

From: drdani@mazsola.iit.uni-miskolc.hu @ 2004-12-16 17:48 UTC (permalink / raw)
  To: Michael Fuhr <mike@fuhr.org>; +Cc: pgsql-admin

On Thu, 16 Dec 2004, Michael Fuhr wrote:

> How are you determining that there are no schemas?  Might you be

Connecting with pgadmin3 to template1.

> This is a different issue, but you aren't trying to work in template1,
> are you?  Template1 is the skeleton used when creating new databases --
> you should be using CREATE DATABASE or createdb to create the database
> you'll be working in.

To create a new database (my one to work with) I have to connect to 
template1. Creating a new database works wery well, it copies 
template1 so the new db hasn't got any schema exactly as template1...

So the problem is that initdb has created an incomplete template1 so I 
can't start my work. I don't know the reason (output of initdb 
--mailed to me by the provider-- looks OK) and my problem is that I 
don't know the solution... the biggest problem is that provider dosn't 
know either:-(

I tried to dump out missing schemas from an other installation and 
aply the dumps on the incorrect database but it failed.

Daniel



^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: missing schemas from template1
@ 2004-12-16 17:51  drdani@mazsola.iit.uni-miskolc.hu
  parent: Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 12+ messages in thread

From: drdani@mazsola.iit.uni-miskolc.hu @ 2004-12-16 17:51 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-admin

On Thu, 16 Dec 2004, Tom Lane wrote:

> It's difficult to believe that those aren't there, or that the database

I think it is an initdb problem.

> would appear to work if they were not.

The databse is not useable, so that's right.

>  Are you able to do, say, "select
> * from pg_namespace"?

The system is closed, I have no access to it from home, so I can't try 
it right now. The answer is surely no.

Daniel



^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: missing schemas from template1
@ 2004-12-16 17:59  Tom Lane <tgl@sss.pgh.pa.us>
  parent: drdani@mazsola.iit.uni-miskolc.hu
  0 siblings, 1 reply; 12+ messages in thread

From: Tom Lane @ 2004-12-16 17:59 UTC (permalink / raw)
  To: drdani@mazsola.iit.uni-miskolc.hu; +Cc: pgsql-admin

drdani@mazsola.iit.uni-miskolc.hu writes:
> On Thu, 16 Dec 2004, Tom Lane wrote:
>> It's difficult to believe that those aren't there, or that the database
>> would appear to work if they were not.

> The databse is not useable, so that's right.

>> Are you able to do, say, "select
>> * from pg_namespace"?

> The system is closed, I have no access to it from home, so I can't try 
> it right now. The answer is surely no.

If not, why are you so certain that the problem is with missing schemas
and not something else?  I would think it would be impossible to do any
investigation at all, if the initial catalog contents are messed up that
badly.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: missing schemas from template1
@ 2004-12-16 18:05  Scott Marlowe <smarlowe@g2switchworks.com>
  parent: Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 12+ messages in thread

From: Scott Marlowe @ 2004-12-16 18:05 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: drdani@mazsola.iit.uni-miskolc.hu; pgsql-admin

On Thu, 2004-12-16 at 11:59, Tom Lane wrote:
> drdani@mazsola.iit.uni-miskolc.hu writes:
> > On Thu, 16 Dec 2004, Tom Lane wrote:
> >> It's difficult to believe that those aren't there, or that the database
> >> would appear to work if they were not.
> 
> > The databse is not useable, so that's right.
> 
> >> Are you able to do, say, "select
> >> * from pg_namespace"?
> 
> > The system is closed, I have no access to it from home, so I can't try 
> > it right now. The answer is surely no.
> 
> If not, why are you so certain that the problem is with missing schemas
> and not something else?  I would think it would be impossible to do any
> investigation at all, if the initial catalog contents are messed up that
> badly.

Maybe the hosting company is running 7.2 or something like that?



^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: missing schemas from template1
@ 2004-12-16 18:18  Richard_D_Levine@raytheon.com
  0 siblings, 0 replies; 12+ messages in thread

From: Richard_D_Levine@raytheon.com @ 2004-12-16 18:18 UTC (permalink / raw)
  To: Scott Marlowe <smarlowe@g2switchworks.com>; +Cc: drdani@mazsola.iit.uni-miskolc.hu, pgsql-admin@postgresql.org, pgsql-admin-owner@postgresql.org, Tom Lane <tgl@sss.pgh.pa.us>

Did you turn on the "view system objects" thingy in pgadmin3?  That's too
technical%|  Okay, I just checked and it's Display->System Objects.


                                                                                                                                           
                      Scott Marlowe                                                                                                        
                      <smarlowe@g2switchwor        To:       Tom Lane <tgl@sss.pgh.pa.us>                                                  
                      ks.com>                      cc:       drdani@mazsola.iit.uni-miskolc.hu, pgsql-admin@postgresql.org                 
                      Sent by:                     Subject:  Re: [ADMIN] missing schemas from template1                                    
                      pgsql-admin-owner@pos                                                                                                
                      tgresql.org                                                                                                          
                                                                                                                                           
                                                                                                                                           
                      12/16/2004 01:05 PM                                                                                                  
                                                                                                                                           
                                                                                                                                           




On Thu, 2004-12-16 at 11:59, Tom Lane wrote:
> drdani@mazsola.iit.uni-miskolc.hu writes:
> > On Thu, 16 Dec 2004, Tom Lane wrote:
> >> It's difficult to believe that those aren't there, or that the
database
> >> would appear to work if they were not.
>
> > The databse is not useable, so that's right.
>
> >> Are you able to do, say, "select
> >> * from pg_namespace"?
>
> > The system is closed, I have no access to it from home, so I can't try
> > it right now. The answer is surely no.
>
> If not, why are you so certain that the problem is with missing schemas
> and not something else?  I would think it would be impossible to do any
> investigation at all, if the initial catalog contents are messed up that
> badly.

Maybe the hosting company is running 7.2 or something like that?

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faqs/FAQ.html






^ permalink  raw  reply  [nested|flat] 12+ messages in thread

* Re: missing schemas from template1
@ 2004-12-16 18:31  Tom Lane <tgl@sss.pgh.pa.us>
  parent: drdani@mazsola.iit.uni-miskolc.hu
  0 siblings, 0 replies; 12+ messages in thread

From: Tom Lane @ 2004-12-16 18:31 UTC (permalink / raw)
  To: drdani@mazsola.iit.uni-miskolc.hu; +Cc: Michael Fuhr <mike@fuhr.org>; pgsql-admin

drdani@mazsola.iit.uni-miskolc.hu writes:
> On Thu, 16 Dec 2004, Michael Fuhr wrote:
>> How are you determining that there are no schemas?  Might you be

> Connecting with pgadmin3 to template1.

Perhaps you need a newer version of PGAdmin3.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 12+ messages in thread


end of thread, other threads:[~2004-12-16 18:31 UTC | newest]

Thread overview: 12+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-12-16 11:26 missing schemas from template1 Loránt István <istvan.lorant@sinergy.hu>
2004-12-16 14:38 missing schemas from template1 drdani@mazsola.iit.uni-miskolc.hu
2004-12-16 16:43 ` Tom Lane <tgl@sss.pgh.pa.us>
2004-12-16 16:58   ` drdani@mazsola.iit.uni-miskolc.hu
2004-12-16 17:01     ` Tom Lane <tgl@sss.pgh.pa.us>
2004-12-16 17:51       ` drdani@mazsola.iit.uni-miskolc.hu
2004-12-16 17:59         ` Tom Lane <tgl@sss.pgh.pa.us>
2004-12-16 18:05           ` Scott Marlowe <smarlowe@g2switchworks.com>
2004-12-16 17:13 ` Michael Fuhr <mike@fuhr.org>
2004-12-16 17:48   ` drdani@mazsola.iit.uni-miskolc.hu
2004-12-16 18:31     ` Tom Lane <tgl@sss.pgh.pa.us>
2004-12-16 18:18 Re: missing schemas from template1 Richard_D_Levine@raytheon.com

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox