I was using interactive psql to run a reindex on one of our databases. Unfortunately, the ssh connection dropped while the reindex was still running and I had foolishly not put psql inside a screen window (I didn't realize how long it took!)
Once I was able to login again to the machine, I ran
ps aux | grep REINDEX
and the output seemed to indicate that the reindex was still running:
postgres 6180 99.9 0.0 774960 4804 ? Rs Jun27 3022:02 postgres: postgres my_db_name [local] REINDEX
What is the expected behaviour of postgres in this situation? Will it continue to run the reindex to completion?
Also, is there any way to re-connect to psql in such a way that I can continue seeing the in-progress output from the reindex?