Use PGXN to Install the PostgreSQL | PolarDB Plug-in

This article describes how to use PostgreSQL Extension Network (PGXN) to Install the PostgreSQL | PolarDB Plug-in.

By digoal

Background

PostgreSQL Extension Network (PGXN) is an open source plug-in management platform for PostgreSQL. Most plug-ins can be downloaded in PGXN.

It is very convenient to use PGXN to search for plug-ins and install them for databases.

For example, download PGXN in debian:

apt-get install -y pgxnclient

List PGXN help

root@abaf67f643b7:/tmp/pgvector# pgxn --help  
usage: pgxnclient [--version] [--help] COMMAND ...  
  
Interact with the PostgreSQL Extension Network (PGXN).  
  
optional arguments:  
  --version  print the version number and exit  
  --help     show this help message and exit  
  
available commands:  
  COMMAND    the command to execute. The complete list is available using `pgxn help --all`. Builtin commands are:  
    check    run a distribution's test  
    download  
             download a distribution from the network  
    help     display help and other program information  
    info     print information about a distribution  
    install  download, build and install a distribution  
    load     load a distribution's extensions into a database  
    mirror   return information about the available mirrors  
    search   search in the available extensions  
    uninstall  
             remove a distribution from the system  
    unload   unload a distribution's extensions from a database

List PGXN mirror

root@abaf67f643b7:/tmp/pgvector# pgxn mirror  
https://pgxn.dalibo.org/  
https://api.pgxn.org/

List the basic information of a plug-in

root@abaf67f643b7:/tmp/pgvector# pgxn info kmeans  
name: kmeans  
abstract: K-means clustering as a user-defined window function  
description: This module provides k-means calculation over row set.  
maintainer: Hitoshi Harada <umi.tanuki@gmail.com>  
license: postgresql  
release_status: stable  
version: 1.1.0  
date: 2011-07-22T18:11:02Z  
sha1: 6714548002400d038370cfb9bcd0b22df1e8a73c  
provides: kmeans: 1.1.0  
  
root@abaf67f643b7:/tmp/pgvector# pgxn info vector  
name: vector  
abstract: Open-source vector similarity search for Postgres  
description: Supports L2 distance, inner product, and cosine distance  
maintainer: Andrew Kane <andrew@ankane.org>  
license: PostgreSQL: http://www.postgresql.org/about/licence  
release_status: stable  
version: 0.5.0  
date: 2023-08-29T00:08:28Z  
sha1: 44d7f4398b2ccef33c5472ae1adff24cff7c48f2  
provides: vector: 0.5.0  
runtime: requires: PostgreSQL 11.0.0

Install a plug-in

root@abaf67f643b7:/tmp/pgvector# pgxn install kmeans  
  
root@abaf67f643b7:/tmp/pgvector# pgxn install vector

0 1 0

Share on

: digoal

276 posts | 24 followers
Follow

PolarDB for PostgreSQL

Alibaba Cloud PolarDB for PostgreSQL is an in-house relational database service 100% compatible with PostgreSQL and highly compatible with the Oracle syntax.

Learn More

PolarDB for Xscale

Alibaba Cloud PolarDB for Xscale (PolarDB-X) is a cloud-native high-performance distributed database service independently developed by Alibaba Cloud.

Learn More