Re: [GENERAL] Vacuumdb message: AbortTransaction and not in-progress ...

2001-05-23 Thread Tom Lane 

Gabriel Fernandez <[EMAIL PROTECTED]> writes:
> We have some db's in our server. When executing a vacuumdb, ONLY FOR
> SOME of them, the following message is shown:

> AbortTransaction and not in in-progress state

What postgres version?

> After this, the vacuum process is aborted, so we cannot vacuum these
> 'problematic' db's.

The above notice is a consequence of a problem, not its cause.  What
other messages show up in the postmaster log?

regards, tom lane

---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl

[GENERAL] Vacuumdb message: AbortTransaction and not in-progress ...

2001-05-23 Thread Gabriel Fernandez 

Hi,

We have some db's in our server. When executing a vacuumdb, ONLY FOR
SOME of them, the following message is shown:

AbortTransaction and not in in-progress state

After this, the vacuum process is aborted, so we cannot vacuum these
'problematic' db's.

What can we do ?

Gabi :-)







---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])