Use dynamic port handling for ProxySQL with PostgreSQL

[ronaldbradford]

Environment

• dbdeployer version: 2.3.0
• Go version 1.25.6
• OS: Linux (Ubuntu 24.04)
• PostgreSQL version: 17.1
• ProxySQL version: 3.0.8-481-g0ef544c
• Topology: replication --with-proxy

Describe the bug
When using with PostgreSQL, config was using MySQL ports.
Updated use and use_proxysql to use PostgreSQL non-password syntax

$  tail proxysql/data/proxysql.log
2026-05-20 17:41:13 main.cpp:1648:ProxySQL_Main_init_phase3___start_all(): [ERROR] Configuration conflict detected: Admin listener '0.0.0.0:6032' overlaps with Admin PostgreSQL listener '127.0.0.1:6032'

Steps to reproduce

./dbdeployer-2.3.1.linux deploy replication ${PG_MINOR_VERSION} --provider=postgresql --sandbox-directory=demo --with-proxysql

Expected behavior
Switched to using custom non-conflicting PostgreSQL ports.

[ronaldbradford]

See #125

[coderabbitai]

🔗 Related PRs

#63 - feat: add InnoDB Cluster topology (#58) [merged]
#73 - feat: use rsandbox as ProxySQL monitor, add R/W split proxy users (#69, #70) [merged]
#81 - fix: resolve all CI failures [merged]
#118 - ci(postgresql): stop installing system PG before tests so issue #112 path is exercised [merged]
#119 - fix(postgresql): avoid port collisions across single/replication/multiple deploys [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!

[renecannao]

Fixed by #125 (merged).

PostgreSQL + ProxySQL now uses correct dynamic port handling:

• pgsql_ifaces (instead of mysql_ifaces) for the ProxySQL admin listener when backend is PostgreSQL
• Dedicated admin port via ProxySQLAdminPort() (maps from PG 15000+ range to 4518+)
• use / use_proxy scripts now emit proper psql postgresql://user:pass@host:port URIs
• Port collision avoidance passes installed ports when calling FindFreePort

See merged PR #125 (commit 96048f5 on master).

[renecannao]

Closing as fixed by #125.