Selva manickaraja <mavles78@gmail.com> 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