Some Errors Installing PG 8.1 On Deb 3.1 Server

I'm still building up Virtual Server to host a Catalyst Web Framework development project (maybe this could turn into a Cinlug presentation?)

The apt/sources.list by default points to stable. I'd prefer this, cuz of the security updates. But I need Postgresql 8.1, and stable has PG 7+.

I added testing sources to sources.list. I don't *really* know what I'm doing, I just copied existing stable sources lines, and changed 'stable' to 'testing.'

Then I did a --dry-run install, and got some errors, mostly "can't find some/Packages.gz" -- any worries there? Hints to clear those out? I looked around debian.org awhile, looking for sources.list recommendations, wandered around the labyrinth....

My bigger worry is an item that would be deleted and others that would be added.

For example:
Remv base-config (2.53.10.2 Debian:3.1r3/stable)

Not sure what that would do.

And these -- why does he want to install mysql client?:

Inst mysql-client [4.0.24-10sarge2]
Inst mysql-common [4.0.24-10sarge2]
Inst libmysqlclient15off
Inst mysql-client-5.0

And this -- why install ftp?
Inst ftp [0.17-12]

I posted a page on new web site showing sources.list, apt-get update errors, and --dry-run install errors, in case there might be anything important I've not spotted.

http://65.254.63.231/tmp/test-build-pg-8.1.html

I really appreciate any help. This is my first server sitting on the internet. I'd like to do the best job I can to make sure it's clean.

/dennis

Comments

Dependencies

[quote]And these -- why does he want to install mysql client?: Inst mysql-client [4.0.24-10sarge2] Inst mysql-common [4.0.24-10sarge2] Inst libmysqlclient15off Inst mysql-client-5.0 And this -- why install ftp? Inst ftp [0.17-12] [/quote] Some package you're installing has dependencies on those packages. Since you're installing postgresql, some of its dependencies probably have or'd dependencies on mysql *or* postgres and since the mysql dependencies are listed first, they'll be installed. You should be able to remove the mysql packages without issue. ftp is just the command line ftp client - it's a dependency of something you're installing. As for the removed packages, they're being removed since they conflict with something you're trying to install. If you're adamant about sticking with stable, you should look at backports.org or volatile.debian.net - both sites have packages built for Debian stable and they tend to work better on stable than choice packages from testing or unstable. Testing isn't as volatile as it used to be since the next stable release is pending. Testing also offers security support if I'm not mistaken. Finally, we're always looking for presenters if you're willing to present at an upcoming meeting :)

OK, Deleting testing/non-US line fixes "can't find package" errs

Deleted this line:

deb http://non-us.debian.org/debian-non-US testing/non-US main contrib non-free