Package Search Help

You can use boolean logic (e.g. AND/OR/NOT) for complex search queries. For more help and examples, see the search documentation.

Search by package name:
my-package (implicit)
name:my-package (explicit)

Search by package filename:
filename:my-package.ext 

Search by package tag:
tag:latest 

Search by package version:
version:1.0.0  prerelease:true (prereleases)
prerelease:false (no prereleases)

Search by package architecture:
architecture:x86_64 

Search by package distribution:
distribution:el 

Search by package license:
license:MIT 

Search by package format:
format:deb 

Search by package status:
status:in_progress 

Search by package file checksum:
checksum:5afba 

Search by package security status:
severity:critical 

Search by package vulnerabilities:
vulnerabilities:>1 
vulnerabilities:<1000 

Search by # of package downloads:
downloads:>8 
downloads:<100 

Search by package type:
type:binary 
type:source 

Search by package size (bytes):
size:>50000 
size:<10000 

Search by dependency name/version:
dependency:log4j 
dependency:log4j=1.0.0 
dependency:log4j>1.0.0 

Search by uploaded date:
uploaded:>"1 day ago" 
uploaded:<"August 14, 2022 EST" 

Search by entitlement token (identifier):
entitlement:3lKPVJPosCsY 

Search by policy violation:
policy_violated:true
deny_policy_violated:true
license_policy_violated:true
vulnerability_policy_violated:true

Search by repository:
repository:repo-name

Search by last download date:
last_downloaded:<"30 days ago" 
last_downloaded:>"August 14, 2022 EST" 

Search queries for all Debian-specific (and related) package types

Search by component:
deb_component:unstable

Search queries for all Maven-specific (and related) package types

Search by group ID:
maven_group_id:org.apache

Search queries for all Docker-specific (and related) package types

Search by image digest:
docker_image_digest:sha256:7c5..6d4
(full hashref only)

Search by layer digest:
docker_layer_digest:sha256:4c4..ae4
(full hashref only)

Field type modifiers (depending on the type, you can influence behaviour)

For all queries, you can use:
~foo for negation

For string queries, you can use:
^foo to anchor to start of term
foo$ to anchor to end of term
foo*bar for fuzzy matching

For number/date or version queries, you can use:
>foo for values greater than
>=foo for values greater / equal
<foo for values less than
<=foo for values less / equal

Need a secure and centralised artifact repository to deliver Alpine, Cargo, CocoaPods, Composer, Conan, Conda, CRAN, Dart, Debian, Docker, Go, Helm, Hex, HuggingFace, LuaRocks, Maven, npm, NuGet, P2, Python, RedHat, Ruby, Swift, Terraform, Vagrant, Raw & More packages?

Cloudsmith is the new standard in Package / Artifact Management and Software Distribution.

With support for all major package formats, you can trust us to manage your software supply chain.

Start My Free Trial
Set Me Up
 Open-Source — ultimaker ultimaker (Ultimaker) / debian-backup — Project
A certifiably-awesome open-source package repository curated by Ultimaker, hosted by Cloudsmith.
Note: Packages in this repository are licensed as GNU General Public License v3.0 or later (dependencies may be licensed differently).
Packages 87951 Package Groups 56001 Public Keys

Debian logo postgresql-11-debversion  1.1.1-2

Download

One-liner (summary)

Debian version number type for PostgreSQL

Description

Debian version numbers, used to version Debian binary and source packages, have a defined format, including specifications for how versions should be compared in order to sort them. This package implements a "debversion" type to represent Debian version numbers within the PostgreSQL database. This also includes operators for version comparison and index operator classes for creating indexes on the debversion type.

Version comparison uses the algorithm used by the Debian package manager, dpkg, using the implementation from libapt-pkg. This means that columns in tables using the debversion type may be sorted and compared correctly using the same logic as "dpkg --compare-versions". It is also possible to create indexes on these columns.

postgresql-debversion implements the following features:

* The "debversion" type (internally derived from the "text" type) * A full set of operators for version comparison (< <= = <> >= >) including commutator and negator optimisation hints * Operator classes for btree and hash indexes * The aggregate functions min() and max()

License

Unknown

Size

15.5 KB

Downloads

1

Tags

debian/buster deb arm64 main latest

Status  Completed
Checksum (MD5) 3123dba8990d544fed66f9ba51d137cd
Checksum (SHA-1) 3328268a2d39c25a308b048953015538b869ca3e
Checksum (SHA-256) f51660862520f816565b0b6b6485b18fa118f290a9b239ff33a26ed4329419c0
Checksum (SHA-512) ff961b31ca0c7113a3a8569364b45ab28f757a9286ac42c7e17572baf889a4ea4a…
GPG Signature
Download
GPG Fingerprint c0a114330029b468b1146f70c334efcb2c4f9be3
Distribution debian/buster - Debian - 10 (Buster)
Storage Region  Dublin, Ireland
Type  Binary (contains binaries and binary artifacts)
Uploaded At 9 months, 2 weeks ago
Uploaded By alex-borro
Slug Id postgresql-11-debversion_111-2_arm64deb-6xjz
Unique Id ZTh4trAAeVmm
Version (Raw) 1.1.1-2
Version (Parsed)
  • Major: 1
  • Minor: 1
  • Patch: 1
  • Pre (Str): (empty)
  • Pre (Num Array): 2
  • Type: SemVer (Strict)
  extended metadata
Installed Size 60.0 KB
Maintainer Debian PostgreSQL Maintainers <team+postgresql@tracker.debian.org>
Priority optional
Section database
Source postgresql-debversion
pkg postgresql-11-debversion_1.1.1-… 1
15.5 KB 		md5 sha1 sha256 sha512
Package Contents (postgresql-11-debversion_1.1.1-2_arm64.deb)
Loading...

This package has 28 files/directories.

Dependencies

3

Checksum (md5)

0164600a4e0688d15958ed7d6592b556

Depends
libapt-pkg5.0 >=0.8.0
Depends
libc6 >=2.17
Depends
postgresql-11
Loading...

You can embed a badge in another website that shows this or the latest version of this package.

To embed the badge for this specific package version, use the following: 

[![This version of 'postgresql-11-debversion' @ Cloudsmith](https://api.cloudsmith.com/v1/badges/version/ultimaker/debian-backup/deb/postgresql-11-debversion/1.1.1-2/a=arm64;xc=main;d=debian%252Fbuster;t=binary/?render=true)](https://cloudsmith.io/~ultimaker/repos/debian-backup/packages/detail/deb/postgresql-11-debversion/1.1.1-2/a=arm64;xc=main;d=debian%252Fbuster;t=binary/)
|This version of 'postgresql-11-debversion' @ Cloudsmith|
.. |This version of 'postgresql-11-debversion' @ Cloudsmith| image:: https://api.cloudsmith.com/v1/badges/version/ultimaker/debian-backup/deb/postgresql-11-debversion/1.1.1-2/a=arm64;xc=main;d=debian%252Fbuster;t=binary/?render=true
   :target: https://cloudsmith.io/~ultimaker/repos/debian-backup/packages/detail/deb/postgresql-11-debversion/1.1.1-2/a=arm64;xc=main;d=debian%252Fbuster;t=binary/
image::https://api.cloudsmith.com/v1/badges/version/ultimaker/debian-backup/deb/postgresql-11-debversion/1.1.1-2/a=arm64;xc=main;d=debian%252Fbuster;t=binary/?render=true[link="https://cloudsmith.io/~ultimaker/repos/debian-backup/packages/detail/deb/postgresql-11-debversion/1.1.1-2/a=arm64;xc=main;d=debian%252Fbuster;t=binary/",title="This version of 'postgresql-11-debversion' @ Cloudsmith"]
<a href="https://cloudsmith.io/~ultimaker/repos/debian-backup/packages/detail/deb/postgresql-11-debversion/1.1.1-2/a=arm64;xc=main;d=debian%252Fbuster;t=binary/"><img src="https://api.cloudsmith.com/v1/badges/version/ultimaker/debian-backup/deb/postgresql-11-debversion/1.1.1-2/a=arm64;xc=main;d=debian%252Fbuster;t=binary/?render=true" alt="This version of 'postgresql-11-debversion' @ Cloudsmith" /></a>

rendered as: This version of 'postgresql-11-debversion' @ Cloudsmith

To embed the badge for the latest package version, use the following: 

[![Latest version of 'postgresql-11-debversion' @ Cloudsmith](https://api.cloudsmith.com/v1/badges/version/ultimaker/debian-backup/deb/postgresql-11-debversion/latest/a=arm64;xc=main;d=debian%252Fbuster;t=binary/?render=true&show_latest=true)](https://cloudsmith.io/~ultimaker/repos/debian-backup/packages/detail/deb/postgresql-11-debversion/latest/a=arm64;xc=main;d=debian%252Fbuster;t=binary/)
|Latest version of 'postgresql-11-debversion' @ Cloudsmith|
.. |Latest version of 'postgresql-11-debversion' @ Cloudsmith| image:: https://api.cloudsmith.com/v1/badges/version/ultimaker/debian-backup/deb/postgresql-11-debversion/latest/a=arm64;xc=main;d=debian%252Fbuster;t=binary/?render=true&show_latest=true
   :target: https://cloudsmith.io/~ultimaker/repos/debian-backup/packages/detail/deb/postgresql-11-debversion/latest/a=arm64;xc=main;d=debian%252Fbuster;t=binary/
image::https://api.cloudsmith.com/v1/badges/version/ultimaker/debian-backup/deb/postgresql-11-debversion/latest/a=arm64;xc=main;d=debian%252Fbuster;t=binary/?render=true&show_latest=true[link="https://cloudsmith.io/~ultimaker/repos/debian-backup/packages/detail/deb/postgresql-11-debversion/latest/a=arm64;xc=main;d=debian%252Fbuster;t=binary/",title="Latest version of 'postgresql-11-debversion' @ Cloudsmith"]
<a href="https://cloudsmith.io/~ultimaker/repos/debian-backup/packages/detail/deb/postgresql-11-debversion/latest/a=arm64;xc=main;d=debian%252Fbuster;t=binary/"><img src="https://api.cloudsmith.com/v1/badges/version/ultimaker/debian-backup/deb/postgresql-11-debversion/latest/a=arm64;xc=main;d=debian%252Fbuster;t=binary/?render=true&show_latest=true" alt="Latest version of 'postgresql-11-debversion' @ Cloudsmith" /></a>

rendered as: Latest version of 'postgresql-11-debversion' @ Cloudsmith

These instructions assume you have setup the repository first (or read it).

To install/use postgresql-11-debversion @ version 1.1.1-2 ...

To install packages, you can quickly setup the repository automatically (recommended): 

curl -1sLf \
  'https://dl.cloudsmith.io/public/ultimaker/debian-backup/setup.deb.sh' \
  | sudo -E bash

If you need to force a specific distribution, release/version, architecture, or component (if supported), you can also do that (e.g. if your system is compatible but not identical): 

curl -1sLf \
  'https://dl.cloudsmith.io/public/ultimaker/debian-backup/setup.deb.sh' \
  | sudo -E distro=debian codename=buster arch=ARCH component=COMPONENT bash

or ... you can manually configure it yourself before installing packages: 

apt-get install -y debian-keyring  # debian only
apt-get install -y debian-archive-keyring  # debian only
apt-get install -y apt-transport-https
# For Debian Stretch, Ubuntu 16.04 and later
keyring_location=/usr/share/keyrings/ultimaker-debian-backup-archive-keyring.gpg
# For Debian Jessie, Ubuntu 15.10 and earlier
keyring_location=/etc/apt/trusted.gpg.d/ultimaker-debian-backup.gpg
curl -1sLf 'https://dl.cloudsmith.io/public/ultimaker/debian-backup/gpg.C334EFCB2C4F9BE3.key' |  gpg --dearmor >> ${keyring_location}
curl -1sLf 'https://dl.cloudsmith.io/public/ultimaker/debian-backup/config.deb.txt?distro=debian&codename=buster&component=main' > /etc/apt/sources.list.d/ultimaker-debian-backup.list
sudo chmod 644 ${keyring_location}
sudo chmod 644 /etc/apt/sources.list.d/ultimaker-debian-backup.list
apt-get update
sudo apt-get install postgresql-11-debversion=1.1.1-2
Warning: Note that this package is for Debian 10 (Buster) / arm64 and may only work for that configuration.
Still stuck? Need help? Don't panic. Just contact us for help (even if you're not a customer).
Previous Version: 1.1.1-2
Next Version: 1.1.1-2
Top