Anyone know where I can get an 8.2.3 binary for ubuntu?

Subject says it all. Doing a source compile under Debian or
Debian-like condition is not an option for the end user. They need
an apt-get (the ubuntu equivalent to rpm AFAICT) version.

Unfortunately, the latest I can find is 8.1.8
Where's 8.2.3?

What ubuntu version do you have? I believe that 8.2.3 is at the
repositories for edgy and feisty. Or download the .debs from
https://launchpad.net/ubuntu/+source/postgresql-8.2

Regards

MP

Doing a source compile under Debian or Debian-like condition is not an option for the end user.

Oh, it is not? Is that because of the outdated tool chain Debian ships
with or the user being uncomfortable in typing 3 commands at a shell prompt?

Unfortunately, the latest I can find is 8.1.8

Well, I think you distributions website has "an apt-get":

http://packages.debian.org/experimental/misc/postgresql-8.2

Besides that Google returns a ton more:

http://rpmseek.com/rpm-pl/postgresql-8.2.html?hl=de&cx=824:P:0

Ron wrote:

Subject says it all. Doing a source compile under Debian or Debian-like
condition is not an option for the end user. They need an apt-get (the
ubuntu equivalent to rpm AFAICT) version.

Unfortunately, the latest I can find is 8.1.8
Where's 8.2.3?

--
Best regards,
Hannes Dorbath

On Mar 31, 2007, at 12:19, Ron wrote:

Subject says it all. Doing a source compile under Debian or Debian-
like condition is not an option for the end user. They need an apt-
get (the ubuntu equivalent to rpm AFAICT) version.

Ubuntu has 8.2.3 in the upcoming Feisty distribution; in the
meantime, you can install it on Edgy from the edgy-backports tree:

http://packages.ubuntu.com/cgi-bin//search_packages.pl?
version=all&subword=1&exact=&arch=any&releases=all&case=insensitive&keyw
ords=postgresql-8.2&searchon=names

This requires adding a source line to /etc/apt/sources.list that
references this repository. This should suffice:

deb http://gb.archive.ubuntu.com/ubuntu/ edgy-backports main
restricted universe
deb-src http://gb.archive.ubuntu.com/ubuntu/ edgy-backports main
restricted universe

(You might want to substitute your country code for "gb" in the URLs.)

Alexander.

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 03/31/07 11:51, Alexander Staubo wrote:

On Mar 31, 2007, at 12:19, Ron wrote:

Subject says it all. Doing a source compile under Debian or Debian-like
condition is not an option for the end user. They need an apt-get (the
ubuntu equivalent to rpm AFAICT) version.

Hmmmm. Maybe I'm just in a grumpy mood today, but that really
Grinds My Gears.

Anyone who an figure out how to use PostgreSQL can figure out how to
use apt-build.

- --
Ron Johnson, Jr.
Jefferson LA USA

Give a man a fish, and he eats for a day.
Hit him with a fish, and he goes away for good!

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFGDpoyS9HxQb37XmcRAmUUAKDmVqdpcs7QG0bNc3CPM8FDsQ1L0QCdGY1G
yfOGaov1YP0r6mKLE6pkuTU=
=LnOx
-----END PGP SIGNATURE-----

Hmmmm. Maybe I'm just in a grumpy mood today, but that really
Grinds My Gears.

Anyone who an figure out how to use PostgreSQL can figure out how to
use apt-build.

Hardly. I have more than my fair share of customers that:

1. Develop on windows (in php)
2. Only use winscp
3. Couldn't configure, install or load linux or postgresql if they had a
gun to their head.

Better yet, these "users" are very profitable in their respective fields
and are actually half way decent php programmers (snickers aside).

You will also find that in many environments, especially enterprise
environments a pervasive string of Java developers who known "nothing"
of the database except for what Hibernate tells them.

I quote, "You mean there is tuning that has to be done beyond java?"

Joshua D. Drake

- --
Ron Johnson, Jr.
Jefferson LA USA

Give a man a fish, and he eats for a day.
Hit him with a fish, and he goes away for good!

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFGDpoyS9HxQb37XmcRAmUUAKDmVqdpcs7QG0bNc3CPM8FDsQ1L0QCdGY1G
yfOGaov1YP0r6mKLE6pkuTU=
=LnOx
-----END PGP SIGNATURE-----

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

On 4/1/07, Mikko Partio <dun@haisuli.net> wrote:

Subject says it all. Doing a source compile under Debian or
Debian-like condition is not an option for the end user. They need
an apt-get (the ubuntu equivalent to rpm AFAICT) version.

Unfortunately, the latest I can find is 8.1.8
Where's 8.2.3?

What ubuntu version do you have? I believe that 8.2.3 is at the
repositories for edgy and feisty. Or download the .debs from
https://launchpad.net/ubuntu/+source/postgresql-8.2

Regards

MP

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

and once you downloaded the packages do a :

apt-get build-deps postgresql-8.1
then

dpkg-source -x postgresql-8.2_8.2.3-2.dsc
cd postgresql-8.2-8.2.3
edit debian/control and put the dapper's version for debhelper and cdbs
dpkg-buildpackage -us -nc

you may ignore the version dependency for debhelper and cdbs or edit the
debian/control file to use the dapper version for those packages

then
add this to your /etc/apt/sources.list

deb-src http://archive.ubuntu.com/ubuntu/ feisty main universe

then

apt-get source tzdata
cd tzdata-2007b
dpkg-buildpackage -rfakeroot
cd ..
dpkg -i tzdata_2007b0ubuntu1_all.deb

and now install postgresql 8.2.3

--
Leonel

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 03/31/07 12:48, Joshua D. Drake wrote:

Hmmmm. Maybe I'm just in a grumpy mood today, but that really
Grinds My Gears.

Anyone who an figure out how to use PostgreSQL can figure out how to
use apt-build.

Hardly. I have more than my fair share of customers that:

1. Develop on windows (in php)
2. Only use winscp
3. Couldn't configure, install or load linux or postgresql if they had a
gun to their head.

That's where my grumpiness clouded my mad writing skillz.

I meant "figure out how to *install* PostgreSQL".

Better yet, these "users" are very profitable in their respective fields
and are actually half way decent php programmers (snickers aside).

You will also find that in many environments, especially enterprise
environments a pervasive string of Java developers who known "nothing"
of the database except for what Hibernate tells them.

I quote, "You mean there is tuning that has to be done beyond java?"

Joshua D. Drake

- --
Ron Johnson, Jr.
Jefferson LA USA

Give a man a fish, and he eats for a day.
Hit him with a fish, and he goes away for good!

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFGDrnJS9HxQb37XmcRAqhLAKDqN3/3YKMO21EHT5yYIx/YOIYoIwCgvFC4
+XlOSJkybi2dBkXJu9iinp8=
=SY2r
-----END PGP SIGNATURE-----

Am 2007-04-01 12:05:44, schrieb Leonel:

and once you downloaded the packages do a :

apt-get build-deps postgresql-8.1

Are you sure? -- It should be:

apt-get build-deps postgresql-8.2

then

dpkg-source -x postgresql-8.2_8.2.3-2.dsc
cd postgresql-8.2-8.2.3

cd postgresql-8.2

edit debian/control and put the dapper's version for debhelper and
cdbs
dpkg-buildpackage -us -nc

dpkg-buildpackage -us -nc -rfakeroot

Greetings
Michelle Konzack
Systemadministrator
Tamay Dogan Network
Debian GNU/Linux Consultant

--
Linux-User #280138 with the Linux Counter, http://counter.li.org/
##################### Debian GNU/Linux Consultant #####################
Michelle Konzack Apt. 917 ICQ #328449886
50, rue de Soultz MSN LinuxMichi
0033/6/61925193 67100 Strasbourg/France IRC #Debian (irc.icq.com)

On 4/5/07, Michelle Konzack <linux4michelle@freenet.de> wrote:

Am 2007-04-01 12:05:44, schrieb Leonel:

and once you downloaded the packages do a :

apt-get build-deps postgresql-8.1

Are you sure? -- It should be:

You don't have the build-dep for 8.2 in ubuntu dapper/ edgy

apt-get build-deps postgresql-8.2

First is apt-get build-dep not deps
and this is what you get when trying to get the build-dep for 8.2 :

E: Build-Depends dependency for postgresql-8.2 cannot be satisfied
because no available versions of package debhelper can satisfy version
requirements

then

dpkg-source -x postgresql-8.2_8.2.3-2.dsc
cd postgresql-8.2-8.2.3

cd postgresql-8.2

again no

after you run dpkg-source you don't get a postgresql-8.2
directory you get a postgresql-8.2-8.2.3

edit debian/control and put the dapper's version for debhelper and
cdbs
dpkg-buildpackage -us -nc

dpkg-buildpackage -us -nc -rfakeroot

Greetings
Michelle Konzack
Systemadministrator
Tamay Dogan Network
Debian GNU/Linux Consultant

--
Linux-User #280138 with the Linux Counter, http://counter.li.org/
##################### Debian GNU/Linux Consultant #####################
Michelle Konzack Apt. 917 ICQ #328449886
50, rue de Soultz MSN LinuxMichi
0033/6/61925193 67100 Strasbourg/France IRC #Debian (irc.icq.com)

--
Leonel

On 4/5/07, Michelle Konzack <linux4michelle@freenet.de> wrote:

Am 2007-04-01 12:05:44, schrieb Leonel:

and once you downloaded the packages do a :

apt-get build-deps postgresql-8.1

Are you sure? -- It should be:

You don't have the build-dep for 8.2 in ubuntu dapper/ edgy

I recently installed kubuntu and postgres 8.2.3 is available in apt-get
(edgy backports I think).

On 4/5/07, Listmail <lists@peufeu.com> wrote:

On 4/5/07, Michelle Konzack <linux4michelle@freenet.de> wrote:

Am 2007-04-01 12:05:44, schrieb Leonel:

and once you downloaded the packages do a :

apt-get build-deps postgresql-8.1

Are you sure? -- It should be:

You don't have the build-dep for 8.2 in ubuntu dapper/ edgy

I recently installed kubuntu and postgres 8.2.3 is available in apt-get
(edgy backports I think).

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

great!
and that backport will have security updates ?

--
Leonel