Re: [cobalt-users] Rebuild PostgreSQL 'cobalt' database

[Gerald Waugh <gwaugh@xxxxxxxxxxxxxxxxxxxxxxx>]

On Thu, 5 Jun 2003, Bo von Hohenlohe wrote:
> On the  Rebuild Postgre instructions at
> http://list.cobalt.com/pipermail/cobalt-users/2002-December/082670.html
> there is  the following script to check the ntegrity of the data base, is
> it necessary to check it before and after rebuilding postgre? Thanks again.
>
> CONFIRM THE ERROR:
>
> - -  At "cobalt=>"
> psql cobalt
> prompt type "SELECT * FROM quota;" and press Enter.
>
>    If you see "ERROR:  cannot find attribute 1 of relation quota" then
> the quota table is corrupt
>
>    If you do not get an error, STOP. The quota table is not the
> problem.
>
> - -  \q (to exit psql tool)

Yes, you can do this, as the error might not be quotas
I have never used that procedure, but it looks sound.

And do let us know hou you make out!


Gerald
--
http://frontstreetnetworks.com | http://store.raqware.com
  Front Street Networks LLC, 229 Front Street, Ste.#C
  New Haven, CT 06513-3203 | phone: +1-203-785-0699