Re: recover from base directory?
От | patrick |
---|---|
Тема | Re: recover from base directory? |
Дата | |
Msg-id | 014601c6581f$f4c0e2f0$6700a8c0@audio обсуждение исходный текст |
Ответ на | recover from base directory? ("patrick" <patrick@11h11.com>) |
Ответы |
Re: recover from base directory?
|
Список | pgsql-general |
some update... but still not working. so to resume i have base / pg_xlog (2 files and archives dir.) / pg_clog - BUT no global. i reinstalled postgresql 8.0.4 (same version of my backup data/). initdb, createdb mydb1, mydb2 mydb3 and move pg_xlog and _clog over the data. rename my base to fit the oid. starting postmaster is working fine, but i had to do a pg_resetxlog and now it start like normal. but the problem is when i pgsql mydb1 \d no relations founds... what can i do? pat ----- Original Message ----- From: "patrick" <patrick@11h11.com> To: <pgsql-general@postgresql.org> Sent: Tuesday, April 04, 2006 3:45 AM Subject: [GENERAL] recover from base directory? > hi all, > > 1) do backup always... on cd, tape, raid. my hd just burn. > > there is hope for me, in lost+found there is a directory called base with > multiples sub-direcotry (403274 for example). is this my database, can i > recover them with thoses directory? > > look in the archive for recover base... nothing really like that was > explain... but sorry if it's somewhere!!! > > pat > > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match >
В списке pgsql-general по дате отправления: