Re: probs with 7.3 -> 7.4 on debian

On Wed, 2004-01-14 at 14:47, glenn wrote:
> Hi all
> Debian has upgraded me to 7.4 ofpostgres, but when it tries to  start
> postgres I get an error mentioning that the data is in 7.3 format and
> needs to be upgraded to 7.4 format before postmaster will start.
>
>
> "dpkg-reconfigure postgresql" attempts to do just this for me, but fails
> during upgrade.
>
> so I follow the instructions in README.Debian.migration like so:
>
> odin:~# su -s /bin/bash - postgres
> postgres@odin:~$ postgresql-dump -t db.out -dcivlp $PGDATA/../data.save
> Stopping and restarting the postmaster
> /var/lib/postgres/dumpall/7.3/postmaster -D /var/lib/postgres/data  -p
> 5431 -o -d0
> /var/lib/postgres/dumpall/7.3/postmaster: error while loading shared
> libraries: libcom_err.so.1: cannot open shared object file: No such file
> or directory
> Failed to start the postmaster
> postgres@odin:~$
>
> Is any one able to point me the right way from here?

Yes, this is a known problem.  Look at
http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=225812 and
http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=225635

Solution:

If you have an up to date dump, move $PGDATA aside, initdb and load your
dump.

Otherwise:
rm -rf /var/lib/postgres/dumpall/7.3/
reinstall 7.3.4-9 from testing for the packages postgresql,
postgresql-client and libpq3; use dpkg --force-downgrade --force-depends
--force-conflicts to do it - it's only for a few minutes.
Make a dump now
reinstall 7.4.1 - this time the upgrade should work, and if not, you can
do a manual upgrade with your just-taken dump as shown above .

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight, UK                             http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
                 ========================================
     "If we confess our sins, he is faithful and just to
      forgive us our sins, and to cleanse us from all
      unrighteousness."          I John 1:9


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match