background jobs

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/

Responses

Browse pgsql-novice by date

  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