Updates for the apt.postgresql.org instructions

From: Christoph Berg <cb(at)df7cb(dot)de>
To: PostgreSQL WWW <pgsql-www(at)postgresql(dot)org>
Subject: Updates for the apt.postgresql.org instructions
Date: 2013-03-05 14:36:57
Message-ID: 20130305143657.GF11586@msgid.df7cb.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-pkg-debian pgsql-www

diff --git a/templates/pages/download/linux/debian.html b/templates/pages/download/linux/debian.html
index 96b75cf..cc064cb 100644
--- a/templates/pages/download/linux/debian.html
+++ b/templates/pages/download/linux/debian.html
@@ -41,6 +41,15 @@ version number as required):
<li>pgadmin3 - pgAdmin III graphical administration utility</li>
</ul>

+<script>
+ <!--
+ function updateSeries(select) {
+ var deb = document.getElementById('series-deb');
+ deb.innerHTML = select.value;
+ }
+ -->
+</script>
+
<h2>PostgreSQL Apt Repository</h2>
<p>
If the version included in your version of Debian is not the one you want,
@@ -52,24 +61,22 @@ updates for all supported versions of PostgreSQL throughout the support
<p>
To use the apt repository, follow these steps:
<ul>
- <li>Import the repository signing key
- <code>wget -O - http://apt.postgresql.org/pub/repos/apt/ACCC4CF8.asc | sudo apt-key add -</code>
- </li>
- <li>Edit the file <i>/etc/apt/sources.list.d/pgdg.list</i>, and add a line
- for the repository, substituting the proper "codename" for your release
- <code>deb http://apt.postgresql.org/pub/repos/apt/ squeeze-pgdg main</code>
- </li>
- <li>Configure apt's package pinning to prefer the PGDG packages over the standard ones in <i>/etc/apt/preferences.d/pgdg.pref</i>
- <code>
-Package: *<br/>
-Pin: release o=apt.postgresql.org<br/>
-Pin-Priority: 500
- </code>
+ <li>Create the file <i>/etc/apt/sources.list.d/pgdg.list</i>, and add a line
+ for the repository
+ <form style="display: inline">
+ <select id="field.series" name="field.series" onChange='updateSeries(this);'>
+ <option selected="selected" value="YOUR_DEBIAN_VERSION_HERE">Choose your Debian version</option>
+ <option value="wheezy">Wheezy (7.0)</option>
+ <option value="squeeze">Squeeze (6.0)</option>
+ </select>
+ </form>
+ <code>deb http://apt.postgresql.org/pub/repos/apt/ <span id="series-deb">YOUR_DEBIAN_VERSION_HERE</span>-pgdg main</code>
</li>
- <li>Update the package lists, and install the pgdg-keyring package to automatically get repository key updates
+ <li>Import the repository signing key, and update the package lists
<code>
-sudo apt-get update<br/>
-sudo apt-get install pgdg-keyring
+wget --quiet -O - http://apt.postgresql.org/pub/repos/apt/ACCC4CF8.asc | \<br/>
+&nbsp;&nbsp;sudo apt-key add -<br/>
+sudo apt-get update
</code>
</li>
</ul>
diff --git a/templates/pages/download/linux/ubuntu.html b/templates/pages/download/linux/ubuntu.html
index 664af81..a506d37 100644
--- a/templates/pages/download/linux/ubuntu.html
+++ b/templates/pages/download/linux/ubuntu.html
@@ -43,40 +43,42 @@ version number as required):
<li>pgadmin3 - pgAdmin III graphical administration utility</li>
</ul>

+<script>
+ <!--
+ function updateSeries(select) {
+ var deb = document.getElementById('series-deb');
+ deb.innerHTML = select.value;
+ }
+ -->
+</script>
+
<h2>PostgreSQL Apt Repository</h2>
<p>
-If the version included in your version of Debian is not the one you want,
+If the version included in your version of Ubuntu is not the one you want,
you can use the PostgreSQL Apt Repository. This repository will integrate
with your normal systems and patch management, and provide automatic
updates for all supported versions of PostgreSQL throughout the support
<a href="/support/versioning/">lifetime</a> of PostgreSQL.
</p>
<p>
-Not all Ubuntu releases are currently supported in the apt repository. For
-an up to date list of supported releases, please see the apt page on
-<a href="http://wiki.postgresql.org/wiki/Apt">the wiki</a>.
-</p>
-<p>
To use the apt repository, follow these steps:
<ul>
- <li>Import the repository signing key
- <code>wget -O - http://apt.postgresql.org/pub/repos/apt/ACCC4CF8.asc | sudo apt-key add -</code>
- </li>
- <li>Edit the file <i>/etc/apt/sources.list.d/pgdg.list</i>, and add a line
- for the repository, substituting the proper "codename" for your release
- <code>deb http://apt.postgresql.org/pub/repos/apt/ precise-pgdg main</code>
- </li>
- <li>Configure apt's package pinning to prefer the PGDG packages over the standard ones in <i>/etc/apt/preferences.d/pgdg.pref</i>
- <code>
-Package: *<br/>
-Pin: release o=apt.postgresql.org<br/>
-Pin-Priority: 500
- </code>
+ <li>Create the file <i>/etc/apt/sources.list.d/pgdg.list</i>, and add a line
+ for the repository
+ <form style="display: inline">
+ <select id="field.series" name="field.series" onChange='updateSeries(this);'>
+ <option selected="selected" value="YOUR_UBUNTU_VERSION_HERE">Choose your Ubuntu version</option>
+ <option value="precise">Precise (12.04)</option>
+ <option value="lucid">Lucid (10.04)</option>
+ </select>
+ </form>
+ <code>deb http://apt.postgresql.org/pub/repos/apt/ <span id="series-deb">YOUR_UBUNTU_VERSION_HERE</span>-pgdg main</code>
</li>
- <li>Update the package lists, and install the pgdg-keyring package to automatically get repository key updates
+ <li>Import the repository signing key, and update the package lists
<code>
-sudo apt-get update<br/>
-sudo apt-get install pgdg-keyring
+wget --quiet -O - http://apt.postgresql.org/pub/repos/apt/ACCC4CF8.asc | \<br/>
+&nbsp;&nbsp;sudo apt-key add -<br/>
+sudo apt-get update
</code>
</li>
</ul>

Christoph
--
cb(at)df7cb(dot)de | http://www.df7cb.de/

Responses

Browse pgsql-pkg-debian by date

  From Date Subject
Next Message Magnus Hagander 2013-03-05 16:02:02 Re: Updates for the apt.postgresql.org instructions
Previous Message Christoph Berg 2013-03-05 09:56:21 Re: [pgsql-www] We should not transition to apt.postgresql.org until we have a PPA

Browse pgsql-www by date

  From Date Subject
Next Message Christoph Berg 2013-03-05 14:41:28 Fixes for django 1.4
Previous Message Magnus Hagander 2013-03-05 14:13:54 Re: Ooops! Minor issue with email address mangling