--0-1881414252-1164074386=:62094
Content-Type: text/plain; charset=ascii
Content-Transfer-Encoding: quoted-printable
my db server has crashed=0Ai m using postgres=0Awhat happened is when reind=
exing was happening=0Apostgres got shut down=0Anow i m unable to start can =
you give me any pointers=0A=0A=0A=0ACRON running vacuum on a database=0Aand=
pg_ctl stop -m fast got called=0A=0ANow I m unalbe ot run the database, th=
e following is the error when I run =0Apg_ctl -D /work/database start=0ALOG=
: logger shutting down=0A=0Aon running tail -n 30 postgresql-Mon.log=0A=0A=
=0ALOG: database system was not properly shut down; automatic recovery in=
progress=0ALOG: redo starts at 8A/8F00833C=0APANIC: block 1100 unfound=
=0ALOG: startup process (PID 31612) was terminated by signal 6=0A=0ALOG: =
aborting startup due to startup process failure=0ALOG: logger shutting dow=
n=0ALOG: database system was interrupted while in recovery at 2006-11-20 1=
6:56:18 PST=0AHINT: This probably means that some data is corrupted and yo=
u will have to use the last backup for recovery.=0A=0ALOG: checkpoint reco=
rd is at 8A/8F01D6D4=0ALOG: redo record is at 8A/8F00833C; undo record is =
at 0/0; shutdown FALSE=0ALOG: next transaction ID: 32782967; next OID: 249=
9839=0ALOG: next MultiXactId: 972; next MultiXactOffset: 2099=0A=0ALOG: d=
atabase system was not properly shut down; automatic recovery in progress=
=0ALOG: redo starts at 8A/8F00833C=0APANIC: block 1100 unfound=0ALOG: st=
artup process (PID 31846) was terminated by signal 6=0ALOG: aborting start=
up due to startup process failure=0A=0ALOG: logger shutting down=0ALOG: d=
atabase system was interrupted while in recovery at 2006-11-20 17:12:21 PST=
=0AHINT: This probably means that some data is corrupted and you will have=
to use the last backup for recovery.=0A=0ALOG: checkpoint record is at 8A=
/8F01D6D4=0ALOG: redo record is at 8A/8F00833C; undo record is at 0/0; shu=
tdown FALSE=0ALOG: next transaction ID: 32782967; next OID: 2499839=0ALOG:=
next MultiXactId: 972; next MultiXactOffset: 2099=0A=0ALOG: database sys=
tem was not properly shut down; automatic recovery in progress=0ALOG: redo=
starts at 8A/8F00833C=0APANIC: block 1100 unfound=0ALOG: startup process=
(PID 32000) was terminated by signal 6=0ALOG: aborting startup due to sta=
rtup process failure=0A=0ALOG: logger shutting down=0A=0Apg_controldata =
=0Apg_control version number: 812=0ACatalog version number: =
200510211=0ADatabase system identifier: 495219679494850=
0735=0A=0ADatabase cluster state: in recovery=0Apg_control la=
st modified: Mon 20 Nov 2006 05:14:36 PM PST=0ACurrent log file=
ID: 138=0ANext log file segment: 170=0A=0A=
Latest checkpoint location: 8A/8F01D6D4=0A=0APrior checkpoint loc=
ation: 8A/8C01924C=0ALatest checkpoint's REDO location: 8A/8F=
00833C=0ALatest checkpoint's UNDO location: 0/0=0ALatest checkpoint's Ti=
meLineID: 1=0ALatest checkpoint's NextXID: 32782967=0A=0ALat=
est checkpoint's NextOID: 2499839=0ALatest checkpoint's NextMultiX=
actId: 972=0ALatest checkpoint's NextMultiOffset: 2099=0ATime of latest c=
heckpoint: Mon 20 Nov 2006 12:53:56 PM PST=0AMaximum data alignm=
ent: 4=0A=0ADatabase block size: 8192=0ABloc=
ks per segment of large relation: 131072=0ABytes per WAL segment: =
16777216=0AMaximum length of identifiers: 64=0AMaximum columns=
in an index: 32=0A=0ADate/time type storage: floati=
ng-point numbers=0AMaximum length of locale name: 128=0ALC_COLLATE: =
en_US.UTF-8=0ALC_CTYPE: =
en_US.UTF-8=0A=0A=0A=0A=0AI tried running pg_resetxlog everything got lo=
st, so restoring the copied database folder=0A=0AI got pointers to looking =
at =0A=0Apg_filedump and I could not find out how to specify options to fil=
edump=0APlease help me out=0Amy data bases is like 1gigabyte, panicking=0At=
hanks =0A=0A=0A=0A=0A =0A__________________________________________________=
__________________________________=0ADo you Yahoo!?=0AEveryone is raving ab=
out the all-new Yahoo! Mail beta.=0Ahttp://new.mail.yahoo.com
--0-1881414252-1164074386=:62094
Content-Type: text/html; charset=ascii
Content-Transfer-Encoding: quoted-printable
<html><head><style type=3D"text/css"><!-- DIV {margin:0px;} --></style></he=
ad><body><div style=3D"font-family:arial, helvetica, sans-serif;font-size:1=
4pt"><span class=3D"e" id=3D"q_10f0827579c3613d_1"><span chatdir=3D"2"><div=
class=3D"bz_msg_cont" chatindex=3D"1F54E1AEEDC1BFE71">my db server has cra=
shed</div><div class=3D"bz_msg_cont" chatindex=3D"1F54E1AEEDC1BFE72">i m us=
ing postgres</div><div class=3D"bz_msg_cont" chatindex=3D"1F54E1AEEDC1BFE73=
">what happened is when reindexing was happening</div><div class=3D"bz_msg_=
cont" chatindex=3D"1F54E1AEEDC1BFE74">postgres got shut down</div><div clas=
s=3D"bz_msg_cont" chatindex=3D"1F54E1AEEDC1BFE75">now i m unable to start c=
an you give me any pointers</div></span><br>=0A<span style=3D"font-weight: =
bold;">=0ACRON </span>running vacuum on a database<br>and <span style=3D"fo=
nt-weight: bold;">pg_ctl stop -m fast</span> got called<br><br>Now I m unal=
be ot run the database, the following is the error when I run =0A<span styl=
e=3D"font-weight: bold;">pg_ctl -D /work/database start</span><br><span sty=
le=3D"font-weight: bold;">LOG: logger shutting down</span><br><br>on =
running <span style=3D"font-weight: bold;">tail -n 30 postgresql-Mon.log=0A=
=0A </span><br>LOG: database system was not properly shut down; autom=
atic recovery in progress<br>LOG: redo starts at 8A/8F00833C<br>PANIC=
: block 1100 unfound<br>LOG: startup process (PID 31612) was te=
rminated by signal 6=0A<br>LOG: aborting startup due to startup proce=
ss failure<br>LOG: logger shutting down<br>LOG: database system=
was interrupted while in recovery at 2006-11-20 16:56:18 PST<br>HINT: =
; This probably means that some data is corrupted and you will have to use =
the last backup for recovery.=0A<br>LOG: checkpoint record is at 8A/8=
F01D6D4<br>LOG: redo record is at 8A/8F00833C; undo record is at 0/0;=
shutdown FALSE<br>LOG: next transaction ID: 32782967; next OID: 2499=
839<br>LOG: next MultiXactId: 972; next MultiXactOffset: 2099=0A<br>L=
OG: database system was not properly shut down; automatic recovery in=
progress<br>LOG: redo starts at 8A/8F00833C<br>PANIC: block 11=
00 unfound<br>LOG: startup process (PID 31846) was terminated by sign=
al 6<br>LOG: aborting startup due to startup process failure=0A<br>LO=
G: logger shutting down<br>LOG: database system was interrupted=
while in recovery at 2006-11-20 17:12:21 PST<br>HINT: This probably =
means that some data is corrupted and you will have to use the last backup =
for recovery.=0A<br>LOG: checkpoint record is at 8A/8F01D6D4<br>LOG:&=
nbsp; redo record is at 8A/8F00833C; undo record is at 0/0; shutdown FALSE<=
br>LOG: next transaction ID: 32782967; next OID: 2499839<br>LOG: =
; next MultiXactId: 972; next MultiXactOffset: 2099=0A<br>LOG: databa=
se system was not properly shut down; automatic recovery in progress<br>LOG=
: redo starts at 8A/8F00833C<br>PANIC: block 1100 unfound<br>LO=
G: startup process (PID 32000) was terminated by signal 6<br>LOG:&nbs=
p; aborting startup due to startup process failure=0A<br>LOG: logger =
shutting down<br><br><span style=3D"font-weight: bold;">pg_controldata </sp=
an><br>pg_control version number: =
812<br>Catalog version number: &n=
bsp; 200510211<=
br>Database system identifier: &nb=
sp; 4952196794948500735=0A<br>Database cluster state: &nbs=
p; =
in recovery<br>pg_control last modified: =
; Mon 20 Nov 2006 05:14:36 PM PST<br>Cu=
rrent log file ID: &nb=
sp; 138<br>Next log file segment:=
&nb=
sp; 170<br>=0ALatest checkpoint location: &nbs=
p; 8A/8F01D6D4=0A<br>Prior checkpoint l=
ocation: =
8A/8C01924C<br>Latest checkpoint's REDO location: 8A/8F00=
833C<br>Latest checkpoint's UNDO location: 0/0<br>Latest =
checkpoint's TimeLineID: 1<br>Latest ch=
eckpoint's NextXID: 3=
2782967=0A<br>Latest checkpoint's NextOID: &nb=
sp; 2499839<br>Latest checkpoint's NextMultiXactId: =
972<br>Latest checkpoint's NextMultiOffset: 2099<br>Time of latest c=
heckpoint: =
; Mon 20 Nov 2006 12:53:56 PM PST<br>Maximum data alignment: &nb=
sp; 4=0A<=
br>Database block size: &nbs=
p; 8192<br>Blocks per segme=
nt of large relation: 131072<br>Bytes per WAL segment: &nb=
sp; 16777=
216<br>Maximum length of identifiers: &n=
bsp; 64<br>Maximum columns in an index: =
32=0A<br>Date/time type storage: =
floating-point=
numbers<br>Maximum length of locale name: &nb=
sp; 128<br>LC_COLLATE: =
; <wbr>&nb=
sp; en_US.UTF-8<br>LC_CTYPE: =
; &n=
bsp; <wbr> =
en_US.UTF-8<br><br>=0A=0A<br>I tried running <span style=3D"fo=
nt-weight: bold;">pg_resetxlog</span> everything got lost, so restoring the=
copied <span style=3D"font-weight: bold;">database</span> folder<br><br>I =
got pointers to looking at <span style=3D"font-weight: bold;">=0A=0Apg_file=
dump</span> and I could not find out how to specify options to filedump<br>=
Please help me out<br>my data bases is like 1gigabyte, panicking<br>thanks<=
/span><div> </div><br></div><br>=0A=0A<font color=3D"666666"><font siz=
e=3D"2"><hr size=3D1>Sponsored Link</font></font><br><br> =0A<a href=3D"h=
ttps://www2.nextag.com/goto.jsp?product=3D100000035&url=3D%2 fst.jsp&tm=3Dy&=
search=3Db_rate150k&s=3D3968&p=3D5035&disc=3Dy&vers=3D722">M ortgage rates a=
s low as 4.625% - $150,000 loan for $579 a month. Intro-*Terms</a></body></=
html>
--0-1881414252-1164074386=:62094--
