Skip to main content
Ctrl+K
Software Heritage  documentation - Home Software Heritage  documentation - Home
  • Development
  • API reference
  • Usage
  • Infrastructure
  • About
  • GitLab
  • PyPI
  • System Status
  • Software Heritage Homepage
  • Development
  • API reference
  • Usage
  • Infrastructure
  • About
  • GitLab
  • PyPI
  • System Status
  • Software Heritage Homepage

Section Navigation

  • Getting started
    • Reference: Setup sysadm repositories
  • Puppet
    • Puppet setup
    • Tutorial: Making my first change in Puppet
    • How to manage Third-Party modules
    • How to test Puppet changes in Vagrant
    • How to deploy a Puppet change
    • How to renew an agent certificate
    • Reference: Architecture of the Software Heritage Puppet deployment
    • Reference: Puppet best practices
  • Network architecture
    • Reference: Network configuration
    • How to access firewall settings
    • How to access firewall nodes without the vpn
    • How to upgrade firewall OS
    • Service urls
    • iDRAC
    • DNS servers
  • Server Architecture (Physical/Virtual)
    • How to provision a new VM
    • How to install a new physical server
    • How to upgrade a machine
    • How to search the inventory
    • Reference: Inventory of machines
    • Reference: Baseline for hardware purchases
    • Backups
      • Backup infrastructure
      • How to access backups
  • Software Architecture
    • Software stories
    • IRC Alert Manager
  • Data silos
    • PostgreSQL
      • How to connect to PostgreSQL databases
      • How to manage the PostgreSQL backups
    • Cassandra
      • How to install a cassandra node
      • How to upgrade a cassandra cluster
      • Upgrade Procedure for Debian Nodes in a Cassandra Cluster
    • Kafka
      • Reference: Manage topics
      • Upgrade Procedure for Debian Nodes in Kafka Cluster
    • ElasticSearch
      • Upgrade Procedure for Debian Nodes in an Elasticsearch Cluster
    • Winery Deployment
      • Winery Network Documentation
      • Winery Frontends Documentation
      • Winery Ceph Architecture
      • Winery Procedures
        • Install a new server
        • Accessing the winery cluster
        • VPN procedures
        • Switches procedures
        • Frontends procedures
        • Procedures related to ceph
    • Cluster Rancher
      • Upgrade Procedure for Debian Nodes in a Rancher Cluster
    • Provenance
      • Provenance Overview
  • SWH Software Deployment
    • Reference: Deployment Environments
    • Upgrade swh service
    • How to deploy a new lister
    • How to handle a storage database migration
    • Debian packaging
    • Jenkins
    • ArgoCD
    • Add-forge-now automation
    • How to process add-forge-now requests
    • How to add journal user credential
    • How to bulk ingest a list of origins
    • How to run the swh stack in a local kubernetes cluster
    • How to reset the next version environment
    • How to deploy swh.graph in production?
    • Webhooks Svix
  • User management
    • Reference: Onboarding checklist
    • Reference: Outboarding checklist
    • How to manage the credentials store
    • Keycloak
      • Authentication
      • Realm administration
    • OpenVPN
      • How to configure OpenVPN
      • softwareheritage-ca.crt
  • Life-cycle management
    • How to manage upgrades of tools and software inventory
    • How to devise the backup strategy for a (new) service
  • Mirror Operations
    • Hosting a mirror
    • How to deploy a mirror
      • Deploy a Software Heritage stack with docker deploy
    • Using seaweedfs as object storage backend
    • Takedown notices on mirrors
    • How to onboard a mirror
    • How to monitor a mirror
  • Support services
    • Azure Kubernetes Service
      • Azure Kubernetes Service howtos
    • Gitlab
      • Gitlab installation
    • Rancher
      • Rancher howtos
  • Infrastructure
  • Data silos
  • PostgreSQL

PostgreSQL#

  • How to connect to PostgreSQL databases
    • Sample ~/.pg_service.conf
    • Sample ~/.pgpass
  • How to manage the PostgreSQL backups
    • List the servers with backups
    • List the backups of a server
    • Manually delete a backup
    • Manually start a backup

previous

Data silos

next

How to connect to PostgreSQL databases

Edit

This Page

  • Show Source

© Copyright 2015-2024 The Software Heritage developers.

Created using Sphinx 7.4.7.

Built with the PyData Sphinx Theme 0.16.1.