Use of PostgreSQL in the Debian Project - PostgreSQL wiki

manlybluegooseData Management

Nov 27, 2012 (4 years and 6 months ago)

232 views

Debian Services FTP Team QA Team New Maintainer Ctte wanna-build UDD BTS DSA Snapshot
Use of PostgreSQL in the
Debian Project
Peter Palfrader
FrOSCon 2009
St.Augustin,Germany
Debian Services FTP Team QA Team New Maintainer Ctte wanna-build UDD BTS DSA Snapshot
Debian Services/Teams
FTP Team
QA
NM
wanna-build
UDD
bugs.debian.org
DSA
snapshot
Debian Services FTP Team QA Team New Maintainer Ctte wanna-build UDD BTS DSA Snapshot
FTP Team
services:fftp,security,volatileg-master.d.o
in Pg:
packages overrides
sources,binaries,binary - source mapping
uploader
suites
not in the DB yet:other metadata that goes
into Packages,Sources and Contents les
mirrored daily to Debian-Developer accessible
host
Debian Services FTP Team QA Team New Maintainer Ctte wanna-build UDD BTS DSA Snapshot
QA Team
Populates their own database from ftp mirrors
remote apt-cache/rmadison
http://qa.debian.org/cgi-bin/dcontrol
DDPO (in development)
http://qa.debian.org/cgi-bin/ddpo?login=weasel
Debian Services FTP Team QA Team New Maintainer Ctte wanna-build UDD BTS DSA Snapshot
New Maintainer Ctte
gpg-coord service
nm.d.o Application Manager,applicant,
progress Tracking
Debian Services FTP Team QA Team New Maintainer Ctte wanna-build UDD BTS DSA Snapshot
wanna-build
transition tracking (for release team)
https://buildd.debian.org/transitions/summary.html
in the future:build-status
Debian Services FTP Team QA Team New Maintainer Ctte wanna-build UDD BTS DSA Snapshot
Ultimate Debian Database
gathers a lot of data about various aspects of
Debian
It allows users to easily access and combine all
this data.
http://udd.debian.org/
Debian Services FTP Team QA Team New Maintainer Ctte wanna-build UDD BTS DSA Snapshot
bugs.debian.org
not for bugs - they are stored in the lesystem
Bayes Database for SpamAssassin is in Pg:)
Debian Services FTP Team QA Team New Maintainer Ctte wanna-build UDD BTS DSA Snapshot
DSA
request tracker - normal RT instance
Debian Services FTP Team QA Team New Maintainer Ctte wanna-build UDD BTS DSA Snapshot
snapshot.debian.org
Tries to keep a snapshot of all states of the ftp
archive ever
Files kept on the lesytem (content addressed)
metadata (lename,path,which archive,when
added/removed,etc.) is kept in a PostgreSQL
(still in development)