[cobalt-users] Re: REBUILD THE POSTGRESQL DATABASE

[Bruce Timberlake <bruce@xxxxxxxxxx>]

> I am preparing to rebuild the POSTGRESQL DATABASE on my RaQ3i and have a
> few questions regarding the instructions by Bruce Timberlake at
> http://list.cobalt.com/pipermail/cobalt-users/2002-December/082670.html
>
> 1) CONFIRM THE ERROR:
> - -  At "cobalt=>" prompt type "SELECT * FROM quota;" and press Enter.
>
> **Please explain this procedure one step at a time.**

You're checking to see if the quota table is really corrupt or not. All the 
explanations of each step are in the directions at the URL you gave. There's 
nothing else to say about each step...

> **What does "cobalt=>" mean?**

As the directions 'At "cobalt=>" prompt' imply, it's the PostgreSQL prompt, 
showing you're in the 'cobalt' database...

> 2) REMOVE THE QUOTA STUFF (SINCE IT'S BROKEN ANYWAY):
>
> **Please send snippet of exact data to remove.**

I don't have an exact sample, as you need to do a database dump to show it. 
You remove the entire section in the dumped schema that would create the quota 
table... it's usually near the end of the dump, and should be very obvious. 
The directions tell you everything you need to know:

> Edit 'cobalt-schema' and remove the 'CREATE TABLE "quota" ( );"
> section (spread over 2-3 lines)

Edit the schema dump, and search for a section that starts

	CREATE TABLE "quota"

and delete the entire section.

> Remove the 'COPY "quota" FROM stdin;' line (end of schema file)

Go to the end of the schema file and delete the line that reads

	COPY "quota" FROM stdin;