Hello. I want to run postgres migration script with bitbucket using ssh-run pipe. Command hangs after SELECT query
here is my step example:
```
<span>-</span> step:
name: Run miggartion
script:
<span>-</span> pipe: atlassian<span>/</span>ssh<span>-</span>run:<span>0.7</span><span>.0</span>
variables:
DEBUG: "true"
SSH_USER: $USERNAME
SERVER: $HOST
COMMAND: <span>'sudo su - postgres -c "psql -d test -f /tmp/test.sql && echo test"'</span>
SSH_KEY: $KEY```
Here is my migration script example:
```
<span>--</span>
<span>-- PostgreSQL database dump</span>
<span>--</span>
<span>-- Dumped from database version 15.3 (Debian 15.3-0+deb12u1)</span>
<span>-- Dumped by pg_dump version 15.3 (Debian 15.3-0+deb12u1)</span>
<span>SET</span> statement_timeout <span>=</span> <span>0</span>;
<span>SET</span> lock_timeout <span>=</span> <span>0</span>;
<span>SET</span> idle_in_transaction_session_timeout <span>=</span> <span>0</span>;
<span>SET</span> client_encoding <span>=</span> <span>'UTF8'</span>;
<span>SET</span> standard_conforming_strings <span>=</span> <span>on</span>;
<span>SELECT</span> pg_catalog.set_config(<span>'search_path'</span>, <span>''</span>, <span>false</span>);
<span>SET</span> check_function_bodies <span>=</span> <span>false</span>;
<span>SET</span> xmloption <span>=</span> content;
<span>SET</span> client_min_messages <span>=</span> warning;
<span>SET</span> row_security <span>=</span> off;
<span>SET</span> default_tablespace <span>=</span> <span>''</span>;
<span>SET</span> default_table_access_method <span>=</span> heap;
```
Her is log output:
```
Warning: Permanently added '1.1.1.1' (EDxxxxx) to the list of known hosts.
dumb
SET
SET
SET
SET
SET
^[=
set_config
------------
(1 row)
-- INSERT --
```
