PostgreSQL Question!

[Kekes Stamatis]

V13 wrote:

>On Wednesday 04 September 2002 15:01, Kekes Stamatis wrote:
>  
>
>> Se ena RH 7.0 me Postgresql 7.2 otan pao na ksekiniso ti vasi me to
>>init script den mou ksekinaei. Apo oso dokimasa na sikoso ti vasi me to
>>xeri otan tin ksekinaga mou evgaze ta eksis:
>>DEBUG:  database system shutdown was interrupted at 2002-09-04 14:24:34
>>EEST DEBUG:  ReadRecord: invalid resource manager id 27 at 1/5EECC9D4
>>DEBUG:  invalid primary checkpoint record
>>DEBUG:  invalid resource manager id in secondary checkpoint record
>>FATAL 2:  unable to locate a valid checkpoint record
>>DEBUG:  startup process (pid 6424) exited with exit code 2
>>DEBUG:  aborting startup due to startup process failure
>>
>>Exei kaneis kamia idea ti mporei na ftaiei ??
>>    
>>
>
>Mipos eixes palia basi kai ekanes egkatastasi nea postgre?
>
Oxi milame oti eixa men palia vasi alla ekana upgrade etsi opos eprepe. 
Diladi dump oles tis vaseis spo tin palia version, meta egkatastasi tis 
kainourias, kanourio initdb kai meta restore apo to dump arxeio alla 
ayto egine prin kana mina toulaxiston.

> An oxi tote exeis 
>problima... Isos an 'sbiseis' (apla metefere ta alloy) ta arxeia apo ton 
>katalogo pg_xlog na ksekinisei. 
>
Oxi tote mou evgaze alla perierga minymata. Telika akoma kato einia i 
vasi. Vrika ena util pou legetap pgfsck nato dokimaso sde mia kopia 
mipos kai doulepsei.

>AN ksekinisei, tote kane min kaneis kamia 
>allagi. Apla prospathise na kaneis ena dump tis basis soy. Stin synexeia 
>sbisimo, initdb kai restore... 
>
Ax ti romantiko pou tha itane na ksekinage i vasi! Den mporeis na 
fantaseis! Tha imoun o pio eytixismenos anthropos tou kosmou ;-)

>
>Rikse kai mia matia sto google gia ayta ta mynimata.. Olo kai kapoios tha'xe 
>paromoio problima.
>
Ekei ontos den epsaksa alla omos tha psakso. Thanks for the hint my friend!
 Stamatis