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

[Bo von Hohenlohe <bvhprods@xxxxxxx>]

>>On Thu, 5 Jun 2003, Bo von Hohenlohe wrote:
>>
>>> >On Wed, 4 Jun 2003, Bo von Hohenlohe wrote:
>>> >
>>> >> RE: Rebuild PostgreSQL 'cobalt' database
>>> >>
>>> >> 1) Before I Rebuild PostgreSQL 'cobalt' database I tried to check my
>>>data
>>> >> base for errors per
>>> >>
>>>http://list.cobalt.com/pipermail/cobalt-users/2002-December/082670.html :
>>> >>
>>> >> su - postgres
>>> >> psql cobalt
>>> >> SELECT * FROM quota;
>>> >>
>>> >> 2) I get:
>>> >>
>>> >> [root@ns1 /root]# su - postgres
>>> >> [postgres@ns1 pgsql]$ psql cobalt
>>> >> Connection to database 'cobalt' failed.
>>> >> fe_sendauth: no password supplied
>>> >
>>> >did you change pg_hba.conf
>>> >#local cobalt crypt
>>> >local all trust
>>> >
>>> >> Where can I find the password for the cobalt data base? The password for
>>> >> admin/root does not work.
>>>
>>>
>>> >
>>> >the password is in /etc/cobalt/.meta.id
>>> >But you shouldn't need it if you changed
>>> >did you change pg_hba.conf
>>> >
>>> >Make sure you change it back when you are finished
>>> >
>>> >Gerald
>>> >--
>>>
>>>
>>>
>>> Attention Gerald:
>>>
>>> 1) I have been receiving a message from admin. Here is one line:
>>> NOTICE:  Index pg_attribute_attrelid_index: NUMBER OF INDEX' TUPLES (592)
>>> IS NOT THE SAME AS HEAP' (583) Please confirm that this indicates the need
>>> to rebuild the cobalt data base.
>>
>>  Yes, this usually is due to a corrupted quota table.
>>
>>> 2) ValueWeb/Affinity where I lease my servers want to charge me $150 to
>>> rebuild the data base, which is nuts, so I must attempt to do it myself. If
>>> the rebuild fails I want to be assured that I can reverse the process. What
>>> is the procedure for restoring the original (although corrupted) database?
>>
>>  When you dump the database make a backup of the dump file.
>>  Then you can always import the backup to restore the cobalt database
>>
>>> 3)  I am rebuilding the data base on my RaQ3, where the path is
>>> /home/pgsql, but on my RaQ4  /home/pgsql does not exist. Where is the
>>> directory I need to be in on my RaQ4?
>>
>>  On a RaQ4, and 550 it is in /var/lib/pgsql/
>>  The real files are in /var/lib/pgsql/data
>>
>>> 4) Please clarify these commands:
>>> At "cobalt=>" prompt type "SELECT * FROM quota;" and press Enter.
>>> How do I get "At "cobalt=>"?
>>
>>
>>  psql cobalt
>>
>>
>>> 5) Other instructions I found on the net recommend that one should comment
>>> out rather than deleting the following. What is the best thing to do?
>>>
>>> REMOVE THE QUOTA STUFF (SINCE IT'S BROKEN ANYWAY):
>>> - -  Edit 'cobalt-schema' and remove the 'CREATE TABLE "quota" ( );"
>>
>>  As long as you have the backup, go ahead and delete them.
>>
>>
>>> section (spread over 2-3 lines)
>>> - -  Remove the 'COPY "quota" FROM stdin;' line (end of schema file)
>>> - -  Exit editor and save changes
>>
>>  I am not sure this is necessary.
>>  last time I tried it, (yestereday on an XTR) I got errors.
>>  so I left it in and it worked OK.
>>  Maybe a postgre guru can comment on this!
>>
>>
>>> 6) Here is your script I found at
>>> http://list.cobalt.com/pipermail/cobalt-users/2002-December/082670.html
>>> Would you please confirm integrity.
>>
>>  I use http://www.raqware.com/how2.html#fix-postgre
>>  This was found on the Inet and I made some additions
>>
>>  I have never used the procedure you posted, so I really
>>  can't comment on it....
>>
>>Gerald
>
>
>
>
>OK. Thank you Gerald and Bruce.
>
>The instructions at http://www.raqware.com/how2.html#fix-postgre are very
>clear.
>
>If the Rebuild Postgre fails is the following the right script to restore
>data base from cobalt.dump.bak?
>
>destroydb cobalt
>OR (RaQ4+) dropdb cobalt
>createdb cobalt
>psql cobalt < cobalt.dump
>
>Thanks again.
>
>
>




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)