[GENERAL] Re: [postgresql 9.3.5] autovacuums stuck on non-existent pg_toast tables

2015-02-28 Thread tpham
Hi Álvaro, Pardon my stupidity. I kept looking for things in the wrong place. The pg_toast tables have always been there, I was just issuing the commands yo mentioned in a different database. Need to get more sleep. xD In the end, we decided the entire database needed a good cleaning. So we sched

[GENERAL] Re: [postgresql 9.3.5] autovacuums stuck on non-existent pg_toast tables

2015-02-28 Thread tpham
Hi Erik, I thouht pg_cancel_backend and pg_terminate_backend simply send SIGINT and SIGTERM, respectively, to the backend process? We did try using the commands and sending the signals ourselves, but to no avail. -- View this message in context: http://postgresql.nabble.com/postgresql-9-3-5-au