pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedmissing 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
2004-12-16 16:43 ` Re: missing schemas from template1 Tom Lane <tgl@sss.pgh.pa.us>
2004-12-16 17:13 ` Re: missing schemas from template1 Michael Fuhr <mike@fuhr.org>
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 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 ` Re: missing schemas from template1 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 14:38 missing schemas from template1 drdani@mazsola.iit.uni-miskolc.hu
2004-12-16 16:43 ` Re: missing schemas from template1 Tom Lane <tgl@sss.pgh.pa.us>
@ 2004-12-16 16:58 ` drdani@mazsola.iit.uni-miskolc.hu
2004-12-16 17:01 ` Re: missing schemas from template1 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 14:38 missing schemas from template1 drdani@mazsola.iit.uni-miskolc.hu
2004-12-16 16:43 ` Re: missing schemas from template1 Tom Lane <tgl@sss.pgh.pa.us>
2004-12-16 16:58 ` Re: missing schemas from template1 drdani@mazsola.iit.uni-miskolc.hu
@ 2004-12-16 17:01 ` Tom Lane <tgl@sss.pgh.pa.us>
2004-12-16 17:51 ` Re: missing schemas from template1 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 14:38 missing schemas from template1 drdani@mazsola.iit.uni-miskolc.hu
2004-12-16 16:43 ` Re: missing schemas from template1 Tom Lane <tgl@sss.pgh.pa.us>
2004-12-16 16:58 ` Re: missing schemas from template1 drdani@mazsola.iit.uni-miskolc.hu
2004-12-16 17:01 ` Re: missing schemas from template1 Tom Lane <tgl@sss.pgh.pa.us>
@ 2004-12-16 17:51 ` drdani@mazsola.iit.uni-miskolc.hu
2004-12-16 17:59 ` Re: missing schemas from template1 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 14:38 missing schemas from template1 drdani@mazsola.iit.uni-miskolc.hu
2004-12-16 16:43 ` Re: missing schemas from template1 Tom Lane <tgl@sss.pgh.pa.us>
2004-12-16 16:58 ` Re: missing schemas from template1 drdani@mazsola.iit.uni-miskolc.hu
2004-12-16 17:01 ` Re: missing schemas from template1 Tom Lane <tgl@sss.pgh.pa.us>
2004-12-16 17:51 ` Re: missing schemas from template1 drdani@mazsola.iit.uni-miskolc.hu
@ 2004-12-16 17:59 ` Tom Lane <tgl@sss.pgh.pa.us>
2004-12-16 18:05 ` Re: missing schemas from template1 Scott Marlowe <smarlowe@g2switchworks.com>
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 14:38 missing schemas from template1 drdani@mazsola.iit.uni-miskolc.hu
2004-12-16 16:43 ` Re: missing schemas from template1 Tom Lane <tgl@sss.pgh.pa.us>
2004-12-16 16:58 ` Re: missing schemas from template1 drdani@mazsola.iit.uni-miskolc.hu
2004-12-16 17:01 ` Re: missing schemas from template1 Tom Lane <tgl@sss.pgh.pa.us>
2004-12-16 17:51 ` Re: missing schemas from template1 drdani@mazsola.iit.uni-miskolc.hu
2004-12-16 17:59 ` Re: missing schemas from template1 Tom Lane <tgl@sss.pgh.pa.us>
@ 2004-12-16 18:05 ` Scott Marlowe <smarlowe@g2switchworks.com>
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 14:38 missing schemas from template1 drdani@mazsola.iit.uni-miskolc.hu
@ 2004-12-16 17:13 ` Michael Fuhr <mike@fuhr.org>
2004-12-16 17:48 ` Re: missing schemas from template1 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 14:38 missing schemas from template1 drdani@mazsola.iit.uni-miskolc.hu
2004-12-16 17:13 ` Re: missing schemas from template1 Michael Fuhr <mike@fuhr.org>
@ 2004-12-16 17:48 ` drdani@mazsola.iit.uni-miskolc.hu
2004-12-16 18:31 ` Re: missing schemas from template1 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: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 14:38 missing schemas from template1 drdani@mazsola.iit.uni-miskolc.hu
2004-12-16 17:13 ` Re: missing schemas from template1 Michael Fuhr <mike@fuhr.org>
2004-12-16 17:48 ` Re: missing schemas from template1 drdani@mazsola.iit.uni-miskolc.hu
@ 2004-12-16 18:31 ` Tom Lane <tgl@sss.pgh.pa.us>
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
* 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
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