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

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

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

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

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

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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

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/

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

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

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

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

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

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org