Re: PG on Debian 4.0.x ?

Dimitri Fontaine wrote:
> Le mardi 08 mai 2007, Andreas a écrit :
> > Do you know where I find PG 8.2.4 and pgAdmin 1.6.3 binaries for Debian
> > 4.0.x ?
>
> For server-side debian stable, you can build yourself the package by simply
> following those steps :
> 1. have your deb-src line (from /etc/apt/sources.list) point to sid
> 2. apt-get update
> 3. apt-get build-dep postgresql-8.2
> 4. apt-get source -b postgresql-8.2
>
> Then install postgresql-common package, for debian postgresql scripts
> (as /etc/init.d/postgresql-8.2 and /usr/bin/{psql,pg_dump,...}).
> 5. apt-get install postgresql-common
>
> Then you install the wanted .deb files with dpkg -i, including libpq5_8.2*deb,
> all in a single command line:
> 6. dpkg -i ...
>
> On the client side, simply add this following source :
> # pgadmin3 1.6.x
> deb ftp://ftp3.fr.postgresql.org//pub/postgresql/pgadmin3/release/debian
> testing pgadmin
>
> Then apt-get update and apt-get install pgadmin3.

I tried it here and it didn't work because it only has packages for
i386, and my system is amd64. However, I got it by source with

deb-src ftp://ftp3.fr.postgresql.org//pub/postgresql/pgadmin3/release/debian testing pgadmin
aptitude update
apt-get build-dep pgadmin3
apt-get source -b pgadmin3
dpkg -i pgadmin...deb

Took about three minutes of my time, a bit more of machine time.
It automatically downloaded wxWidgets, configured and compiled
everything and I got pgadmin installed on my system for the first time.
Yay! Thanks Dimitri.

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support