Thread: Debian/Ubuntu repository changes
Dear Debian/Ubuntu users,
It is our goal to make things as solid and simple as possible, and
time has come to address the second part of that goal. We have some
service announcements concerning the Apt repositories for
Debian/Ubuntu PostgreSQL packages:
== Changes in the Apt pinning priority on apt.postgresql.org ==
If you add the repository, packages get automatically upgraded to the
PGDG packages from now on.
In the past, the installation instructions asked you to create an apt
preferences file ("pinning") to do that, as that's what most users
want. This is now unnecessary, instead you need to configure pinning
if you *don't* want to automatically use PGDG packages. See [pin] for
instructions. If you followed the installation instructions and have
an /etc/apt/preferences.d/pgdg.pref file, nothing will change for you;
this file is now redundant and harmless.
== pgapt.debian.net is gone ==
Before apt.postgresql.org was set up, we had a repository located on
pgapt.debian.net. So far, this repository was kept in sync with
apt.postgresql.org. We will shut down this old repository now. Because
the packages in the repositories are the same, you do not need to
install/upgrade anything to switch, except for configuring the new
archive location.
If you are still using pgapt.debian.net, please follow the normal
installation instructions at [apt] to switch.
== Ubuntu PPA is being deprecated ==
This Ubuntu private package archive was providing "Newer PostgreSQL
major versions, backported to supported Ubuntu releases"
The functionality of this has been integrated in apt.postgresql.org.
Martin Pitt, the PostgreSQL debian and ubuntu packaging maintainer,
has been working on the ubuntu PPA and has been part of the
apt.postgresql.org team from the first day. The new repository has a
lot more packages, and also better QA. This PPA will still be kept for
Ubuntu 10.04's and 11.10's life time, but will not receive packages
for Ubuntu releases later than 12.04 LTS.
In about a year (during Ubuntu 12.04 LTS's life time) this PPA is
going to be shut down. Please consider moving to apt.postgresql.org
soon; its packages are compatible so switching will not be a problem.
Please see [apt] for instructions.
[pin] https://wiki.postgresql.org/wiki/Apt/FAQ#I_want_only_specific_packages_from_this_repository
[apt] https://wiki.postgresql.org/wiki/Apt
Attachment
Hi Fabien, Re: Fabien COELHO 2013-02-22 <alpine.DEB.2.02.1302221448220.26800@localhost6.localdomain6> > As far as I can see this is *not* currently the case : ISTM that > "apt.postgresql.org" only proposes packages for LTS releases, while > the PPA supports intermediate non-LTS ubuntu releases. > > From http://apt.postgresql.org/pub/repos/apt/dists/: > > etch-pgdg/ 2012-Nov-27 10:27:27 - Directory > lenny-pgdg/ 2012-Dec-19 13:24:50 - Directory > lucid-pgdg/ 2013-Feb-13 16:19:58 - Directory > precise-pgdg/ 2013-Feb-16 08:10:40 - Directory > sid-pgdg/ 2013-Feb-16 08:10:38 - Directory > squeeze-pgdg/ 2013-Feb-16 08:10:39 - Directory > wheezy-pgdg/ 2013-Feb-16 08:10:39 - Directory > > In particular, there is no "quantal" that I'm currently using:-( > > Although from https://launchpad.net/~pitti/+archive/postgresql > > postgresql-9.2 9.2.3-0ppa1~quantal Martin Pitt (2013-02-08) > > ISTM that if you do not support non-LTS releases, this is a > significant regression. Or did I miss something? 12.10 was not mentioned in the announcement, the intended meaning was to say "this PPA will be shut down with the EOL of quantal/12.10". This means you can keep using the PPA with quantal. We will update the documentation to mention that non-LTS Ubuntu users should instead pick the next-oldest LTS release instead. The packages will still work there. (If something in the dependencies changes, we will add the relevant packages/distributions to fix the situation.) Christoph -- cb@df7cb.de | http://www.df7cb.de/
Attachment
Kudos guys !!
On 22/02/2013 11:32, Christoph Berg wrote:
> Dear Debian/Ubuntu users,
>
> It is our goal to make things as solid and simple as possible, and
> time has come to address the second part of that goal. We have
> some service announcements concerning the Apt repositories for
> Debian/Ubuntu PostgreSQL packages:
>
> == Changes in the Apt pinning priority on apt.postgresql.org ==
>
> If you add the repository, packages get automatically upgraded to
> the PGDG packages from now on.
>
> In the past, the installation instructions asked you to create an
> apt preferences file ("pinning") to do that, as that's what most
> users want. This is now unnecessary, instead you need to configure
> pinning if you *don't* want to automatically use PGDG packages. See
> [pin] for instructions. If you followed the installation
> instructions and have an /etc/apt/preferences.d/pgdg.pref file,
> nothing will change for you; this file is now redundant and
> harmless.
>
> == pgapt.debian.net is gone ==
>
> Before apt.postgresql.org was set up, we had a repository located
> on pgapt.debian.net. So far, this repository was kept in sync with
> apt.postgresql.org. We will shut down this old repository now.
> Because the packages in the repositories are the same, you do not
> need to install/upgrade anything to switch, except for configuring
> the new archive location.
>
> If you are still using pgapt.debian.net, please follow the normal
> installation instructions at [apt] to switch.
>
> == Ubuntu PPA is being deprecated ==
>
> This Ubuntu private package archive was providing "Newer
> PostgreSQL major versions, backported to supported Ubuntu
> releases"
>
> The functionality of this has been integrated in
> apt.postgresql.org. Martin Pitt, the PostgreSQL debian and ubuntu
> packaging maintainer, has been working on the ubuntu PPA and has
> been part of the apt.postgresql.org team from the first day. The
> new repository has a lot more packages, and also better QA. This
> PPA will still be kept for Ubuntu 10.04's and 11.10's life time,
> but will not receive packages for Ubuntu releases later than 12.04
> LTS.
>
> In about a year (during Ubuntu 12.04 LTS's life time) this PPA is
> going to be shut down. Please consider moving to
> apt.postgresql.org soon; its packages are compatible so switching
> will not be a problem. Please see [apt] for instructions.
>
> [pin]
> https://wiki.postgresql.org/wiki/Apt/FAQ#I_want_only_specific_packages_from_this_repository
>
>
[apt] https://wiki.postgresql.org/wiki/Apt
>
Dear Christoph, >> ISTM that if you do not support non-LTS releases, this is a >> significant regression. Or did I miss something? > > 12.10 was not mentioned in the announcement, the intended meaning was > to say "this PPA will be shut down with the EOL of quantal/12.10". > This means you can keep using the PPA with quantal. > > We will update the documentation to mention that non-LTS Ubuntu users > should instead pick the next-oldest LTS release instead. The packages > will still work there. (If something in the dependencies changes, we > will add the relevant packages/distributions to fix the situation.) Ok, I understand that the LTS from "apt.postgresql.org" is expected to work on following releases, or there will be additionnal packages. ISTM that Canonical has announced that they are going to change their release policy so that there would be only LTS and continuous updates in between... So you're just ahead of time. Thanks for your answer, have a nice day. -- Fabien.
Re: Joe Abbate 2013-02-22 <5127C420.3020206@freedomcircle.com>
> Sorry to bother you directly, but I decided to follow your
> recommendation to use the PGDG packages and now I see a difference in
> behavior. Before I used to have PG 8.4, 9.0, 9.1 and 9.2 running in
> ports 5432 through 5435 respectively and when I typed 'psql somedb'
> I'd get the 8.4 version. Now, I get the 9.2 version but connected to
> the 8.4 server and the customary warning. Even if I use 'psql
> --cluster 8.4/main somedb' I still get the 9.2 front-end, and the same
> applies to 9.0 and 9.1. How do I get my front-end to be in synch with
> my back-end, again?
Hi Joe,
this was a recent change in postgresql-common that was suggested by
the PostgreSQL people which will also be part of the next
Debian/Ubuntu releases. The reasoning is that you get a newer psql
binary with new features, but this is still compatible with the old
server. The warning there is a bit overzealous, it is aiming at
something like the following:
$ psql -p 5484
psql (9.2.3, server 8.4.15)
WARNING: psql version 9.2, server version 8.4.
Some psql features might not work.
Type "help" for help.
postgres =# \ddp
The server (version 8.4) does not support altering default privileges.
... while "\ddp" is still listed in the "\?" help output.
In practice, you shouldn't see any real problem with the 9.2 psql.
The "matching" psql is still available at
/usr/lib/postgresql/8.4/bin/psql.
Does that meet your needs?
Christoph
--
cb@df7cb.de | http://www.df7cb.de/
Hello Christoph, On 23/02/13 03:04, Christoph Berg wrote: > Does that meet your needs? It wasn't clear from your reply whether this change applies only to psql but apparently it does, i.e., when I do pg_dump --version it shows 8.4.16, but psql --version show 9.2.3. Fortunately this inconsistency won't affect me, but maybe it could affect others. I use pg_dump for the functional tests of Pyrseas and run them against 8.4, 9.0, 9.1 and 9.2, but the running of SQL commands is done via Python/psycopg2, not through psql. Regards, Joe
Re: Joe Abbate 2013-02-23 <5128E214.8090803@freedomcircle.com> > On 23/02/13 03:04, Christoph Berg wrote: > > Does that meet your needs? > > It wasn't clear from your reply whether this change applies only to psql > but apparently it does, i.e., when I do pg_dump --version it shows > 8.4.16, but psql --version show 9.2.3. Only psql. The other tools are still wrapped to the matching version by pg_wrapper. Christoph -- cb@df7cb.de | http://www.df7cb.de/