w trillich wrote: >of course, nothing can go perfectly smoothly--here's how it >ended: > ># apt-get install postgresql ><yada yada> > >Run postgresql-dump to dump the old database and to reload >it in the new format. >*** READ /usr/share/doc/postgresql/README.Debian.migration.gz FIRST! *** > >The version 6.5 postmaster cannot be started until >this is done. >ps: unknown long option >usage: ps acehjlnrsSuvwx{t<tty>|#|O[-]u[-]U..} \ > --sort:[-]key1,[-]key2,... > --help gives you this message > --version prints version information You need to update procps, because the command line options of ps changed a lot and postgresql's installation scripts use the new options.
After doing that, do `dpkg --pending --configure', which should pick up postgresql and run its post-installation script again. Then go and read the migration README, as recommended. (see above) >so now i gotta figure out how to get the old postgres out >(there's no useful data, i could just ditch the /var/postgres/data >directory but i'm sure that'd break something, right) and then >get the new one in... That would destroy your data. If you have a backup in pg_dump format, you could use that to restore. > >=== > >why did i try the *deb/*rpm method? why, i simply read >the documentation... > >part of where i got misdirected, i suppose, was from >doc/debian/FAQ/debian-faq-10.html and others like it. > >"yank a *deb", it recommends, "and then dpkg to install it". Yes, so far as it goes. However, doing it that way means you have to wait to find out what its dependencies are and go and fetch the required packages, and then the same again for them... When you've finally got them all, `dpkg --pending --configure' will finish the installation, unless you have unsatisfiable dependencies. -- Oliver Elphick [EMAIL PROTECTED] Isle of Wight http://www.lfix.co.uk/oliver PGP key from public servers; key ID 32B8FAA1 ======================================== "For the word of God is quick, and powerful, and sharper than any twoedged sword, piercing even to dividing soul and spirit, joints and marrow; and is a discerner of the thoughts and intents of the heart." Hebrews 4:12