What I understand is that that you want to insert to the database,
moreover leaving the program running without attention. I recomend that
you use the at command. I use it for inserting during the night, even
turning off my laptop and the process still run even if the parent --
the putty session -- dies.
bash$at -m now /~/script
>ctrl + d --aply
bash$
you can turn off your laptop and the script run as a background job
openning a different bash session "internally"
Hope can help you
Eduardo
Kumar S wrote:
>Hello all,
> I am using a laptop and some of my .sql files with
>insert statements (300K insert statements) take very
>long time.
>
>I user
>
>database=> \i /home/user/../../../insert.sql
>
>this takes a long time. and if i shutdown my laptop,
>the server connection is lost . I am using Putty to
>connect to my server.
>
>Could any one help to setup a background job where I
>can start a job and forget until the next morning to
>see that the job is finished.
>
>Should it be something like the following:
>myserver$ psql -d mydb -d node2|\i /insert.sql &>
>
>this command is WRONG. Can any one help me with a
>correct one.
>
>Thank you
>K
>
>________________________________________________________________________
>Yahoo! India Matrimony: Find your partner online. http://yahoo.shaadi.com/india-matrimony/
>
>---------------------------(end of broadcast)---------------------------
>TIP 7: don't forget to increase your free space map settings
>
>
>
--
If I have seen further it is by standing on the shoulders of the giants
Isaac Newton