-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Christoph Martin wrote: |> Oliver Gorwits schrieb: |>> The nightly batch routine (netdisco -B) should only ask |>> PostgreSQL to vacuum named tables, which avoids this error you |>> have. |>> |>> The default value for the db_tables setting is: | | I included the line in the config, but the message is still present. Yes, sorry I was looking at the latest CVS code and not the 0.95 release which the Debian packages are based upon. What is happening is that a VACUUM ANALYZE is being run on all tables, and of course the netdisco postgres user does not have permissions to do that on all tables. The new 0.96 code includes the fix for this. It seems I'll need to write an additional patch for the Debian package. I think it's safest to comment out the VACUUM ANALYZE nightly run - this is because on Debian systems there's an /etc/cron.d/postgresql-common which already does VACUUM ANALYSE on all databases every 5 hours. I'll let you know when the patch is in the svn.debian.org repo. regards, oliver. - -- Oliver Gorwits, Network and Telecommunications Group, Oxford University Computing Services -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFIx4572NPq7pwWBt4RAtMaAJ9CHQm7xhMgSAk5oQtqcHgaGH5P8ACfRK4O +jPVNLW9ddkqfhOnaHrMJfk= =znfv -----END PGP SIGNATURE----- -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
