Re: [cobalt-users] Site Quotas

[Gerald Waugh <gwaugh@xxxxxxxxxxxxxxxxxxxxxxx>]

On Sat, 6 Dec 2003, Thom LaCosta wrote:
>
> For those of us who are tre dumb....how did you delete the quotas table?
> Or should I follow what I found in the ever confusing archives and redo
> all the postgress databases?

Dave Thurman recently did this.
I had a howto , but I have never used it myself,
  so you are on your own...

in a shell session
su -
cd /var/lib/pgsql
vi pg_hba.conf
 change crypt to trust
su postgres
pg_dump cobalt > cobalt.dump
cp cobalt.dump cobalt.dump.save
vi cobalt.dump
 find create_table for quota
 hask it out or delete it
dropdb cobalt
createdb cobalt
pgsql cobalt < cobalt.dump
  if you get unrecoverable errors
  go back to "dropdb cobalt"
  and import the backup
vi pg_hba.conf
  change trust back to crypt
/usr/local/sbin/swatch

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