Next: Lock partitions
From: Dave Cramer on 16 Nov 2005 16:30
Other than backing up $PGDATA
and running pg_resetxlog

Is there any advice ?

Dave

Nov 16 18:03:30 dx1-ptr postgres[22337]: [6-2] '2005-11-16 17:47:31'
Nov 16 18:03:32 dx1-ptr postgres[29335]: [2-1] LOG: received fast
shutdown request
Nov 16 18:03:32 dx1-ptr postgres[29335]: [3-1] LOG: aborting any
active transactions
Nov 16 18:03:32 dx1-ptr postgres[22337]: [7-1] FATAL: terminating
connection due to administrator command
Nov 16 18:03:32 dx1-ptr postgres[32704]: [3-1] FATAL: terminating
connection due to administrator command
Nov 16 18:03:32 dx1-ptr postgres[15245]: [3-1] FATAL: terminating
connection due to administrator command
Nov 16 18:03:32 dx1-ptr postgres[3714]: [3-1] FATAL: terminating
connection due to administrator command
Nov 16 18:03:32 dx1-ptr postgres[23410]: [4-1] LOG: shutting down
Nov 16 18:03:35 dx1-ptr postgres[23410]: [5-1] LOG: database system
is shut down
Nov 16 18:21:18 dx1-ptr postgres[10884]: [1-1] LOG: could not create
IPv6 socket: Address family not supported by protocol
Nov 16 18:21:18 dx1-ptr postgres[10960]: [2-1] LOG: database system
was shut down at 2005-11-16 18:03:35 GMT
Nov 16 18:21:18 dx1-ptr postgres[10960]: [3-1] LOG: could not open
file "/data/db/pgdata/pg_xlog/00000082000000E2" (log file 130, segm
ent 226): No such file or directory
Nov 16 18:21:18 dx1-ptr postgres[10960]: [4-1] LOG: invalid primary
checkpoint record
Nov 16 18:21:18 dx1-ptr postgres[10960]: [5-1] LOG: could not open
file "/data/db/pgdata/pg_xlog/00000082000000E2" (log file 130, segm
ent 226): No such file or directory
Nov 16 18:21:18 dx1-ptr postgres[10960]: [6-1] LOG: invalid
secondary checkpoint record
Nov 16 18:21:18 dx1-ptr postgres[10960]: [7-1] PANIC: could not
locate a valid checkpoint record
Nov 16 18:21:18 dx1-ptr postgres[10884]: [2-1] LOG: startup process
(PID 10960) was terminated by signal 6
Nov 16 18:21:18 dx1-ptr postgres[10884]: [3-1] LOG: aborting startup
due to startup process failure
Nov 16 18:28:06 dx1-ptr postgres[15001]: [1-1] LOG: could not create
IPv6 socket: Address family not supported by protocol
Nov 16 18:28:06 dx1-ptr postgres[15005]: [2-1] LOG: database system
was shut down at 2005-11-16 18:03:35 GMT
Nov 16 18:28:06 dx1-ptr postgres[15005]: [3-1] LOG: could not open
file "/data/db/pgdata/pg_xlog/00000082000000E2" (log file 130, segm
ent 226): No such file or directory


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

 | 
Pages: 1
Next: Lock partitions