On Friday 09 January 2004 19:46, Monique Y. Herman wrote: > On 2004-01-09, Richard Lyons penned: > > On Friday 09 January 2004 16:19, Richard Lyons wrote: > >> On Friday 09 January 2004 15:02, Nicos Gollan wrote: > >> > On Fri, 9 Jan 2004 14:24:33 +0000 > >> > > >> > Richard Lyons <[EMAIL PROTECTED]> wrote: > >> > > Running sid. postgresql is now 7.4, but won't open until I > >> > > upgrade the database, which I can't without 7.3. What do I > >> > > do? [...] > What about browing to > http://ftp.de.debian.org/pub/debian/pool/main/p/postgresql/ > > and downloading an appropriate version of postgresql, then forcing > the install with dpkg?
Yes, thanks again Monique, I have quite muddled this thread with adding to my own postings. That was what Nicos Gollan suggested a few hours earlier, and I reported my failure in a different post. I'll repeat it for simplicity: I went to ftp://ftp.debian.org/debian/pool/main/p/postgresql/ and got postgresql-client and postgresql, both 7.3.4-9. Then this is what happened: ----------------------- dpkg -i /home/richard/files/temp/postgres*.deb dpkg - warning: downgrading postgresql-client from 7.4.1-1 to 7.3.4-9. (Reading database ... 148728 files and directories currently installed.) Preparing to replace postgresql-client 7.4.1-1 (using .../ postgresql-client_7.3.4-9_i386.deb) ... Unpacking replacement postgresql-client ... dpkg - warning: downgrading postgresql from 7.4.1-1 to 7.3.4-9. dpkg: regarding .../postgresql_7.3.4-9_i386.deb containing postgresql: libpgtcl conflicts with postgresql (<< 7.4) postgresql (version 7.3.4-9) is to be installed. dpkg: error processing /home/richard/files/temp/ postgresql_7.3.4-9_i386.deb (--install): conflicting packages - not installing postgresql Setting up postgresql-client (7.3.4-9) ... Errors were encountered while processing: /home/richard/files/temp/postgresql_7.3.4-9_i386.deb ---------------------------- So there apparently was no problem with the client but the server failed. I was stumped then to know what to do next. It has just occured to me that I have Woody on another machine. It has postgres 7.2. Perhaps I can upgrade that to 7.3 and copy the database across. It'll mean a lot of floppies because nfs doesn't work on the Woody (not supported by the kernel apparently). Then I could dumpall and copy it back... Not ideal, but I might look into that tomorrow, if 7.3 is possible with woody. -- richard -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
