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)
>
>
>_____________________________________




One last question...  Before I Rebuild Postgre do I need to disable any
services on my server?

Thanks.

Bo von Hohenlohe
Bo von Hohenlohe Productions
bvhprods@xxxxxxx
http://www.artfreak.com
http://www.maddogcom.com/