| From: | John R Pierce <pierce(at)hogranch(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: tracking scripts... |
| Date: | 2013-11-26 18:24:27 |
| Message-ID: | 5294E75B.1070307@hogranch.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 11/26/2013 9:24 AM, Joey Quinn wrote:
> When I ran that command (select * from pg_stat_activity"), it returned
> the first six lines of the scripts. I'm fairly sure it has gotten a
> bit beyond that (been running over 24 hours now, and the size has
> increased about 300 GB). Am I missing something for it to tell me what
> the last line processed was?
that means your GUI lobbed the entire file at postgres in a single
PQexec call, so its all being executed as a single statement.
psql -f "filename.sql" dbname would have processed the queries one at
a time.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2013-11-26 18:31:53 | Re: Any advantage of using SSL with a certificate of authority? |
| Previous Message | Jesus Rafael Sanchez Medrano | 2013-11-26 18:24:01 | Any advantage of using SSL with a certificate of authority? |