Re: help! - how to get postgres 7.3 back
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 <richard@the-place.net> 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
Reply to: