Re: Cannot vacuum even in single-user mode after xidStopLimit isreached

On 18.02.2019 17:18, Jahwan Kim wrote:
> Thanks for the reply.
> 
> (1) The problem is, I cannot drop any of the temp tables, not even in 
> the single-user mode. It says
> 'vacuum', 'You might also need to commit or roll back old prepared 
> transactions.'
> And, no, there seems to be no pending prepared transaction either.

Can you show the exact whole message?

Do I understand correctly. Are temp tables persist in pg_class even 
after trying to drop temp tables in single-user mode?

-- 
Arthur Zakirov
Postgres Professional: http://www.postgrespro.com
Russian Postgres Company