launchpad-dev team mailing list archive
-
launchpad-dev team
-
Mailing list archive
-
Message #01354
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