Date: Sat, 16 Feb 2013 09:44:22 +0100
From: Christoph Berg <myon@debian.org>
To: Bruce Momjian <bruce@momjian.us>
Cc: Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>,
	Josh Berkus <josh@agliodbs.com>, Martin Pitt <mpitt@debian.org>,
	Magnus Hagander <magnus@hagander.net>,
	PostgreSQL WWW <pgsql-www@postgresql.org>,
	PostgreSQL in Debian <pgsql-pkg-debian@postgresql.org>,
	Tom Lane <tgl@sss.pgh.pa.us>
Subject: Re: [pgsql-pkg-debian] Re: We should not transition to
	apt.postgresql.org until we have a PPA
Message-ID: <20130216084421.GA1223@msgid.df7cb.de>
Mail-Followup-To: Christoph Berg <myon@debian.org>,
	Bruce Momjian <bruce@momjian.us>,
	Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>,
	Josh Berkus <josh@agliodbs.com>, Martin Pitt <mpitt@debian.org>,
	Magnus Hagander <magnus@hagander.net>,
	PostgreSQL WWW <pgsql-www@postgresql.org>,
	PostgreSQL in Debian <pgsql-pkg-debian@postgresql.org>,
	Tom Lane <tgl@sss.pgh.pa.us>
References: <20130214122643.GF30046@msgid.df7cb.de>
	<511D2E58.6010705@agliodbs.com> <511D4E61.5050808@kaltenbrunner.cc>
	<20130216013854.GD12029@momjian.us>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha256;
	protocol="application/pgp-signature"; boundary="gKMricLos+KVdGMg"
Content-Disposition: inline
In-Reply-To: <20130216013854.GD12029@momjian.us>
User-Agent: Mutt/1.5.21 (2010-09-15)
Precedence: bulk
Sender: pgsql-www-owner@postgresql.org


--gKMricLos+KVdGMg
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

Re: Bruce Momjian 2013-02-16 <20130216013854.GD12029@momjian.us>
> I don't think "codename" is really good wording here:

That's the official Debian/Ubuntu term, though we can certainly use
something else if it makes things easier for users.

> 	Edit the file /etc/apt/sources.list.d/pgdg.list, and add a line for the
> 	repository, substituting the proper "codename" for your release deb
>=20
> 		http://apt.postgresql.org/pub/repos/apt/ precise-pgdg main
>=20
> Shouldn't we highlight where that name goes?  I am running Squeeze and
> though I know "precise" is a code-name, I found out only by accident.  I
> particularly think users will not recognize codenames of Debian release
> newer than their own.  I suggest this wording:
>=20
> 	Edit the file /etc/apt/sources.list.d/pgdg.list, and add a line for the
> 	repository, substituting the proper Debian release name:
>=20
> 		http://apt.postgresql.org/pub/repos/apt/ <i>release-name</i>-pgdg main

The instructions on the wiki page make this more clear:

 Edit /etc/apt/sources.list.d/pgdg.list. The distributions are called
 codename-pgdg. In the example, replace squeeze with the actual
 distribution you are using:

 deb http://apt.postgresql.org/pub/repos/apt/ squeeze-pgdg main

and "squeeze" is in italics there. I'll look into merging the texts to
a common version.

> as in:
>=20
> 	sudo cat > /etc/apt/preferences.d/pgdg.pref <<END
> 	Package: *
> 	Pin: release o=3Dapt.postgresql.org
> 	Pin-Priority: 500=20
> 	END

"Write this to disk as root" is suprisingly hard in shell. Your
example misses quoting, the best variant I know is

	sudo tee -a /etc/apt/preferences.d/pgdg.pref <<END

which isn't very nice to look at either (and prints back stuff on
stdout).

I'm starting to think that the best version would be to have people
wget a shell script and execute that, but that's 100% evil from a
security perspective. (We will include such a script in the
postgresql-common package so if you have a recent enough install from
your vendor, you can use that, but this will not make it into
Debian/Ubuntu until the second-next releases.)

> Folks, we shouldn't be requiring decoder rings here to install Postgres
> --- we have to do better.

I don't get this, Do you mean the pgdg-keyring package?

Christoph
--=20
cb@df7cb.de | http://www.df7cb.de/

--gKMricLos+KVdGMg
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature

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

iQIcBAEBCAAGBQJRH0biAAoJEExaa6sS0qeuK6UQAKWU55kuufbEkYABHm/VuYRS
fhiwEHaa0FEmJT0rms4e1KT2mRdSJVagvABOxs/rSCcodH7b1VYbgEQWG8cHvMqV
F5A2weZI/+56mkFmwL9P3csXJTn25d2n/51H75lqIl1mDav+pSQHoC6m/5TTGimJ
gVyDezH3LpB+8cdhSPmtgsWYPOulSaLJl3PBJGljQGefSa+jMSR0dz5wImguQFLz
ddVuBvee5SQnmkcKHwiTH0T7zPw28x6QtakJY19pqBEGQKSjR0PiqzTdEllvfJLt
y/ezgGk8XU96sObGityeTuSHO1uh1F8CAfOqook1ri0f4ozrGYP+iVxPng7+j1ac
EsAvjd64Zgb/I3kfn8eiWNG7i6PCGOahH1W5qdHFrOGlF0IX1GtKxMfbRDmiT7by
qFS4s4lSLNUKt2/3r/yIDp0BLZkKfcjccyjqW4aLAboFVbw7ZQswCqnvaQiW/M6k
kR7zm1NlDdAUM3SjTLpJmefA8/1w+xYhKJHFdoLclvPW6ticv8FGyhig1ftweenr
/zIECM9RD8qr0BCr+U4gLd2UJ3O6ThDXaxaysYthUKpj9XReKM8GJ8YQDVa8ZF2W
EnxHXyPaIQasT30aOBJLZbC5YqPVhttLJToHpAegRPmhz/S8t2hcrcoS0pj253jm
GwGJrxvXTkMz5FTeYFaT
=7uuG
-----END PGP SIGNATURE-----

--gKMricLos+KVdGMg--