Re: postgresql 6.5.3 vs. debian
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 Oliver.Elphick@lfix.co.uk
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
Reply to: