Re: Neet to get PostgreSQL 7.0.X
Jorge Santos [EMAIL PROTECTED] writes: I need to install PostgreSQL 7.0.X for my job, the version in potato is 6.5.X, so what options do I have, I have downloade the .deb from unstable but it has unmet dependencies. So what options do I have? I was thinking about upgrading to unstable but apt-get dist-upgrade reports that is going to uninstall several packages and I'm wondering if it is such a good idea. Well, summing it up, what is the best option to get PostgreSQL 7.0.X without breaking things? Make sure you have something like deb-src http://http.us.debian.org/debian unstable main contrib non-free in your /etc/apt/sources.lis, and then: su apt-get -b source postgresql If all goes well, you'll get the .debs of the Postgres 7.0.3, which you can install with dpkg -i -- Arcady Genkin Nostalgia isn't what it used to be.
Neet to get PostgreSQL 7.0.X
Hi, I need to install PostgreSQL 7.0.X for my job, the version in potato is 6.5.X, so what options do I have, I have downloade the .deb from unstable but it has unmet dependencies. So what options do I have? I was thinking about upgrading to unstable but apt-get dist-upgrade reports that is going to uninstall several packages and I'm wondering if it is such a good idea. Well, summing it up, what is the best option to get PostgreSQL 7.0.X without breaking things? jorge
Re: Neet to get PostgreSQL 7.0.X
Hi, You might want to consider getting the source or tarball of binary from www.postgresql.org. I've installed such in /usr/local (to not mess with Debian packaging) on my potato system and it works quite nicely. Especially, if you get the almost-released 7.1 (beta5 IIRC) which has write-ahead-logging, outer joins, and lots of other really-appreciated features. In fact, some of these later postgresql releases (6.5) are available as unofficial debian packages for potato. Search the postgresql.org mailing list archives. There's been discussion of it there. Hope this helps, Daniel On Wed, Mar 14, 2001, Jorge Santos wrote: Hi, I need to install PostgreSQL 7.0.X for my job, the version in potato is 6.5.X, so what options do I have, I have downloade the .deb from unstable but it has unmet dependencies. So what options do I have? I was thinking about upgrading to unstable but apt-get dist-upgrade reports that is going to uninstall several packages and I'm wondering if it is such a good idea. Well, summing it up, what is the best option to get PostgreSQL 7.0.X without breaking things? jorge -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED] -- Daniel A. Freedman Laboratory for Atomic and Solid State Physics Department of Physics Cornell University
Re: Neet to get PostgreSQL 7.0.X
On Wed, Mar 14, 2001 at 08:13:37PM -0600, Jorge Santos wrote:
Hi,
I need to install PostgreSQL 7.0.X for my job, the version in potato
is 6.5.X, so what options do I have, I have downloade the .deb from
unstable but it has unmet dependencies. So what options do I have? I
was thinking about upgrading to unstable but apt-get dist-upgrade
reports that is going to uninstall several packages and I'm wondering
if it is such a good idea. Well, summing it up, what is the best
option to get PostgreSQL 7.0.X without breaking things?
good news -- there IS a postgresql that's POTATO-friendly.
first
pg_dumpall save.my.butt.from.idiocy.sql
then munge your sources.list, adding the line:
# /etc/apt/sources.list
deb http://www.samfundet.no/~tfheen/debian potato main
and finally
apt-get update #apt-get upgrade
apt-get install postgres{,-client,-dev,-doc}
NOTE -- the 7.0.3potato0 version from samfundet.no DOES have many
many nice features that 6.5.3 does not -- but there's NO EMBEDDED
PERL just yet. for that you'll have to build it from source, or
(like me) wait...
--
It is always hazardous to ask Why? in science, but it is often
interesting to do so just the same.
-- Isaac Asimov, 'The Genetic Code'
[EMAIL PROTECTED]
http://newbieDoc.sourceforge.net/ -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!
