Sample Header Ad - 728x90

Can I get results from a Postgres query that I got disconnected from?

1 vote
2 answers
194 views
I started an hours-long Postgres query in my psql shell. Then, I got disconnected from the network and had to make a new psql shell. If I look in pg_stat_activity, I see that my query is still running. Can I connect to that query and get its output?
Asked by davidvgalbraith (121 rep)
Sep 12, 2016, 04:54 PM
Last activity: Jun 27, 2025, 08:06 AM