Re: [cobalt-users] Site Quotas

[Thom LaCosta <baltimoremd@xxxxxxxxxxxxxxx>]

On Sat, 6 Dec 2003, Kim Schulz wrote:

> > su -
> > cd /var/lib/pgsql
> > vi pg_hba.conf

it's really in /var/lib/pqsql/data on my machine

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

gives me this error
psql: No pg_hba.conf entry for host localhost, user postgres, database
template1
dropdb: database removal failed


So, in frustration I tried
http://list.cobalt.com/pipermail/cobalt-users/2002-January/062036.html

su root
/etc/rc.d/init.d/postgresql stop
mkdir /var/lib/pgsql/dataold
mv /var/lib/pgsql/data  /var/lib/pgsql/dataold
mkdir /var/lib/pgsql/data
chown postgres:postgres /var/lib/pgsql/data
chmod 700 /var/lib/pgsql/data
su postgres
initdb -D /var/lib/pgsql/data
su root
/etc/rc.d/init.d/postgresql start
cd /usr/local/sbin
./meta-verify -si
Answer yes to all questions   uppercase Y
./meta-verify -sa
Answer yes to all questions
./meta-verify -ui
Answer yes to all questions
#./meta-verify -ua
Answer yes to all questions
/usr/local/sbin/swatch

Which recreated the database, etc.....gave no errors,
and still reports incorrect disk usage.

So, I'm open to suggestions.

Thom