File size: 738 Bytes
d646dd7
 
95f5290
d646dd7
 
95f5290
d646dd7
 
 
 
1
2
3
4
5
6
7
8
9
10
11
$ErrorActionPreference = 'Stop'

$sshHost = if ($env:EGODATA_SSH_HOST) { $env:EGODATA_SSH_HOST } else { '192.168.110.41' }
$sshUser = if ($env:EGODATA_SSH_USER) { $env:EGODATA_SSH_USER } else { 'Stouch' }
$localPort = if ($env:EGODATA_DB_LOCAL_PORT) { [int]$env:EGODATA_DB_LOCAL_PORT } else { 15432 }
$remoteDbHost = if ($env:EGODATA_DB_REMOTE_HOST) { $env:EGODATA_DB_REMOTE_HOST } else { '172.19.0.2' }
$remoteDbPort = if ($env:EGODATA_DB_REMOTE_PORT) { [int]$env:EGODATA_DB_REMOTE_PORT } else { 5432 }

Write-Host "Opening PostgreSQL tunnel 127.0.0.1:$localPort -> $remoteDbHost`:$remoteDbPort via $sshUser@$sshHost"
ssh -o ExitOnForwardFailure=yes -N -L "127.0.0.1:${localPort}:${remoteDbHost}:${remoteDbPort}" "${sshUser}@${sshHost}"