yes, I altered the php.ini file in /etc/php5/apache2/ directory in order to
accept huge files.
The uploading has been completed and the transactions started.
I can now see the transactions using either: ps aux | grep postgres (via
command line)
or the solution David Johnston sugested.
Thank you
its a huge file with such queries:
BEGIN;
INSERT INTO traces VALUES (.);
.
.
.
COMMIT;
Anyway, I managed to see that the transactions still occure like David
Johnston sugested. And luckily the browser is alive now after one hour that
it had been freezed...
thank you very much for the reply
i execute it periodically and sometimes there is a transaction and other
times it's idle:
INSERT INTO traces VALUES (.)
or
in transaction
So it's still running.. even thought there is some idle time.
Thank you very much!
On Thu, Aug 8, 2013 at 5:46 PM, David Johnston wrote:
> dafNi w
2013/8/8 dafNi zaf :
> Hello to everybody,
>
> I started to upload (via phpPgAdmin) to a local server a huge file (20GB) in
> order to fill up a database.
20GB is a lot to be uploading from a browser, even in this day and age.
Is the web server configured to accept uploads of that size?
--
Sen
dafNi wrote
> Should I assume that the transactions keep running?
Never assume...or at least try and verify those assumptions when possible.
To verify this assumption:
Connect to the DB directly as a super-user and run this (or something
similar):
SELECT procpid, current_query, client_addr, xac
On 8 August 2013 16:33, 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 o
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 transacti
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 uplo
