---
updatedAt: 2026-05-21T09:14:56.000Z
agentTools:
  siteIndex: https://docs.jfrog.com/llms.txt
  projectIndex: https://docs.jfrog.com/installation/llms.txt
---

# Artifactory PostgreSQL Single Node Configuration with Ansible

Configure a single-node JFrog Artifactory instance to use PostgreSQL by stopping the service, editing the database block in system.yaml, and restarting.

To run JFrog Artifactory with PostgreSQL as a single node, create a dedicated PostgreSQL database instance and then configure Artifactory to use it as described in the following sections. Refer to the <a href="https://www.postgresql.org/docs/" target="_blank">PostgreSQL documentation</a> for the PostgreSQL version you are using.

1. Stop the Artifactory service.
2. Edit the database connection details in the [system.yaml configuration file](artifactory-system-yaml) as follows.

   ```yaml
   shared:
     database:
       type: postgresql
       driver: org.postgresql.Driver
       url: jdbc:postgresql://<your db url, for example: localhost:5432>/artifactory
       username: artifactory
       password: password
   ```
3. Start the Artifactory service.

## Related Topics

* [PostgreSQL for Artifactory](postgresql-for-artifactory)
* [Create the Artifactory PostgreSQL Database](create-the-artifactory-postgresql-database)
* [Enable PostgreSQL Connectivity from Remote Servers](enable-postgresql-connectivity-from-remote-servers)
* [Configure Artifactory to Use PostgreSQL](configure-artifactory-to-use-postgresql)
* [Artifactory system.yaml](artifactory-system-yaml)