Title: missing schemas from template1
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
[EMAIL PROTECTED] 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
---(e
ks.com> cc: [EMAIL PROTECTED],
[EMAIL PROTECTED]
Sent by: Subject: Re: [ADMIN]
missing schemas from template1
[EMAIL PROTECTED] 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
On Thu, 2004-12-16 at 11:59, Tom Lane wrote:
> [EMAIL PROTECTED] 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
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 clo
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
On Thu, Dec 16, 2004 at 03:38:06PM +0100, [EMAIL PROTECTED] 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 templ
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
[EMAIL PROTECTED] 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
[EMAIL PROTECTED] 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 ou
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
Hi,
We've got a rather odd problem with our PG 7.3.2 production installation.
Everything is working fine on the surface, and has been for quite some time.
Only recently, we have noticed the abscence of any schemas.
We're at a complete loss as to how this happened, or even when.
The databases we ru
13 matches
Mail list logo
