Re: [pgsql-pkg-debian] Re: We should not transition to apt.postgresql.org until we have a PPA

Re: Bruce Momjian 2013-02-16 <20130216013854(dot)GD12029(at)momjian(dot)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
>
> http://apt.postgresql.org/pub/repos/apt/ precise-pgdg main
>
> 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:
>
> Edit the file /etc/apt/sources.list.d/pgdg.list, and add a line for the
> repository, substituting the proper Debian release name:
>
> 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:
>
> sudo cat > /etc/apt/preferences.d/pgdg.pref <<END
> Package: *
> Pin: release o=apt.postgresql.org
> Pin-Priority: 500
> 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
--
cb(at)df7cb(dot)de | http://www.df7cb.de/