[Babase] Re: File upload in progress

Karl O. Pinc kop at meme.com
Thu Mar 26 17:44:26 EDT 2009


On 03/26/2009 04:12:01 PM, Catherine Markham wrote:
> Shoot... it is still running, I guess.  I'm just now getting back  
> after a
> meeting so left things to run while away, but unfortunately did not  
> come
> back to a finished table.  Will changing the elapsed time limits  
> maybe give
> hope that things will work on a future try?

Looks like it's still running.  Unless it's one of those things
that runs for a while and then aborts and then had to run
equally long to undo what was done.

Oops, it finished as I wrote this.

Does it look like it's done at your end?

It seems like it took a good long time just to upload
over the network.  After that I'm not sure what's taking
so long.  My suspicion is that you'll get the best
performance by using the COPY FROM command.
http://www.postgresql.org/docs/8.1/static/sql-copy.html

You would make a file with content that looks something like:
COPY mytablename (column1, column2, columnetc) FROM STDIN CSV;
yourdatagoeshere
\.

Then use the ppa sql page which has a "upload sql
from a file" option that you can use to upload
the file.

(Of course I realize that one of your problems is
that you don't have the tools to make changes to
the files because they are so big, so adding a
line to the beginning and end of the file could
be a problem.)

> 
> Karl O. Pinc wrote:
>> 
>> On 03/26/2009 02:06:56 PM, Catherine Markham wrote:
>>> Hi Karl,
>>> 
>>> I had the same PC-equivalent of a blank stare when trying to upload  
>>> the 3
>>> gb file from campus as I did from home - nothing happened to even  
>>> give an
>>> indication the the computer recognized my request.  Instead, I am  
>>> now
>>> trying the upload of the 750 mb file and got recognition that it was
>>> trying, but am still waiting to see if it'll go through (been about  
>>> 20
>>> minutes or so so far).
>>> 
>>> I'll leave it running for a while and see if things eventually  
>>> click in...
>> 
>> Given the amount of time this is taking I'm thinking that I may
>> need to increase the maximum elapsed time limits that are in place.
>> 
>> Let me know what happens.
>> 
>> Karl <kop at meme.com>
>> Free Software:  "You don't pay back, you pay forward."
>>                  -- Robert A. Heinlein

Karl <kop at meme.com>
Free Software:  "You don't pay back, you pay forward."
                  -- Robert A. Heinlein



More information about the Babase mailing list