On 2014-09-18 22:52:57 +0530, Dev Kumkar wrote: > On Thu, Sep 18, 2014 at 6:20 PM, Dev Kumkar <devdas.kumkar@xxxxxxxxx> wrote: > > > On Thu, Sep 18, 2014 at 4:03 PM, Andres Freund <andres@xxxxxxxxxxxxxxx> > > wrote: > > > >> I don't think that's relevant for you. > >> > >> Did you upgrade the database using pg_upgrade? > >> > > > > That's correct! No, there is no upgrade here. > > > > > >> Can you show pg_controldata output and the output of 'SELECT oid, > >> datname, relfrozenxid, age(relfrozenxid), relminmxid FROM pg_database;'? > >> > > > > Here are the details: > > oid datname datfrozenxid age(datfrozenxid) datminmxid > > 16384 myDB 1673 10872259 1 > > > > Additionally wanted to mention couple more points here: > > When I try to run "vacuum full" on this machine then facing following > > issue: > > INFO: vacuuming "myDB.mytable" > > ERROR: MultiXactId 3622035 has not been created yet -- apparent > > wraparound > > > > No Select statements are working on this table, is the table corrupt? > > > > Any inputs/hints/tips here? Yes: Learning some patience. You'd given the previous answer two hours before this one. Nobody is paid to work on this list... Greetings, Andres Freund -- Andres Freund http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
