Re: DB transactions when browser freezes

From: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
To: dafNi zaf <dzaf88(at)gmail(dot)com>
Cc: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: DB transactions when browser freezes
Date: 2013-08-08 14:40:14
Message-ID: 5203ADCE.6070607@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 08/08/2013 07:33 AM, dafNi zaf 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.

tail the server log and verify.

>
>
> Thank you in advance!!
> dafNi

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alban Hertroys 2013-08-08 14:46:06 Re: DB transactions when browser freezes
Previous Message Glyn Astill 2013-08-08 14:36:38 Re: How to find transaction ID