Re[2]: [cobalt-users] Meta-Verify Errors - URGENT

[COMPUTICA <cobalt@xxxxxxxxxxxxxxxxxx>]

On Tuesday, October 22, 2002, 10:23:36 AM, you wrote:

a> Here is how to fix PostgreSQL:

a> Occasionally the Postgres "cobalt" database on a RaQ will go totally south and 
a> the Virtual Site list in the control panel suddenly stops doing anything 
a> useful. Like existing.

a> First ensure that the problem is not simply caused by Postgres dying. Type:
a> ps -ef |grep postmaster and look for something other than the grep in your 
a> output. If there is nothing there then restart Postgres (see "Starting 
a> PostgreSQL" in the page list)If the site list is still missing then the 
a> database has smurfed and needs some TLC

a> Some problems of this nature can be sorted by downloading and running the 
a> siteManage-fix script (http://www.raqhelp.co.uk/downloads/siteManage-fix.tgz), 
a> but if this fails you have no choice but to drop the database completely and 
a> recreate it.
a> There are two ways to do this; the easy way, and the brutal way. This page 
a> describes the easy way.

a> The procedure is as follows...

a> su rootcd /usr/local/sbin/./setup-postgres./meta-verify -u -i ./meta-verify -u 
a> -a./meta-verify -s -i./meta-verify -s -a

a> The meta-verify script (http://www.raqhelp.co.uk/downloads/meta-verify.gz) is 
a> not present on some RaQ 3's (for some reason) so you can collect this copy 
a> with wget and gunzip it into the correct location.

a> The database is now fresh and blank and virgin, so you will now need to 
a> recreate the contents of the siteManage pages for each site using the sitefix 
a> script (http://www.raqhelp.co.uk/downloads/sitefix.gz).

a> wget it and gunzip it into /usr/local/sbin and run it thus:
a> ./sitefix.pl

a> All being well, you should now have a functional Virtual Site list in your 
a> admin control panel, although some of the settings may be out of whack 
a> (incorrect disk quotas, SSI and/or CGI facilities switched off, and so on)
a> A thorough check of all sites will be required to ensure everything is as it 
a> should be.

a> THIS ARTICLE COPIED FROM The Cobalt RaQ Server Support Site 
a> (http://www.raqhelp.co.uk)

a> Regards,

a> Al-Juhani
a> aljuhani@xxxxxxxxx




Okay, I logged in as root and ran the following and got this output:

-----
[root /root]# ps -ef |grep postmaster
postgres  1147     1  0 Oct21 ?        00:00:01 /usr/bin/postmaster
root     25263 25243  0 10:47 pts/0    00:00:00 grep postmaster
[root /root]#
-----

I am unsure what you mean by "look for something other than the grep
in your output"

I see the word grep in the output, so does that mean I should not
restart Postgres?

Thanks,
Ryan