← Back to team overview

launchpad-dev team mailing list archive

Postgresql 8.4 lacks pg_autocacuum

 

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

There's been some talk about upgrading our supported postgresql to 8.4,
so when my machine autoremoved 8.3, I gave it a shot.

I had to tweak some scripts, but the final stumbling block was this:


* Setting up full text indexes
* Security setup
* Disabling autovacuum
Traceback (most recent call last):
  File "unautovacuumable.py", line 75, in ?
    sys.exit(main())
  File "unautovacuumable.py", line 48, in main
    cur.execute("""
psycopg2.ProgrammingError: relation "pg_autovacuum" does not exist
LINE 2:         INSERT INTO pg_autovacuum
                            ^

make[1]: *** [create] Error 1

If someone more postgres-savvy than me could look into this, that would
rock.  Going back to 8.3 for now.

Aaron
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAkrYzIQACgkQ0F+nu1YWqI1fxwCfUbme2/2T5b0mP6YhV9gEL94Y
PdkAn3aLQF2rWTSh6/ftFxj8P9D+jWYs
=ofzd
-----END PGP SIGNATURE-----



Follow ups