Spaces:

Stouching-Robotics
/

DataFlowing

Running

DataFlowing / processor /scripts /run_db_tunnel_windows.ps1

sync processor from GitLab 32d515b: glove display fixes, GPU acceleration, AI annotation propose-clip fix

95f5290 2 months ago

738 Bytes

$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}"

	$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}"