> recently, my dsl provider went out of business, currently, I am
> using dial-up and I need to build indexes of a very large database
> table. this take a few hours...
>
> i used psql via ssh on dial-up and closed the ssh client. I logged
> in again and it showed that the postmater process was still
> running.. I thought that the index building process would continue
> 'til completion.
>
> however, this morning no indexes were built. Is it possible to send
> commands via psql asynchronous. Does anyone know why the index
> building process stopped?
If you use screen(1) and detach from it, then reattach to it at a
later date, there may be some diagnostic output sent to the screen.
# Start work
ssh....
screen -d -R -S psql
psql...
Ctrl-a d
exit
# Come back a few hours later:
ssh....
screen -d -R -S psql
[check to see if there's any output]
exit # the screen session
exit # exit ssh
--
Sean Chittenden
