I have a problem when connecting to my postgres from my laptop using datagrip.
I follow this steps as explained here Multi-region PostgreSQL · Fly Docs
The problem is when I edited toml file
# fly.toml file generated for dvdprod on 2022-10-29T09:52:57+07:00
app = "dvdprod"
kill_signal = "SIGINT"
kill_timeout = 5
processes = []
[env]
[experimental]
allowed_public_ports = []
auto_rollback = true
[[services]]
http_checks = []
internal_port = 5432
processes = ["app"]
protocol = "tcp"
script_checks = []
[services.concurrency]
hard_limit = 25
soft_limit = 20
type = "connections"
[[services.ports]]
force_https = true
handlers = ["http"]
port = 80
[[services.ports]]
handlers = ["tls", "http"]
port = 443
# Open port 10000 for plaintext connections.
[[services.ports]]
handlers = []
port = 10000
[[services.tcp_checks]]
grace_period = "1s"
interval = "15s"
restart_limit = 0
timeout = "2s"
and run fly deploy . --app <app-name> --image flyio/postgres:14.4
to check that, I ran fly info
App
Name = dvdprod
Owner = personal
Version = 0
Status = deployed
Hostname = dvdprod.fly.dev
Services
PROTOCOL PORTS
IP Addresses
TYPE ADDRESS REGION CREATED AT
The ports still don’t show up. When I tried to connect PostgreSQL via datagrip and input the IP address. it failed