Re: Backing up and restoring a database with the SELinux pg_user problem. - Mailing list pgsql-general

From Tom Lane
Subject Re: Backing up and restoring a database with the SELinux pg_user problem.
Date
Msg-id 14324.1107530385@sss.pgh.pa.us
Whole thread Raw
In response to Re: Backing up and restoring a database with the SELinux pg_user problem.  (Joseph Kiniry <kiniry@acm.org>)
Responses Re: Backing up and restoring a database with the SELinux pg_user problem.
List pgsql-general
Joseph Kiniry <kiniry@acm.org> writes:
> I'm currently blocked on the system catalog schema "pg_catalog";
> whence is it initialized?

That row in pg_namespace is missing, you mean?  That's very odd ... what
rows do you see in pg_namespace?  That should be loaded as part of the
basic bootstrap operation, and if basic bootstrap had failed you'd
definitely not have failed to notice ;-)

> I have looked though all initdb-related
> scripts, SQL files, and BKI files and have found several references to
> pg_catalog, but I have not found its definition/initialization.

The definition/initialization is basically driven from macros in
src/include/catalog/pg_namespace.h; in particular all the rows defined
by DATA macros in that file should have been created during bootstrap.
You might look in the .bki file to verify that there is a section
creating and loading pg_namespace.

            regards, tom lane

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: REPLICATION Solution for WINDOWS OS
Next
From: Art Fore
Date:
Subject: Re: Postgresql 8.0 beta 5 setup in windowsxp