https://wiki.postgresql.org/api.php?action=feedcontributions&user=Rmichael&feedformat=atomPostgreSQL wiki - User contributions [en]2024-03-28T11:40:47ZUser contributionsMediaWiki 1.35.13https://wiki.postgresql.org/index.php?title=Apt&diff=19074Apt2013-02-21T22:49:00Z<p>Rmichael: /* Quickstart */</p>
<hr />
<div>==PostgreSQL packages for Debian and Ubuntu==<br />
<br />
The PostgreSQL Global Development Group (PGDG) maintains an APT repository of PostgreSQL packages for Debian and Ubuntu located at http://apt.postgresql.org/pub/repos/apt/.<br />
We aim at building PostgreSQL server packages as well as extensions and modules packages on several Debian/Ubuntu releases for all PostgreSQL versions supported.<br />
<br />
Currently, we support<br />
<br />
* Debian 6.0 (squeeze), 7.0 (wheezy), and unstable (sid) 64/32 bit (amd64/i386)<br />
* Ubuntu 10.4 (lucid) and 12.4 (precise) 64/32 bit (amd64/i386)<br />
* PostgreSQL 8.3, 8.4, 9.0, 9.1, 9.2<br />
* Several server extensions such as Slony-I, various PL languages, and datatypes<br />
* Applications like pgadmin3, pgbouncer, and pgpool-II<br />
<br />
Packages for older PostgreSQL versions and older Debian distributions will continue to stay in the repository; updates for those will be provided on an ad-hoc basis.<br />
<br />
'''Note:''' This repository was previously available at the old location pgapt.debian.net. Please update your sources.list ASAP to use the location mentioned below - you do not need to reinstall anything, the packages and the keyring used are the same. The old location will stop working at the end of January 2013.<br />
<br />
==Quickstart==<br />
<br />
Import the repository key from '''http://apt.postgresql.org/pub/repos/apt/ACCC4CF8.asc''':<br />
<br />
<nowiki>wget --quiet -O - http://apt.postgresql.org/pub/repos/apt/ACCC4CF8.asc | sudo apt-key add -</nowiki><br />
<br />
Create '''/etc/apt/sources.list.d/pgdg.list'''. The distributions are called ''codename'''''-pgdg'''. You may determine the codename by examining the '''/etc/lsb-release''' file:<br />
<br />
<nowiki>grep CODENAME /etc/lsb-release</nowiki><br />
<br />
In the example, replace ''squeeze'' with the actual distribution you are using:<br />
<br />
<nowiki>deb http://apt.postgresql.org/pub/repos/apt/</nowiki> ''squeeze''-pgdg main<br />
<br />
Configure apt's package pinning to prefer the PGDG packages over the Debian ones in '''/etc/apt/preferences.d/pgdg.pref''':<br />
<br />
Package: *<br />
Pin: release o=apt.postgresql.org<br />
Pin-Priority: 500<br />
<br />
Update the package lists, and start installing packages:<br />
<br />
sudo apt-get update<br />
sudo apt-get install postgresql pgadmin3<br />
<br />
Have a look at the '''[[Apt/FAQ|FAQ]]'''.<br />
<br />
''Note: this will replace all your Debian/Ubuntu PostgreSQL packages with packages from the PGDG repository. If you do not want this, you need to configure [[Apt/FAQ#I_want_only_specific_packages_from_this_repository|Apt pinning]].''<br />
<br />
==News==<br />
<br />
* 2012-12-18: Ubuntu Lucid (10.4) is now part of the repository; PostgreSQL and pgadmin3 packages are built.<br />
* 2012-12-06: Official announcement: http://archives.postgresql.org/pgsql-announce/2012-12/msg00008.php, http://www.postgresql.org/about/news/1432/<br />
* 2012-12-06: Minor releases 9.2.2, 9.1.7, 9.0.11, 8.4.15, 8.3.22 built.<br />
* 2012-11-30: pgadmin3 added to the repository<br />
* 2012-11-22: Ubuntu Precise (12.4) added to the repository, and built 9.2.1, 9.1.6, 9.0.10, 8.4.14, 8.3.21 for it.<br />
* 2012-10-13: Repository key renewed with new expiry date.<br />
* 2012-10-02: Minor releases 9.2.1, 9.1.6, 9.0.10, 8.4.14, 8.3.21 built<br />
* 2012-09-15: 9.2.0 is in the repository<br />
* 2012-08-22: PostgreSQL in Debian Hackathon: [http://www.df7cb.de/blog/2012/PostgreSQL_in_Debian_Hackathon.html Blog posting] and [https://github.com/dimitri/apt.postgresql.org/blob/master/hackaton-20120821.md notes]. The distribution names changed from *-pgapt to *-pgdg, please update your sources.list.<br />
* 2012-06-07: 9.2 added, Lenny marked unsupported now<br />
* 2012-06-07: separate components "9.0", "9.2" etc added for libpq5/libpg-dev/lib... packages that would otherwise overwrite packages from other versions in the same suite. (Usually, using the latest stable libpq5 version will be ok for users. The packages built from other PostgreSQL versions are provided only for completeness.)<br />
<br />
==Resources==<br />
<br />
* [[Apt/FAQ|FAQ]]<br />
* [http://pgapt.debian.net/bin/packages.cgi Overview of available packages and versions]<br />
* [http://apt.postgresql.org/pub/repos/apt/dists/ Dists directory]<br />
* [http://apt.postgresql.org/pub/repos/apt/pool/ Packages pool directory]<br />
* [[ExtensionPackaging]] (PostgreSQL Wiki)<br />
* [http://wiki.debian.org/pkg-postgresql pkg-postgresql] (Debian Wiki) <br />
<br />
===Contact===<br />
<br />
* Mailing list: pgsql-pkg-debian@postgresql.org ([http://archives.postgresql.org/pgsql-pkg-debian/ Archives])<br />
* IRC channel: #postgresql-apt @ irc.freenode.net<br />
* People: Christoph Berg <myon@debian.org>, Dimitri Fontaine <dimitri@2ndquadrant.fr>, Magnus Hagander <magnus@hagander.net><br />
<br />
===Bugs===<br />
<br />
Please report bugs on the pgsql-pkg-debian@postgresql.org mailing list, or open a bug in the [http://bugs.debian.org/ Debian BTS].<br />
<br />
===Documentation===<br />
<br />
* [[Apt/Jenkins]]<br />
* [[Apt/NewPostgreSQLVersion]]<br />
<br />
==Acknowledgements==<br />
<br />
Work on setting up the archive was kindly supported by [http://www.credativ.de/ credativ], [http://www.2ndquadrant.com/ 2ndQuadrant], [http://redpill-linpro.com/ Redpill Linpro],<br />
and funding from the European Union's Seventh Framework Programme (FP7/2007-2013) under grant agreement 258862.<br />
<br />
The build server is kindly hosted by [https://www.dg-i.net/ DG-i]. The archive is hosted on postgresql.org hardware.</div>Rmichaelhttps://wiki.postgresql.org/index.php?title=Apt&diff=19073Apt2013-02-21T22:17:13Z<p>Rmichael: Add help for determining the release's "codename".</p>
<hr />
<div>==PostgreSQL packages for Debian and Ubuntu==<br />
<br />
The PostgreSQL Global Development Group (PGDG) maintains an APT repository of PostgreSQL packages for Debian and Ubuntu located at http://apt.postgresql.org/pub/repos/apt/.<br />
We aim at building PostgreSQL server packages as well as extensions and modules packages on several Debian/Ubuntu releases for all PostgreSQL versions supported.<br />
<br />
Currently, we support<br />
<br />
* Debian 6.0 (squeeze), 7.0 (wheezy), and unstable (sid) 64/32 bit (amd64/i386)<br />
* Ubuntu 10.4 (lucid) and 12.4 (precise) 64/32 bit (amd64/i386)<br />
* PostgreSQL 8.3, 8.4, 9.0, 9.1, 9.2<br />
* Several server extensions such as Slony-I, various PL languages, and datatypes<br />
* Applications like pgadmin3, pgbouncer, and pgpool-II<br />
<br />
Packages for older PostgreSQL versions and older Debian distributions will continue to stay in the repository; updates for those will be provided on an ad-hoc basis.<br />
<br />
'''Note:''' This repository was previously available at the old location pgapt.debian.net. Please update your sources.list ASAP to use the location mentioned below - you do not need to reinstall anything, the packages and the keyring used are the same. The old location will stop working at the end of January 2013.<br />
<br />
==Quickstart==<br />
<br />
Import the repository key from '''http://apt.postgresql.org/pub/repos/apt/ACCC4CF8.asc''':<br />
<br />
<nowiki>wget --quiet -O - http://apt.postgresql.org/pub/repos/apt/ACCC4CF8.asc | sudo apt-key add -</nowiki><br />
<br />
Create '''/etc/apt/sources.list.d/pgdg.list'''. The distributions are called ''codename'''''-pgdg'''. You may determine the codename by examining the '''/etc/lsb-release''' file:<br />
<br />
<nowiki>grep CODENAME /etc/lsb-release<br />
<br />
In the example, replace ''squeeze'' with the actual distribution you are using:<br />
<br />
<nowiki>deb http://apt.postgresql.org/pub/repos/apt/</nowiki> ''squeeze''-pgdg main<br />
<br />
Configure apt's package pinning to prefer the PGDG packages over the Debian ones in '''/etc/apt/preferences.d/pgdg.pref''':<br />
<br />
Package: *<br />
Pin: release o=apt.postgresql.org<br />
Pin-Priority: 500<br />
<br />
Update the package lists, and start installing packages:<br />
<br />
sudo apt-get update<br />
sudo apt-get install postgresql pgadmin3<br />
<br />
Have a look at the '''[[Apt/FAQ|FAQ]]'''.<br />
<br />
''Note: this will replace all your Debian/Ubuntu PostgreSQL packages with packages from the PGDG repository. If you do not want this, you need to configure [[Apt/FAQ#I_want_only_specific_packages_from_this_repository|Apt pinning]].''<br />
<br />
==News==<br />
<br />
* 2012-12-18: Ubuntu Lucid (10.4) is now part of the repository; PostgreSQL and pgadmin3 packages are built.<br />
* 2012-12-06: Official announcement: http://archives.postgresql.org/pgsql-announce/2012-12/msg00008.php, http://www.postgresql.org/about/news/1432/<br />
* 2012-12-06: Minor releases 9.2.2, 9.1.7, 9.0.11, 8.4.15, 8.3.22 built.<br />
* 2012-11-30: pgadmin3 added to the repository<br />
* 2012-11-22: Ubuntu Precise (12.4) added to the repository, and built 9.2.1, 9.1.6, 9.0.10, 8.4.14, 8.3.21 for it.<br />
* 2012-10-13: Repository key renewed with new expiry date.<br />
* 2012-10-02: Minor releases 9.2.1, 9.1.6, 9.0.10, 8.4.14, 8.3.21 built<br />
* 2012-09-15: 9.2.0 is in the repository<br />
* 2012-08-22: PostgreSQL in Debian Hackathon: [http://www.df7cb.de/blog/2012/PostgreSQL_in_Debian_Hackathon.html Blog posting] and [https://github.com/dimitri/apt.postgresql.org/blob/master/hackaton-20120821.md notes]. The distribution names changed from *-pgapt to *-pgdg, please update your sources.list.<br />
* 2012-06-07: 9.2 added, Lenny marked unsupported now<br />
* 2012-06-07: separate components "9.0", "9.2" etc added for libpq5/libpg-dev/lib... packages that would otherwise overwrite packages from other versions in the same suite. (Usually, using the latest stable libpq5 version will be ok for users. The packages built from other PostgreSQL versions are provided only for completeness.)<br />
<br />
==Resources==<br />
<br />
* [[Apt/FAQ|FAQ]]<br />
* [http://pgapt.debian.net/bin/packages.cgi Overview of available packages and versions]<br />
* [http://apt.postgresql.org/pub/repos/apt/dists/ Dists directory]<br />
* [http://apt.postgresql.org/pub/repos/apt/pool/ Packages pool directory]<br />
* [[ExtensionPackaging]] (PostgreSQL Wiki)<br />
* [http://wiki.debian.org/pkg-postgresql pkg-postgresql] (Debian Wiki) <br />
<br />
===Contact===<br />
<br />
* Mailing list: pgsql-pkg-debian@postgresql.org ([http://archives.postgresql.org/pgsql-pkg-debian/ Archives])<br />
* IRC channel: #postgresql-apt @ irc.freenode.net<br />
* People: Christoph Berg <myon@debian.org>, Dimitri Fontaine <dimitri@2ndquadrant.fr>, Magnus Hagander <magnus@hagander.net><br />
<br />
===Bugs===<br />
<br />
Please report bugs on the pgsql-pkg-debian@postgresql.org mailing list, or open a bug in the [http://bugs.debian.org/ Debian BTS].<br />
<br />
===Documentation===<br />
<br />
* [[Apt/Jenkins]]<br />
* [[Apt/NewPostgreSQLVersion]]<br />
<br />
==Acknowledgements==<br />
<br />
Work on setting up the archive was kindly supported by [http://www.credativ.de/ credativ], [http://www.2ndquadrant.com/ 2ndQuadrant], [http://redpill-linpro.com/ Redpill Linpro],<br />
and funding from the European Union's Seventh Framework Programme (FP7/2007-2013) under grant agreement 258862.<br />
<br />
The build server is kindly hosted by [https://www.dg-i.net/ DG-i]. The archive is hosted on postgresql.org hardware.</div>Rmichaelhttps://wiki.postgresql.org/index.php?title=Apt&diff=19072Apt2013-02-21T22:12:46Z<p>Rmichael: Add --quiet to wget to avoid hiding the sudo password prompt, possibly confusing inexperienced users who cut-and-paste.</p>
<hr />
<div>==PostgreSQL packages for Debian and Ubuntu==<br />
<br />
The PostgreSQL Global Development Group (PGDG) maintains an APT repository of PostgreSQL packages for Debian and Ubuntu located at http://apt.postgresql.org/pub/repos/apt/.<br />
We aim at building PostgreSQL server packages as well as extensions and modules packages on several Debian/Ubuntu releases for all PostgreSQL versions supported.<br />
<br />
Currently, we support<br />
<br />
* Debian 6.0 (squeeze), 7.0 (wheezy), and unstable (sid) 64/32 bit (amd64/i386)<br />
* Ubuntu 10.4 (lucid) and 12.4 (precise) 64/32 bit (amd64/i386)<br />
* PostgreSQL 8.3, 8.4, 9.0, 9.1, 9.2<br />
* Several server extensions such as Slony-I, various PL languages, and datatypes<br />
* Applications like pgadmin3, pgbouncer, and pgpool-II<br />
<br />
Packages for older PostgreSQL versions and older Debian distributions will continue to stay in the repository; updates for those will be provided on an ad-hoc basis.<br />
<br />
'''Note:''' This repository was previously available at the old location pgapt.debian.net. Please update your sources.list ASAP to use the location mentioned below - you do not need to reinstall anything, the packages and the keyring used are the same. The old location will stop working at the end of January 2013.<br />
<br />
==Quickstart==<br />
<br />
Import the repository key from '''http://apt.postgresql.org/pub/repos/apt/ACCC4CF8.asc''':<br />
<br />
<nowiki>wget --quiet -O - http://apt.postgresql.org/pub/repos/apt/ACCC4CF8.asc | sudo apt-key add -</nowiki><br />
<br />
Create '''/etc/apt/sources.list.d/pgdg.list'''. The distributions are called ''codename'''''-pgdg'''.<br />
In the example, replace ''squeeze'' with the actual distribution you are using:<br />
<br />
<nowiki>deb http://apt.postgresql.org/pub/repos/apt/</nowiki> ''squeeze''-pgdg main<br />
<br />
Configure apt's package pinning to prefer the PGDG packages over the Debian ones in '''/etc/apt/preferences.d/pgdg.pref''':<br />
<br />
Package: *<br />
Pin: release o=apt.postgresql.org<br />
Pin-Priority: 500<br />
<br />
Update the package lists, and start installing packages:<br />
<br />
sudo apt-get update<br />
sudo apt-get install postgresql pgadmin3<br />
<br />
Have a look at the '''[[Apt/FAQ|FAQ]]'''.<br />
<br />
''Note: this will replace all your Debian/Ubuntu PostgreSQL packages with packages from the PGDG repository. If you do not want this, you need to configure [[Apt/FAQ#I_want_only_specific_packages_from_this_repository|Apt pinning]].''<br />
<br />
==News==<br />
<br />
* 2012-12-18: Ubuntu Lucid (10.4) is now part of the repository; PostgreSQL and pgadmin3 packages are built.<br />
* 2012-12-06: Official announcement: http://archives.postgresql.org/pgsql-announce/2012-12/msg00008.php, http://www.postgresql.org/about/news/1432/<br />
* 2012-12-06: Minor releases 9.2.2, 9.1.7, 9.0.11, 8.4.15, 8.3.22 built.<br />
* 2012-11-30: pgadmin3 added to the repository<br />
* 2012-11-22: Ubuntu Precise (12.4) added to the repository, and built 9.2.1, 9.1.6, 9.0.10, 8.4.14, 8.3.21 for it.<br />
* 2012-10-13: Repository key renewed with new expiry date.<br />
* 2012-10-02: Minor releases 9.2.1, 9.1.6, 9.0.10, 8.4.14, 8.3.21 built<br />
* 2012-09-15: 9.2.0 is in the repository<br />
* 2012-08-22: PostgreSQL in Debian Hackathon: [http://www.df7cb.de/blog/2012/PostgreSQL_in_Debian_Hackathon.html Blog posting] and [https://github.com/dimitri/apt.postgresql.org/blob/master/hackaton-20120821.md notes]. The distribution names changed from *-pgapt to *-pgdg, please update your sources.list.<br />
* 2012-06-07: 9.2 added, Lenny marked unsupported now<br />
* 2012-06-07: separate components "9.0", "9.2" etc added for libpq5/libpg-dev/lib... packages that would otherwise overwrite packages from other versions in the same suite. (Usually, using the latest stable libpq5 version will be ok for users. The packages built from other PostgreSQL versions are provided only for completeness.)<br />
<br />
==Resources==<br />
<br />
* [[Apt/FAQ|FAQ]]<br />
* [http://pgapt.debian.net/bin/packages.cgi Overview of available packages and versions]<br />
* [http://apt.postgresql.org/pub/repos/apt/dists/ Dists directory]<br />
* [http://apt.postgresql.org/pub/repos/apt/pool/ Packages pool directory]<br />
* [[ExtensionPackaging]] (PostgreSQL Wiki)<br />
* [http://wiki.debian.org/pkg-postgresql pkg-postgresql] (Debian Wiki) <br />
<br />
===Contact===<br />
<br />
* Mailing list: pgsql-pkg-debian@postgresql.org ([http://archives.postgresql.org/pgsql-pkg-debian/ Archives])<br />
* IRC channel: #postgresql-apt @ irc.freenode.net<br />
* People: Christoph Berg <myon@debian.org>, Dimitri Fontaine <dimitri@2ndquadrant.fr>, Magnus Hagander <magnus@hagander.net><br />
<br />
===Bugs===<br />
<br />
Please report bugs on the pgsql-pkg-debian@postgresql.org mailing list, or open a bug in the [http://bugs.debian.org/ Debian BTS].<br />
<br />
===Documentation===<br />
<br />
* [[Apt/Jenkins]]<br />
* [[Apt/NewPostgreSQLVersion]]<br />
<br />
==Acknowledgements==<br />
<br />
Work on setting up the archive was kindly supported by [http://www.credativ.de/ credativ], [http://www.2ndquadrant.com/ 2ndQuadrant], [http://redpill-linpro.com/ Redpill Linpro],<br />
and funding from the European Union's Seventh Framework Programme (FP7/2007-2013) under grant agreement 258862.<br />
<br />
The build server is kindly hosted by [https://www.dg-i.net/ DG-i]. The archive is hosted on postgresql.org hardware.</div>Rmichael