On 8/25/06, Wouter Verhelst <wouter@debian.org> wrote:
On Fri, Aug 25, 2006 at 11:36:15AM +0800, Jason Tan Boon Teck wrote:
> Hi,
>
>
> My earlier attempt was on a fresh Sarge install and was thus less
> problematic.
>
> I'm now trying to install PostgreSQL
v8.1 onto a Sarge v3.0 server
That doesn't exist. It's either Sarge, which is Debian 3.1, or Woody,
which is Debian 3.0. A release version 3.0, codenamed "Sarge", does not
and will not ever exist.
I think you are correct. I didn't realise that 3.0 is not Sarge. When normal boot up was completed, it shows:
Debian GNU/Linux 3.0
just before the log in prompt. And the kernel is 2.4.18bf2. Is there any other way to confirm this?
> with an EXISTING PostgreSQL v7.4. I ran the apt-get install but
> failed, and it asked me to dpkg -P postgresql postgresql-client
>
> I did that and it removed the old version. Then I tried to install
> v8.1again. But now it refused to install.
>
> # apt-get install postgresql-8.1
> Reading Package Lists... Done
> Building Depencency Tree... Done
> Sorry, postgresql-8.1 is already the newest version.
> You might want to run `apt-get -f install' to correct these:
> Sorry, but the following packages have unmet dependencies:
> postgresql-8.1: Depends: postgresql-common (>= 39) but it is not going to
> be installed.
> E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify
> a solution).
That's likely because you can't install a backport which was compiled
for Sarge on a Woody system. If you want to keep the system in its
current state, you are out of luck. If that's not important, you can
first upgrade the woody machine to a sarge machine (see the sarge
release notes for how to do that; you can find these on the Debian
website), and then install the postgresql backports.
I will try this upgrade suggestion.
My main problem was not being able to display in PHP5 date fields prior
to 1/1/70, retrieved from PostgreSQL v7.4.x. It worked flawlessly in
the fresh server built with backported Sarge v3r2.
--
<Lo-lan-do> Home is where you have to wash the dishes.
-- #debian-devel, Freenode, 2004-09-22