[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [cobalt-users] POSTGRES Cobalt - Rebuild indexes
- Subject: Re: [cobalt-users] POSTGRES Cobalt - Rebuild indexes
- From: Bruce Timberlake <bruce@xxxxxxxxxx>
- Date: Sat Dec 7 20:01:01 2002
- Organization: BRTNet.org
- List-id: Mailing list for users to share thoughts on Sun Cobalt products. <cobalt-users.list.cobalt.com>
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
> but when I make the dump I've got a error :
>
> SQL query to dump the contents of Table 'quota' did not execute.
> Explanation from backend: 'ERROR: cannot find attribute 1 of
> relation quota '. The query was: 'COPY "quota" TO stdout; '.
You need to edit the schema file that you dumped and remove the entire
quota table section, THEN rebuild the database. Remember, the quota
table is broken, so the schema section has to be broken too.
When swatch runs again (Active Monitor, every 15 minutes), it will
recreate the quota table properly.
- --
Bruce Timberlake
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)
iD8DBQE98sMQvLA2hUZ9kgwRAp+vAJsHtYH5V4IQSxeSdzYnDtwUejWe/QCePXwb
sSHSA7tAMfLyJJBrLrQb3XU=
=gmDJ
-----END PGP SIGNATURE-----