> 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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
