Selva manickaraja <mavles78@xxxxxxxxx> wrote: > We encountered this for the 3rd time after completing a PITR. > 2011-04-19 12:12:59 MYT LOG: autovacuum: found orphan temp table > "pg_temp_108"."session_id" in database "np" > [for many different temp tables] > Anyone has any idea why this is happening? There were a lot of temp tables open on the master when you made the base backup? It would seem autovacuum is cleaning them up when it comes across them. Do you have some reason to believe that these "LOC" level entries represent some problem? -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
