pgsql_remote.ini.example

# ======================================================================
#
# REMOTE PGSQL INSTANCE
# untested yet
#
# ======================================================================

[detect]

process = 'postgres|postmaster'
tcp-port = 5432
tcp-target = dbserver.example.com
tcp-process = 'postgres|postmaster'


[set]

su = ''
dbuser = 'mydbuser'
dbpassword = 'mypassword'

params = '--host= {tcp-target} --port={tcp-port} --username={dbuser}'
env = 'PGPASSWORD={{dbpassword}}'

# https://www.postgresql.org/docs/current/libpq-envars.html
# from pgsql help:
; Connection options:
;   -h, --host=HOSTNAME      database server host or socket directory (default: "/var/run/postgresql")
;   -p, --port=PORT          database server port (default: "5432")
;   -U, --username=USERNAME  database user name (default: "postgres")
;   -w, --no-password        never prompt for password
;   -W, --password           force password prompt (should happen automatically)

# ----------------------------------------------------------------------