Re: ERROR: found multixact from before relminmxid - Mailing list pgsql-general

From Adrien NAYRAT
Subject Re: ERROR: found multixact from before relminmxid
Date
Msg-id 1c63782e-ca6e-8456-d946-238a71045275@anayrat.info
Whole thread Raw
In response to Re: ERROR: found multixact from before relminmxid  (Alexandre Arruda <adaldeia@gmail.com>)
List pgsql-general
On 11/7/18 1:21 PM, Alexandre Arruda wrote:
> The best solution that I have found is kick all connections and execute 
> a select for update to /dev/null in the affected tables, i.e.:
> 
> psql -o /dev/null -c "select * from table for update" database
> 
> After this, the vacuum is executed w/o problems again.
> 
> Best regards,
> 
> Alexandre

Thanks Alexandre, I will try.


pgsql-general by date:

Previous
From: Lance Luvaul
Date:
Subject: Full list of operations that constitute a "maintenance" operation?
Next
From: Laurenz Albe
Date:
Subject: Re: Full list of operations that constitute a "maintenance"operation?