Re: [cobalt-users] Site Quotas

[Kim Schulz <kim@xxxxxxxxx>]

On Sat, 06 Dec 2003 13:36:47 -0500 (EST)
Gerald Waugh <gwaugh@xxxxxxxxxxxxxxxxxxxxxxx> wrote:
> 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


I have done this serval times (10+) and it works fine.