I know a query runs until it returns data when connection to the client is lost. However, what if you use pg_restore. Does it upload the restore file and then does the restore on the server? Or does it restore step by step requiring the client to stay connected.
I want to know this because my employee uses a vpn that disconnects automatically after some time. And the restore takes longer that the timeout XD.
When the connection got lost I got the
pg_restore: error: error returned by PQputCopyData: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. error.
However on the server I can see the process is still up and running using
SELECT * FROM pg_stat_activity;