Artifactory PostgreSQL Support

JFrog Installation & Setup Documentation

ft:sourceType: Paligo

Installation & Configuration
System Architecture
JFrog Artifactory Service
JFConnect Microservice
JFrog Xray Service
JFrog Pipelines Service
JFrog Distribution Service
JFrog Insight Service
System Directories
JFrog Home
Application Directory
Data Directory
Generic Directory Layout
System Requirements
General System Requirements
Requirements Matrix
Network Requirements for JFrog Products
Java Requirements for JFrog Products
Supported Browsers
Docker Requirements
Helm Chart Requirements
Artifactory System Requirements and Platform Support
Artifactory Database Requirements
Artifactory PostgreSQL Support
Artifactory Oracle Support
Artifactory MySQL Support
Artifactory Microsoft SQL Server Support
Artifactory MariaDB Support
Artifactory File Store
Artifactory Network Ports
Xray System Requirements and Platform Support
Xray Node Recommendations
Xray Storage Recommendations
Xray File Handle Allocation Limit
Database and Third-Party Applications in Xray
Xray Network Ports
Distribution System Requirements and Platform Support
Database and Third-Party Applications in Distribution
Distribution Network Ports
Pipelines System Requirements and Platform Support
Database and Third-Party Applications in Pipelines
Pipelines Network Ports
Insight System Requirements and Platform Support
Database and Third-Party Applications in Insight
Insight Network Ports
Checksum-Based Storage
Checksum-Based Storage Implementation
SHA-256 Support
Migrate the Database to Include SHA-256
Configure the SHA-256 Migration Process
Monitor the SHA-256 Migration Process
Install
Installing the JFrog Platform
Install the JFrog Platform using Helm Chart
JFrog Platform Helm Chart Installation Steps
JFrog Platform Product Configuration
Install Other JFrog Products with an Existing Artifactory Installation
Use an External PostgreSQL Database in the JFrog Platform Installation
Install the JFrog Platform Using Ansible
Set up Ansible and the JFrog Ansible Collection
System Requirements for Ansible Installation
JFrog Platform Ansible Installation Steps
Generate master and join keys for the Ansible Installation
Override the system.yaml file in Ansible installations
Use Ansible Vault to encrypt vars
Use an External Database with the Ansible Installation
Create the PostgreSQL Database for the Ansible Installation
Configure Artifactory to use PostgreSQL in an Ansible Installation
Configure Artifactory to Use PostgreSQL Single Node in Ansible
Configure Artifactory HA to Use PostgreSQL Database in HA in Ansible
Enable TLS Encryption in Ansible Installation
High Availability (HA) Ansible Installation
Build the Ansible Collection Archive
Set SSL Certificate and Key for Nginx for the Ansible Installation
Install the JFrog Platform using the K3s installer
K3s Installer System Requirements
K3s Installation Steps
Uninstall the JFrog Platform K3s Installation
Installing Artifactory
Installation Types
Installation Steps
Artifactory Single Node Installation
Artifactory HA Installation
Install Artifactory single node with Linux Archive
Install Artifactory single node with RPM
Install Artifactory single node with Debian
Install Artifactory Single Node with Helm Charts
Install Artifactory Single Node on OpenShift
Install Artifactory single node with Docker
Install Artifactory Single Node with Docker Compose
Artifactory Single Node Manual Docker Compose Installation
Artifactory Single Node Docker Compose Installation using Docker Volumes
Install Artifactory single node on Windows
Install Artifactory single node on Mac (Darwin)
Install Artifactory HA with Linux Archive
Install Artifactory HA with Helm
Install Artifactory HA on OpenShift
Install Artifactory HA with RPM
Install Artifactory HA with Debian
Install Artifactory HA with Docker Compose
Install Artifactory HA with Docker
Install Artifactory HA with Windows
Installing Artifactory Edge
Installing Xray
Xray Single Node Installation
Xray HA Installation
Install Xray Single Node with Interactive Script (recommended)
Install Xray Single Node with Linux Archive
Xray Single Node Manual RPM Installation
Xray Single Node Manual Debian Installation
Xray Single Node Manual Docker Compose Installation
Xray Single Node Helm Installation
Xray Single Node OpenShift Installation
Xray HA Helm Installation
Xray HA OpenShift Installation
Xray HA Linux Archive / RPM/ Debian Installation
Xray HA Docker Compose Installation
PostgreSQL for Xray
Set up an Xray PostgreSQL Database in Single Node
Set up an Xray PostgreSQL Database in High Availability
Enable PostgreSQL Connectivity for Xray from Remote Servers
Create the Xray PostgreSQL Database
Configure Xray to Use PostgreSQL Single Node
Configure Xray HA to Use PostgreSQL Database in HA
Support for pg_trgm Module
Installing JFrog Advanced Security
Install JFrog Advanced Security on your Self-Hosted Environment with Helm
Install JFrog Advanced Security on your Self-Hosted Environment without Helm
Prerequisites to Install JAS without Helm
JAS Interactive Script Installation
JAS Manual Installation
Configure JAS for Self-Signed non-Helm Installation
Configure JAS in an Air-gapped Non-Helm Environment
Install JAS in an Air-gapped Non-Helm Environment
Installing Distribution
Distribution Single Node Interactive Script Installation (recommended)
Distribution Single Node Linux Archive Installation
Distribution Single Node RPM Installation
Distribution Single Node Debian Installation
Distribution Single Node Docker Compose Installation
Distribution Single Node Helm Installation
Distribution HA Linux Archive/RPM/Debian Installation
Distribution HA Docker Compose Installation
Distribution HA Helm Installation
Installing Pipelines
Pipelines Single Node Installation with command line installer
Pipelines Single Node Helm Installation
Pipelines HA Installation
TLS in JFrog Pipelines
Configure TLS Certificates for Pipelines
Enable TLS in JFrog Pipelines
Custom CA Certificate in JFrog Pipelines
Load a Custom CA Certificate in JFrog Pipelines
Changing the Default Docker Images
Installing Insight
Insight Single Node Interactive Script Installation (recommended)
Insight Single Node Linux Archive Installation
Insight Single Node Manual RPM Installation
Insight Single Node Manual Debian Installation
Insight Single Node Helm Chart Installation
Insight Installation For Advanced Users
Insight HA Interactive Script Installation
Insight HA Manual Linux Archive Installation
Insight HA Helm Installation
Installing Mission Control
Configure JFrog Platform in an Air-gapped Environment
JFConnect Proxy Configuration
Upgrade
Upgrading Artifactory
Upgrading from Artifactory Version Below 6.10
Upgrading from Artifactory Version 6.10.x Onwards to 7.x
Upgrading from Artifactory Version 7.x to 7.x
Metadata Migration in the JFrog Platform
Artifactory version 6.x to 7.x Linux Archive Upgrade
Artifactory version 6.x to 7.x upgrade with Docker
Artifactory version 6.x to 7.x upgrade with Docker Compose
Artifactory version 6.x to 7.x upgrade with RPM
Artifactory version 6.x to 7.x upgrade with Debian
Artifactory version 6.x to 7.x upgrade with Helm
Artifactory version 6.x to 7.x upgrade in Windows
Artifactory version 7.x to 7.x Debian Upgrade
Artifactory version 7.x to 7.x Docker Compose Upgrade
Artifactory version 7.x to 7.x Docker Upgrade
Artifactory version 7.x to 7.x Helm Upgrade
Artifactory version 7.x to 7.x Linux Archive Upgrade
Artifactory version 7.x to 7.x RPM Upgrade
Artifactory version 7.x to 7.x Windows Upgrade
Upgrading an Artifactory Enterprise HA Cluster
Artifactory HA Session Management Options
Upgrade the First Artifactory Node
Upgrade the Additional Artifactory Node
Verify the HA Installation and Configuration
Upgrading Xray
Upgrading from Xray Version Below 2.7
Upgrading from Xray Version 2.7 to 3.x
Upgrading from Xray Version 3.x to 3.x
Xray Single Node Interactive Script Upgrade (Recommended)
Xray Single Node Linux Archive Upgrade
Xray Single Node Manual RPM/Debian Upgrade
Xray Single Node Manual Docker Compose Upgrade
Xray Helm Upgrade
Xray HA Upgrade
Xray and Artifactory One-to-One Pairing
Option 1: Pairing without configuration data (recommended)
Option 2: Pairing with configuration data
JFrog Xray PostgreSQL Upgrade-PostgreSQL 9.x EoS
Upgrading Distribution
Third Party Applications For Distribution
Upgrading from Distribution Version Below 1.6
Upgrading from Distribution Version 1.6 to 2.x
Upgrading from Distribution Version 2.x to 2.x
Distribution and Artifactory One to One Pairing
Upgrading Insight
Upgrading from Insight Version 1.x to 1.x
Upgrading Pipelines
Upgrading to Pipelines Version 1.x
Upgrading Pipelines Chart Version 1.x to 2.x and Above
Upgrading Mission Control
Migrating Platform Deployments and License Buckets
Migrating from Mission Control to Insight
Upgrading JFrog Platform for the Ansible Collection
Uninstalling JFrog Products
Helm Charts for Advanced Users
All Products - Customization
Establish TLS and Add Certificates in Helm Installation
Configure JFConnect Proxy for Helm Installation
Auto-generated Passwords (Internal PostgreSQL)
Add Custom Volumes in Helm Installation
Add Custom Sidecars Containers in Helm Installations
Add Custom Init Containers in Helm Installation
Use Custom Secrets in Helm Installation
Override the Default System YAML File in Helm Installation
Mission Control and Distribution Custom Volumes
Add Circle of Trust Certificates
Use Unified Secret in Helm Installation
Artifactory High Availability
Artifactory Storage
Add Licenses with Artifactory HA Helm Installation
Scale the Artifactory HA Helm Installation Cluster
Use an Existing Shared Volume Claim with Artifactory HA Helm Installation
Use an Existing Volume Claim for Artifactory HA Helm Installation
Artifactory Advanced Options
Add Licenses Using Secrets
Security-related Issues
Run Ingress Behind Another Load Balancer
Log Analytics
Advanced Storage Options
Add Extensions
Infrastructure Customization
Use ConfigMaps to Store Non-confidential Data
Use an External Database with Artifactory Helm Installation
Bootstrapp Artifactory
Monitoring and Logging in Artifactory Helm Installation
Install Artifactory and Artifactory HA with Nginx and Terminate SSL in Nginx Service (Load Balancer)
Advanced Options for Xray
Enable TLS in RabbitMQ in Xray Helm Chart
Enable TLS in RabbitMQ for Xray in JFrog Platform Chart
Advanced Options for Pipelines
Install the Pipelines Chart with Ingress
Set up a Build Plane
Use Pipelines with an External PostgreSQL
Use an External Secret for the Pipelines Password
Use an External system.yaml with an Existing Secret
Use an External Vault
Use Vault in Production Environments
Advanced Options for Insight
Advanced Options for Mission Control
Uninstall and Deletion of Helm Installations
Uninstall Artifactory Helm Installation
Delete Artifactory Helm Installation
Delete Xray Helm Installation
System Configuration
Artifactory Bootstrap YAML File
Access Bootstrap YAML File
Artifactory YAML Configuration
Artifactory YAML File Format
Apply Artifactory YAML Configuration Changes
Delete an existing element in Artifactory YAML
Repositories Configurations in Artifactory YAML
Replication (push and pull) Configurations in Artifactory YAML
General (General, Property Sets, Proxy, Mail) Configurations in Artifactory YAML
Security Configurations in Artifactory YAML
Service Configurations in Artifactory YAML
Token Configurations in Artifactory YAML
Advanced Configurations in Artifactory YAML
Artifactory Configuration Files
Global Configuration Descriptor
Security Configuration Descriptor
Content Type/MIME Type
Artifactory System Properties
Storage Properties
System YAML Configuration File
Implementing Configuration as Code in JFrog
Using System YAMLs
Artifactory System YAML
Artifactory System YAML Configuration Topics
Xray System YAML
Distribution System YAML
Supported Configurations in Distribution System YAML
Insight System YAML
Supported Configurations in Insight System YAML
Pipelines System YAML
Supported Configurations in Pipelines System YAML
Mission Control System YAML
Distribution Application Config YAML File
Access YAML Configuration
Access YAML Configuration Files
Upload the Access YAML File
Enable New Integrations
Revert to Previous Access Configurations
Supported Access Configurations
Migrated Authentication Provider Properties
Filestore Configuration
Filestore Configuration
Binary Provider
Chain Templates
Modify an existing chain template
Create a custom filestore from scratch
File System Binary Provider
file-system binary provider template configuration
Cached Filesystem Binary Provider
cache-fs template configuration
Full-DB and Full-DB-Direct Binary Providers
Full-DB binary provider template configuration
Full-DB-Direct binary provider template configuration
Filestore Sharding
Configure a Sharding Binary Provider
Basic Sharding Configuration
Cross-Zone Sharding Configuration
Double Shards Binary Provider
Redundant Shards Binary Provider
State-Aware Binary Provider
Configure Sharding for HA Cluster
Cluster-File-System Binary Provider
Cluster-File-System Example
Sharding-Cluster Binary Provider
Using Balancing to Recover from Mount Failure
Restoring Balance in Unbalanced Redundant Storage Units
Optimizing System Storage
S3 Object Storage
Set up Artifactory to Use S3
Configure Artifactory to Use S3
Amazon S3 Official SDK Template
Amazon S3 Template Parameters
S3 Binary Storage Template Configuration
S3 Direct Upload Template (Recommended)
S3 Eventual Upload Template
Amazon S3 SDK Cluster Binary Provider
cluster-s3-storage-v3 template configuration
What's in the cluster-s3-storage-v3 template?
S3 Sharding
S3-sharding Template
State-Aware-S3 Binary Provider
S3 Sharding Examples
Migrate Your Filestore to S3
Automatic Filestore Migration (Recommended)
Manual Filestore Migration
Google Cloud Storage
Set up Artifactory to use GCS
Google Storage Binary Provider Native Client Template
Google Cloud Storage Authentication Mechanism
google-storage-v2-direct template configuration (Recommended)
google-storage-v2 template configuration
Google Storage V2 Cluster Binary Provider
cluster-google-storage template configuration
What's in the cluster-s3-storage-v3 template?
Migrate Your Filestore to Google Storage
Azure Blob Storage
Set up Artifactory to Use Azure Blob Storage
Azure Blob Storage V2 Binary Provider
Azure Direct Upload V2 Template (Recommended)
Azure Eventual Upload V2 Template
Azure Blob Storage Cluster V2 Binary Provider
cluster-azure-blob-storage-v2 template configuration
What's in the template?
Azure Blob Storage V1 Binary Provider
Azure Direct Upload V1 Template (Recommended)
Azure Eventual Upload Template
Azure Blob Storage Cluster V1 Binary Provider
cluster-azure-blob-storage template configuration
What's in the cluster-azure-blob-storage template?
Remote Binary Provider
Eventual Binary Provider
Retry Binary Provider
State-Aware Binary Provider
Eventual-Cluster Binary Provider
State-Aware-S3 Binary Provider
Direct Cloud Storage Download
Step 1: Configure the Artifactory Filestore for Direct Cloud Storage
Step 2: Specify Repositories for Direct Download
Specify Repositories for Direct Download Using the UI
Using Redirect Download with CDN or Private Distribution Network (PDN) Nodes
Specify Repositories for Direct Download Using the REST API
Specify Repositories for Direct Download Using the YAML Configuration File
Step 3: Finetune Direct Download
Step 4: Control Your Signed URL Downloads
Step 5: Configure Firewalls
Step 6: Use CloudFront (Optional)
Database Configuration
Choose the right database
Database Connection Settings
Database setup workflow
Database tuning for heavy loads in Artifactory
PostgreSQL for Artifactory
Create the Artifactory PostgreSQL Database
Enable PostgreSQL Connectivity from Remote Servers
Configure Artifactory to Use PostgreSQL
Configure Artifactory to Use PostgreSQL Single Node
Configure Artifactory HA to Use PostgreSQL Database in HA
Enable TLS Encryption for PostgreSQL
MariaDB for Artifactory
Create the Artifactory MariaDB Database
Configure Artifactory to use MariaDB
Increase MariaDB Default Packet Size
Tune MariaDB for Artifactory
Known Issues with MariaDB
MySQL for Artifactory
Create the Artifactory MySQL Database
Configure Artifactory to use MySQL
Increase MySQL Default Packet Size
Tune MySQL for Artifactory
Microsoft SQL Server for Artifactory
Create the Artifactory Microsoft SQL Server Database
Configure Artifactory to use Microsoft SQL Server
Oracle for Artifactory
Create the Artifactory Oracle Database
Configure Artifactory to use Oracle
High Availability
Cloud-Native High Availability
HA Architecture
Load Balancer in HA
JFrog Application in HA
Common Resources in HA
Clustering Artifactory
IPv6 Support
Replicator
Installation and Activation of the Replicator
Configure the Replicator
Replicator Log Files
Replicator and Working with a Proxy
Replicator and Working with Reverse Proxy
Replicator and High Availability
Load Balancer
Communication Between Services
Manage Keys
Join Key
Fetch the JPD join key
Manage the join key
Manage join keys in HA
Master Key
Master key load and retention in memory
Create your keys
Bootstrap with your own keys using the system.yaml file
Bootstrap the join key using file system
Pairing Tokens
Master Token
Set up Pairing Tokens
Create an automatic admin token
Using Access as a Certificate Authority
Set TLS on the JFrog Platform
Step 1: Enable TLS in the JFrog Platform
Step 2: Set the TLS Certificate
Prerequisites for Custom TLS Certificate
Option 1: Use Access as a Root CA with an Access-generated self-signed certificate
Option 2: Provide your own signed certificate
Option 3: Provide a custom CA certificate to Access
Regenerate a new Access CA certificate
Using TLS Certificates as a Client
Download TLS Certificates
Trust a self-signed certificate or a new CA
Trust a self-signed certificate in Xray instances/nodes
Custom Token Certificates
Load the key pair to the JFrog Platform Deployment (JPD) through bootstrap files
Create a private-public key pair
Configure Proxy Between JFrog Products
Onboarding Wizard
JFrog Products Container Base Image
Migrating from Sonatype Nexus Repository Manager to Artifactory
Nexus Migrator Release Notes
Nexus Migrator 0.9.2
Nexus Migrator 0.9.1
Nexus Migrator 0.9.0
Migrator Tool Overview
Migration of Privileges
Repositories and Users in Nexus Repository Manager and Artifactory
Before you begin
Migration Process
Run the migration tool in a single step
Run the migration tool in multiple stages
Edit Migration Configuration [OPTIONAL]
Edit Repository Names [OPTIONAL]
Edit Security Entities [OPTIONAL]
Avoid Repositories from Migration [OPTIONAL]
Avoid Security Entities from Migration [OPTIONAL]
Repository Migration Status

Artifactory supports the following versions of PostgreSQL.

15.x
14.x
13.x
12.x
11.x
10.x

Back to home page