On 8 August 2013 16:33, dafNi zaf <dza...@gmail.com> wrote: > > Hello to everybody, > > I started to upload (via phpPgAdmin) to a local server a huge file (20GB) > in > order to fill up a database. > The uploding completed and the transactions started. But unfortunately, my > browser crashed/freezed in the middle of the transactions. > > I wanted to know, given that the uploading of the file was completed, will > the > transactions keep executing on server?? > > Before the browser crashed there was a process that consumed 23.6% of the > CPU for the transactions and now, I see the same process with approximately > the same percentage. > > Should I assume that the transactions keep running? > > I am trying to avoid uploading the file all over again because it has > already been > running for 5 hours. >
There is a chance that the database server is just still processing your request and that it will only figure out that there's a client error once it reaches the end of that 20GB file, after which the client returns an error and the database rolls back the transaction. Depending on how phpPgAdmin/PHP were implemented, that's not necessarily what'll happen though, so you might just get lucky and the transaction commits. Hard to tell, I know nothing about the internals of phpPgAdmin. What kind of file is it anyway? A database dump perhaps? -- If you can't see the forest for the trees, Cut the trees and you'll see there is no forest.
