On Saturday 01 February 2003 14:00, Tom Lane wrote:
> What was the query it failed on, exactly? That last page it read
> seems to be an empty index page --- it should have moved on to the
> next index page, I'd think, rather than doing anything that could
> hang up.
Here's the log. As you can see, nothing was logged after the COPY command.
It's possible that the file was corrupted. I will do a new test from scratch
now that I am not switching speeds.
--
D'Arcy J.M. Cain <darcy@{druid|vex}.net> | Democracy is three wolves
http://www.druid.net/darcy/ | and a sheep voting on
+1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.
Feb 1 04:21:17 matrix pg_test[7432]: [3] DEBUG: connection: host=192.168.10.75 user=darcy database=cert
Feb 1 04:21:17 matrix pg_test[7432]: [4] DEBUG: InitPostgres
Feb 1 04:21:17 matrix pg_test[7432]: [5] DEBUG: StartTransactionCommand
Feb 1 04:21:17 matrix pg_test[7432]: [6] DEBUG: query: select getdatabaseencoding()
Feb 1 04:21:17 matrix pg_test[7432]: [7] DEBUG: ProcessQuery
Feb 1 04:21:17 matrix pg_test[7432]: [8] DEBUG: CommitTransactionCommand
Feb 1 04:21:17 matrix pg_test[7432]: [9] DEBUG: StartTransactionCommand
Feb 1 04:21:17 matrix pg_test[7432]: [10] DEBUG: query: SELECT usesuper FROM pg_user WHERE usename = 'darcy'
Feb 1 04:21:17 matrix pg_test[7432]: [11] DEBUG: ProcessQuery
Feb 1 04:21:17 matrix pg_test[7432]: [12] DEBUG: CommitTransactionCommand
Feb 1 04:21:17 matrix pg_test[7432]: [13] DEBUG: StartTransactionCommand
Feb 1 04:21:17 matrix pg_test[7432]: [14] DEBUG: query: UPDATE "pg_class" SET "reltriggers" = 0 WHERE "relname" = 'certificate';
Feb 1 04:21:17 matrix pg_test[7432]: [15] DEBUG: ProcessQuery
Feb 1 04:21:17 matrix pg_test[7432]: [16] DEBUG: CommitTransactionCommand
Feb 1 04:21:17 matrix pg_test[7432]: [17] DEBUG: StartTransactionCommand
Feb 1 04:21:17 matrix pg_test[7432]: [18] DEBUG: query: COPY "certificate" FROM stdin;
Feb 1 04:21:17 matrix pg_test[7432]: [19] DEBUG: ProcessUtility: COPY "certificate" FROM stdin;
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
