LOG: 00000: database system was shut down at 2007-01-02 12:16:33 CST LOCATION: StartupXLOG, xlog.c:4672 LOG: 00000: checkpoint record is at 0/130E42C LOCATION: StartupXLOG, xlog.c:4762 LOG: 00000: redo record is at 0/130E42C; undo record is at 0/0; shutdown TRUE LOCATION: StartupXLOG, xlog.c:4789 LOG: 00000: next transaction ID: 0/59568; next OID: 32768 LOCATION: StartupXLOG, xlog.c:4793 LOG: 00000: next MultiXactId: 1; next MultiXactOffset: 0 LOCATION: StartupXLOG, xlog.c:4796 LOG: 00000: database system is ready LOCATION: StartupXLOG, xlog.c:5188 DEBUG: 00000: transaction ID wrap limit is 2147484171, limited by database "postgres" LOCATION: SetTransactionIdLimit, varsup.c:278 DEBUG: 00000: proc_exit(0) LOCATION: proc_exit, ipc.c:94 DEBUG: 00000: shmem_exit(0) LOCATION: shmem_exit, ipc.c:125 DEBUG: 00000: exit(0) LOCATION: proc_exit, ipc.c:112 DEBUG: 00000: reaping dead processes LOCATION: reaper, postmaster.c:2010 DEBUG: 00000: forked new backend, pid=32688 socket=7 LOCATION: BackendStartup, postmaster.c:2573 DEBUG: 00000: Ident protocol identifies remote user as "postgres" LOCATION: authident, hba.c:1615 DEBUG: 00000: postmaster child[32688]: starting with ( LOCATION: BackendRun, postmaster.c:2917 DEBUG: 00000: postgres LOCATION: BackendRun, postmaster.c:2920 DEBUG: 00000: -v196608 LOCATION: BackendRun, postmaster.c:2920 DEBUG: 00000: -y LOCATION: BackendRun, postmaster.c:2920 DEBUG: 00000: test LOCATION: BackendRun, postmaster.c:2920 DEBUG: 00000: ) LOCATION: BackendRun, postmaster.c:2922 DEBUG: 00000: InitPostgres LOCATION: PostgresMain, postgres.c:3137 DEBUG: 00000: StartTransaction LOCATION: ShowTransactionState, xact.c:3985 DEBUG: 00000: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 59568/1/0, nestlvl: 1, children: <> LOCATION: ShowTransactionStateRec, xact.c:4010 DEBUG: 00000: CommitTransaction LOCATION: ShowTransactionState, xact.c:3985 DEBUG: 00000: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 59568/1/0, nestlvl: 1, children: <> LOCATION: ShowTransactionStateRec, xact.c:4010 DEBUG: 00000: StartTransactionCommand LOCATION: start_xact_command, postgres.c:2200 STATEMENT: SELECT f.id, f.category_id, f.status, f.moderated, f.topics, f.posts, f.forum, f.last_post, f.system_name, f.description, p.last_post_date, p.last_post_time, p.topic FROM "crash"."forum" f LEFT JOIN "crash"."forum_post" p ON ( f.last_post = p.id ) WHERE ( f.status = 1 ) ORDER BY f.forum, f.id LIMIT ALL OFFSET 0; DEBUG: 00000: StartTransaction LOCATION: ShowTransactionState, xact.c:3985 STATEMENT: SELECT f.id, f.category_id, f.status, f.moderated, f.topics, f.posts, f.forum, f.last_post, f.system_name, f.description, p.last_post_date, p.last_post_time, p.topic FROM "crash"."forum" f LEFT JOIN "crash"."forum_post" p ON ( f.last_post = p.id ) WHERE ( f.status = 1 ) ORDER BY f.forum, f.id LIMIT ALL OFFSET 0; DEBUG: 00000: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 59569/1/0, nestlvl: 1, children: <> LOCATION: ShowTransactionStateRec, xact.c:4010 STATEMENT: SELECT f.id, f.category_id, f.status, f.moderated, f.topics, f.posts, f.forum, f.last_post, f.system_name, f.description, p.last_post_date, p.last_post_time, p.topic FROM "crash"."forum" f LEFT JOIN "crash"."forum_post" p ON ( f.last_post = p.id ) WHERE ( f.status = 1 ) ORDER BY f.forum, f.id LIMIT ALL OFFSET 0; LOG: 00000: statement: SELECT f.id, f.category_id, f.status, f.moderated, f.topics, f.posts, f.forum, f.last_post, f.system_name, f.description, p.last_post_date, p.last_post_time, p.topic FROM "crash"."forum" f LEFT JOIN "crash"."forum_post" p ON ( f.last_post = p.id ) WHERE ( f.status = 1 ) ORDER BY f.forum, f.id LIMIT ALL OFFSET 0; LOCATION: exec_simple_query, postgres.c:811 STATEMENT: SELECT f.id, f.category_id, f.status, f.moderated, f.topics, f.posts, f.forum, f.last_post, f.system_name, f.description, p.last_post_date, p.last_post_time, p.topic FROM "crash"."forum" f LEFT JOIN "crash"."forum_post" p ON ( f.last_post = p.id ) WHERE ( f.status = 1 ) ORDER BY f.forum, f.id LIMIT ALL OFFSET 0; DEBUG: 00000: reaping dead processes LOCATION: reaper, postmaster.c:2010 DEBUG: 00000: server process (PID 32688) was terminated by signal 11 LOCATION: LogChildExit, postmaster.c:2425 LOG: 00000: server process (PID 32688) was terminated by signal 11 LOCATION: LogChildExit, postmaster.c:2425 LOG: 00000: terminating any other active server processes LOCATION: HandleChildCrash, postmaster.c:2310 DEBUG: 00000: sending SIGQUIT to process 32680 LOCATION: HandleChildCrash, postmaster.c:2361 DEBUG: 00000: sending SIGQUIT to process 32681 LOCATION: HandleChildCrash, postmaster.c:2395 LOG: 00000: all server processes terminated; reinitializing LOCATION: reaper, postmaster.c:2212 DEBUG: 00000: shmem_exit(0) LOCATION: shmem_exit, ipc.c:125 DEBUG: 00000: invoking IpcMemoryCreate(size=29237248) LOCATION: CreateSharedMemoryAndSemaphores, ipci.c:124 DEBUG: 00000: reaping dead processes LOCATION: reaper, postmaster.c:2010 LOG: 00000: database system was interrupted at 2007-01-02 12:16:41 CST LOCATION: StartupXLOG, xlog.c:4692 FATAL: 57P03: the database system is starting up LOCATION: ProcessStartupPacket, postmaster.c:1573 LOG: 00000: checkpoint record is at 0/130E42C LOCATION: StartupXLOG, xlog.c:4762 LOG: 00000: redo record is at 0/130E42C; undo record is at 0/0; shutdown TRUE LOCATION: StartupXLOG, xlog.c:4789 LOG: 00000: next transaction ID: 0/59568; next OID: 32768 LOCATION: StartupXLOG, xlog.c:4793 LOG: 00000: next MultiXactId: 1; next MultiXactOffset: 0 LOCATION: StartupXLOG, xlog.c:4796 LOG: 00000: database system was not properly shut down; automatic recovery in progress LOCATION: StartupXLOG, xlog.c:4863 DEBUG: 00000: proc_exit(1) LOCATION: proc_exit, ipc.c:94 DEBUG: 00000: shmem_exit(1) LOCATION: shmem_exit, ipc.c:125 DEBUG: 00000: exit(1) LOCATION: proc_exit, ipc.c:112 DEBUG: 00000: forked new backend, pid=32691 socket=7 LOCATION: BackendStartup, postmaster.c:2573 DEBUG: 00000: reaping dead processes LOCATION: reaper, postmaster.c:2010 DEBUG: 00000: server process (PID 32691) exited with exit code 1 LOCATION: LogChildExit, postmaster.c:2417 LOG: 00000: record with zero length at 0/130E474 LOCATION: ReadRecord, xlog.c:3031 LOG: 00000: redo is not required LOCATION: StartupXLOG, xlog.c:5002 LOG: 00000: database system is ready LOCATION: StartupXLOG, xlog.c:5188 DEBUG: 00000: transaction ID wrap limit is 2147484171, limited by database "postgres" LOCATION: SetTransactionIdLimit, varsup.c:278 DEBUG: 00000: proc_exit(0) LOCATION: proc_exit, ipc.c:94 DEBUG: 00000: shmem_exit(0) LOCATION: shmem_exit, ipc.c:125 DEBUG: 00000: exit(0) LOCATION: proc_exit, ipc.c:112 DEBUG: 00000: reaping dead processes LOCATION: reaper, postmaster.c:2010