From: | Kumar S <ps_postgres(at)yahoo(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | background jobs |
Date: | 2005-03-06 05:28:57 |
Message-ID: | 20050306052857.29700.qmail@web51408.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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/
From | Date | Subject | |
---|---|---|---|
Next Message | David | 2005-03-06 07:07:54 | Getting started - Interfacing questions |
Previous Message | John Phillips | 2005-03-05 20:52:03 | Need some install help .....pgsql8.0.1 on Suse Linux 9.2 pro |