From: | Sean Chittenden <sean(at)chittenden(dot)org> |
---|---|
To: | Christopher Smith <christopherl_smith(at)yahoo(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: asynchronous psql command options? |
Date: | 2003-01-16 21:23:08 |
Message-ID: | 20030116212308.GC34165@perrin.int.nxad.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Tim Lynch | 2003-01-16 22:15:22 | OT: seeking query help, where? |
Previous Message | Tom Lane | 2003-01-16 21:19:38 | Re: asynchronous psql command options? |