"Paul B. Anderson" <paul@pnlassociates.com> writes:
> I'm trying to move data from an Oracle database into postgresql 7.4.3.
> I have a program that is extracting data and writing it to an sql script
> as a long series of inserts (20,000 at a time). When I run these
> scripts using psql, I occassionally get a problem that is reported as
> ERROR: canceling query due to user request
> And then it won't clear. If I quit psql and start it again, every sql
> statement on that database gives this error after 30 seconds (approx) of
> hanging.
It sounds to me like you are starting the postmaster under finite ulimit
settings --- could be either CPU or filesize limits.
regards, tom lane