On Sat, Jun 30, 2012 at 4:32 PM, Jerry Sievers wrote:
> Christian Rosnes writes:
> > Doing a:
> >
>
> ? psql -U postgres -d postgres -c "select * from? pg_prepared_xacts;"
> >
> > I see that there are 72 transactions (across the 5 databases in this
> cluster) with the 'prepared' values listed as
On Sat, Jun 30, 2012 at 3:55 PM, Jerry Sievers wrote:
> Christian Rosnes writes:
>
> > Hi,
> >
> > Coming back from vacation, I find a PostgreSQL database cluster (Pg
> version: 9.0.4)
> > with 5 databases, which for the past 5 days have logged these messages:
> >
> > ? WARNING:? oldest xmin is f
Christian Rosnes writes:
> Hi,
>
> Coming back from vacation, I find a PostgreSQL database cluster (Pg version:
> 9.0.4)
> with 5 databases, which for the past 5 days have logged these messages:
>
> ? WARNING:? oldest xmin is far in the past
> ? HINT:? Close open transactions soon to avoid wrapa
