On Mon, Dec 22, 2008 at 10:22 AM, paulo matadr <saddon...@yahoo.com.br> wrote: > > My vacuum was follow error below: > WARNING: oldest xmin is far in the past > HINT: Close open transactions soon to avoid wraparound problems. > No have transactions in locked ,
Transactions don't have to hold locks to cause problems. Generally speaking you've got an old transaction being held open. what does: select min(xact_start) from pg_stat_activity; say? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
