Web Hosting Talk







View Full Version : ARGH Postgres woes!


2Grumpy
11-19-2001, 12:51 PM
Ok installed the latest security patch, rebooted.

Couldn't access the site manager in the control panel

Finally realized postgresql wasn't running.

A little poking around "oh /etc/rc.d/init.d/postgresql" file is missing, no problem, www.linuxdocs.com had a copy of /etc/rc.d/init.d/postgresql and instructions for it (is this a common problem with postgresql for some reason?).

Anyway, created the postgresql file, started it up.

Serveral errors, some very ominous looking ones "can't remove /var/lib/pgsql/data"

Got a copy of the file from another Raq owner, this time postgresql starts right up... EVEN THOUGH the pgsql data and backup directories are TOTALLY EMPTY.

Now when I go to site manager it comes up at least WITH NO VIRTUAL DOMAINS and if I load SITEADMIN on a virtual domain it shows no USERS added even though I know that domain has at least one user (the SITEADMIN!).

Allright RaQ gurus, any ideas on this one? Anyway to mass import all the vhosts and users and stuff into a new postgresql database or something?? Restore the deleted files? anything?

ASPCode.net
11-19-2001, 03:37 PM
http://list.cobalt.com/pipermail/cobalt-users/2001-October/054744.html

There are two things mentioned, cobalt database recreation and meta-verify. Since your database is empty I guess reloading the db won't help, but maybe the meta-verify would?

Havn't tried it myself, but the guy is asking for a way to re-read the virtual site list, so you might try it?

2Grumpy
11-19-2001, 03:55 PM
Ive added a couple dummy sites and users and now have a dump of the database, gonna see if I can just modify the dump with the right info, restore my modified db and go from there.

I'll try this meta verify first, the worst that can happen is it hoses the database :)

Just wish it said "RaQ 4" in the docs instead of 3 but maybe it'll work.

2Grumpy
11-19-2001, 04:11 PM
/usr/local/sbin/meta-verify

all I had to do...

Login as root

issue a /usr/local/sbin/meta-verify -f
(-f for fixall virtual sites and users)

10 seconds later, FIXED, that was it.

Allright, that rules, go go Cobalt!

ASPCode.net
11-19-2001, 04:24 PM
Good to know:) I have read about this meta-verify thing but never knew what it does.

2Grumpy
11-19-2001, 04:28 PM
Well the clincher is, IT WAS ALREADY ON MY FREAKING RAQ...

Live and learn!

Cobalt was already one step ahead of my bumbling...