Re: [GENERAL] Index pg_proc_prosrc_index: NUMBER OF INDEX' TUPLES (1071)ISNOT THE SAME AS HEAP' (1070)

Bruce Momjian wrote:

> > > > > > Anyone seen this message or know what it means?
> > > > > >
> > > > > > NOTICE:  Index pg_proc_prosrc_index: NUMBER OF INDEX' TUPLES (1071) IS
> > > > > > NOT THE SAME AS HEAP' (1070)
> > > > >
>
> The only way to fix that is to initdb, I think.  I would recommend
> pg_upgrade, after removing the disable from the pg_upgrade script that
> was added in 6.5.  That will fix it.  Not sure how it got that way,
> though.

El dope primero aqui...

Thanks for the tip.  Here's what I had to do to make this work, for what it's worth
to future travelers...

Cheers,
Ed Loehr

psql -d mydb -c "select * from title;" > before
                                             # Save for after cmp test...
cd /usr/local/pgsql                          # my install root...
vacuumdb mydb                                # clean up before moving...
cp -pr data data.backup                      # make a backup...
pg_dumpall -s > schema.sql                   # dump schema w/out data...
killall postmaster                           # stop the server...
sleep 3
mv data data.old                             # set it aside...
cd /usr/src/pgsql/src                        # to the src tree...
gmake install                                # reinstall binaries...
cd /usr/local/pgsql                          # back to my install root...
initdb                                       # recreate template1, sys stuff...
postmaster -i -o "-F -S 4096 -s" >& log &    # restart server...
sleep 3
pg_upgrade -f schema.sql data >& upgrade.log # reload schema...
cp -p data.old/base/mydb/* data/base/mydb/   # replace data...
psql -d mydb -c "select * from title;" > after
                                             # verify we still have data...
diff before after                            # quick sanity check...