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)

Search queries for all Generic-specific package types

Search by file path:
generic_filepath:path/to/file.txt

Search by directory:
generic_directory:path/to

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, Generic, Go, Helm, Hex, HuggingFace, LuaRocks, Maven, MCP, npm, NuGet, P2, Python, RedHat, Ruby, Swift, Terraform, Vagrant, VSX, 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
 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).

Debian logo postgresql-11-debversion  1.1.1-2

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.0 KB

Downloads

2

Status  Completed
Checksum (MD5) f134e2022454fd92d05a4859d793c18c
Checksum (SHA-1) 8e52ea26eff803fa64d6501d1b2562a62f5485d6
Checksum (SHA-256) 3f2309d1391b172d0f7b26c2a6d1e173aef169cedc6c80b5a0c90dfa6366d0bd
Checksum (SHA-512) 39b416c3fdb14670ce202333db03d3bd23334842fa5bcc145fd3d3d33a4744e8c0…
GPG Signature
GPG Fingerprint c0a114330029b468b1146f70c334efcb2c4f9be3
Distribution debian/buster - Debian - 10 (Buster)
Storage Region  Dublin, Ireland
Type  Binary (contains binaries and binary artifacts)
Uploaded At 1 year, 2 months ago
Uploaded By alex-borro
Slug Id postgresql-11-debversion_111-2_armhfdeb-k1bm
Unique Id u6C4j2PZtJDZ
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 56.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-… 2
15.0 KB
md5 sha1 sha256 sha512
Package Contents (postgresql-11-debversion_1.1.1-2_armhf.deb)
Loading...

This package has 28 files/directories.

Dependencies

4

Checksum (md5)

05686d459f36b09a3ba7c8dbfb3a1a42

Depends
libapt-pkg5.0 >=0.8.0
Depends
libc6 >=2.4
Depends
libgcc1 >=1:3.5
Depends
postgresql-11

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=armhf;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=armhf;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=armhf;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=armhf;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=armhf;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=armhf;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=armhf;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=armhf;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=armhf;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=armhf;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=armhf;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=armhf;xc=main;d=debian%252Fbuster;t=binary/
image::https://api.cloudsmith.com/v1/badges/version/ultimaker/debian-backup/deb/postgresql-11-debversion/latest/a=armhf;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=armhf;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=armhf;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=armhf;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) / armhf and may only work for that configuration.
Previous Version
Next Version
Top