Re: VACUUM failing ??!!

#1

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

On Fri, 5 Nov 2004, Sally Sally wrote:

Quote:

After running for more than 24 hrs (I have a large db), vacuum failed with
this message:
ERROR: failed to re-find parent key in "pg_type_typname_nsp_index"
Has anybody encountered this before?

AFAIR, you have to REINDEX pg_type to get rid of this error.

Regards,
- --
Devrim GUNDUZ
devrim~gunduz.org devrim.gunduz~linux.org.tr
http://www.tdmsoft.com
http://www.gunduz.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQFBi5pmtl86P3SPfQ4RAtUDAJ4jyT6MMU3b7R/C4xVm918QsSTmkQCfZdCw
AQ6DWpdXhkhVM6jFKUQCQK0=
=GH8N
-----END PGP SIGNATURE-----

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: VACUUM failing ??!!

comp.databases.postgresql.general comp.databases.postgresql.general

Re: VACUUM failing ??!! - 11-05-2004 , 09:21 AM