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