Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL]COPY still running

From: "J(dot) Roeleveld" <j(dot)roeleveld(at)softhome(dot)net>
To: "Arnaud FLORENT" <aflorent(at)iris-tech(dot)fr>
Cc: "PostgreSQL general ML" <pgsql-general(at)hub(dot)org>
Subject: Re: [GENERAL]COPY still running
Date: 2000-01-26 10:36:52
Message-ID: 00a101bf67e9$43d47060$ (view raw, whole thread or download thread mbox)
Lists: pgsql-general
> I had a similar thing once, while compiling a program, it took the
> 28 hours to complete. (on a P200)
> My best guess is is that it's still running, make a quick check that the
> main
> process is still running. The action you are doing requires not just alot
> CPU-power, but also a lot of HD-read and writes.

the postmaster is still running and the database grows (it is not very fast
it grows and is now 60Mb large......)

glad to hear, it's not crashed... :)

is thare a way to stop the copy command wihtout crashing the database?

It depends, if you issued the command within 'psql' then yes, by pressing
however, this will cause the entire transaction to be reversed, and will
likely take the same amount of time, my advise would still be to let this
command to finish normally...

with kind regards,

Joost Roeleveld

In response to

pgsql-general by date

Next:From: Sevo StilleDate: 2000-01-26 10:41:13
Subject: Re: [GENERAL] Re: server hardware recommendations
Previous:From: Alex GuryanowDate: 2000-01-26 10:24:21
Subject: pqReadData() error

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group