PostgreSQL replication does not show installed sandboxes

[maleksov]

Environment

• dbdeployer version: 2.2.0
• OS: Ubuntu 24.04.4 LTS
• PostgreSQL/database version: 18.3
• Flavor: PostgreSQL
• Topology: replication

Describe the bug
Installing PostgreSQL replication is not seen with dbdeployer sandboxes. Also dbdeployer admin ui does not show installed sandboxes.

Steps to reproduce

1. Run the command dbdeployer deploy replication 18.3 --provider=postgresql
2. Run the command dbdeployer sandboxes
3. Run the command dbdeployer admin ui
4. No output is seen

Expected behavior
PostgreSQL sandboxes to be listed

Actual behavior

dbdeployer deploy replication 18.3 --provider=postgresql                                                                                                       
  Primary deployed in /home/martinaleksov/sandboxes/postgresql_repl_16803/primary (port: 16803)
  Replica 1 deployed in /home/martinaleksov/sandboxes/postgresql_repl_16803/replica1 (port: 16804)
  Replica 2 deployed in /home/martinaleksov/sandboxes/postgresql_repl_16803/replica2 (port: 16805)
postgresql replication sandbox (1 primary + 2 replicas) deployed in /home/martinaleksov/sandboxes/postgresql_repl_16803

~ ❯ dbdeployer sandboxes                                                                                                                                           
 
~ ❯ lsb_release -a                                                                                                                                                 
No LSB modules are available.
Distributor ID:	Ubuntu
Description:	Ubuntu 24.04.4 LTS
Release:	24.04
Codename:	noble
 
~ ❯ dpkg -l |grep postgre                                                                                                                                          
ii  libreoffice-sdbc-postgresql                    4:24.2.7-0ubuntu0.24.04.4                        amd64        PostgreSQL SDBC driver for LibreOffice
ii  postgresql-18                                  18.3-1.pgdg24.04+1                               amd64        The World's Most Advanced Open Source Relational Database
ii  postgresql-18-jit                              18.3-1.pgdg24.04+1                               amd64        LLVM JIT support for PostgreSQL 18
ii  postgresql-client-16                           16.13-1.pgdg24.04+1                              amd64        front-end programs for PostgreSQL 16
ii  postgresql-client-17                           17.9-1.pgdg24.04+1                               amd64        front-end programs for PostgreSQL 17
ii  postgresql-client-18                           18.3-1.pgdg24.04+1                               amd64        front-end programs for PostgreSQL 18
ii  postgresql-client-common                       290.pgdg24.04+1                                  all          manager for multiple PostgreSQL client versions
ii  postgresql-common                              290.pgdg24.04+1                                  all          PostgreSQL database-cluster manager

 ~ ❯ dbdeployer --version                                                                                                                                           
dbdeployer version 2.2.0

 ~ ❯ dbdeployer admin ui                                                                                                                                            

  dbdeployer admin
  ────────────────────────────────
  URL: http://127.0.0.1:9090/login?token=5152a77eddc37d42a1f456095d735012
  Press Ctrl+C to stop

^C
 ~ ❯ ll ~/sandboxes                                                                                                                                
total 4,0K
drwxr-xr-x 5 martinaleksov martinaleksov 4,0K апр  8 13:23 postgresql_repl_16803

 ~ ❯ ll ~/sandboxes/postgresql_repl_16803                                                                                                                           
total 20K
-rwxr-xr-x 1 martinaleksov martinaleksov  426 апр  8 13:23 check_recovery
-rwxr-xr-x 1 martinaleksov martinaleksov  314 апр  8 13:23 check_replication
drwx------ 3 martinaleksov martinaleksov 4,0K апр  8 13:23 primary
drwx------ 3 martinaleksov martinaleksov 4,0K апр  8 13:23 replica1
drwx------ 3 martinaleksov martinaleksov 4,0K апр  8 13:23 replica2

 ~ ❯ dbdeployer admin ui                                                                                                                                            

  dbdeployer admin
  ────────────────────────────────
  URL: http://127.0.0.1:9090/login?token=2ab1d632c0b3bacbdef05aa0c1d7dacc
  Press Ctrl+C to stop

Hardware (if applicable)

• Free storage:

df -h /home                                                                                                                                                    
Filesystem                 Size  Used Avail Use% Mounted on
/dev/mapper/vgubuntu-home  271G   23G  235G   9% /home

• Total RAM:

free -h                                                                                                                                                       
               total        used        free      shared  buff/cache   available
Mem:            30Gi       7,0Gi        17Gi       1,8Gi       8,2Gi        23Gi
Swap:           31Gi          0B        31Gi

Additional context
The same behavior is seen with installing PostgreSQL locally or by using downloaded deb files.
Can you add an option like in MySQL flavor to start/stop all sandboxes at once since now only 1 by 1 is possible?

ll ~/sandboxes/postgresql_repl_16803/*                                                                                                                          py_envs at  13:41:19
-rwxr-xr-x 1 martinaleksov martinaleksov  426 апр  8 13:23 /home/martinaleksov/sandboxes/postgresql_repl_16803/check_recovery
-rwxr-xr-x 1 martinaleksov martinaleksov  314 апр  8 13:23 /home/martinaleksov/sandboxes/postgresql_repl_16803/check_replication

/home/martinaleksov/sandboxes/postgresql_repl_16803/primary:
total 32K
-rwxr-xr-x  1 martinaleksov martinaleksov  518 апр  8 13:23 clear
drwx------ 20 martinaleksov martinaleksov 4,0K апр  8 13:23 data
-rw-------  1 martinaleksov martinaleksov  252 апр  8 13:23 postgresql.log
-rwxr-xr-x  1 martinaleksov martinaleksov  331 апр  8 13:23 restart
-rwxr-xr-x  1 martinaleksov martinaleksov  329 апр  8 13:23 start
-rwxr-xr-x  1 martinaleksov martinaleksov  252 апр  8 13:23 status
-rwxr-xr-x  1 martinaleksov martinaleksov  258 апр  8 13:23 stop
-rwxr-xr-x  1 martinaleksov martinaleksov  214 апр  8 13:23 use

/home/martinaleksov/sandboxes/postgresql_repl_16803/replica1:
total 32K
-rwxr-xr-x  1 martinaleksov martinaleksov  521 апр  8 13:23 clear
drwx------ 20 martinaleksov martinaleksov 4,0K апр  8 13:23 data
-rw-------  1 martinaleksov martinaleksov  252 апр  8 13:23 postgresql.log
-rwxr-xr-x  1 martinaleksov martinaleksov  333 апр  8 13:23 restart
-rwxr-xr-x  1 martinaleksov martinaleksov  331 апр  8 13:23 start
-rwxr-xr-x  1 martinaleksov martinaleksov  253 апр  8 13:23 status
-rwxr-xr-x  1 martinaleksov martinaleksov  259 апр  8 13:23 stop
-rwxr-xr-x  1 martinaleksov martinaleksov  214 апр  8 13:23 use

/home/martinaleksov/sandboxes/postgresql_repl_16803/replica2:
total 32K
-rwxr-xr-x  1 martinaleksov martinaleksov  521 апр  8 13:23 clear
drwx------ 20 martinaleksov martinaleksov 4,0K апр  8 13:23 data
-rw-------  1 martinaleksov martinaleksov  252 апр  8 13:23 postgresql.log
-rwxr-xr-x  1 martinaleksov martinaleksov  333 апр  8 13:23 restart
-rwxr-xr-x  1 martinaleksov martinaleksov  331 апр  8 13:23 start
-rwxr-xr-x  1 martinaleksov martinaleksov  253 апр  8 13:23 status
-rwxr-xr-x  1 martinaleksov martinaleksov  259 апр  8 13:23 stop
-rwxr-xr-x  1 martinaleksov martinaleksov  214 апр  8 13:23 use

[coderabbitai]

🔗 Related PRs

#54 - feat: Phase 3 — PostgreSQL provider [merged]

---

📝 Issue Planner

_{Check the box below or use the @coderabbitai plan command to generate an implementation plan and prompts that you can use with your favorite coding assistant.}

• Create Plan

---

🧪 Issue enrichment is currently in open beta.

You can configure auto-planning by selecting labels in the issue_enrichment configuration.

To disable automatic issue enrichment, add the following to your .coderabbit.yaml:

issue_enrichment:
  auto_enrich:
    enabled: false

💬 Have feedback or questions? Drop into our discord!