Postgresql-8.4: File System Level Backup (& recovery failure)
От | Ennio-Sr |
---|---|
Тема | Postgresql-8.4: File System Level Backup (& recovery failure) |
Дата | |
Msg-id | 20121120171227.GA3101@deby.ei.hnet обсуждение исходный текст |
Ответы |
Re: Postgresql-8.4: File System Level Backup (& recovery failure)
|
Список | pgsql-novice |
Hi all! I'm trying to recover my database from a file system backup (as decribed at #24.2 of Postgresql 8.4 Documentation). WHile the files in the backup directory are owned by 'postgres.postgres', when they are extracted from the backup.tar the owner becomes 'avahi.haldaemon' or ('messagebus.ssh' if they are copied directly from backup dir to a new one). I do change file ownership to postgres.postgres but cannot see any of the tables and get a void 'mydb' only! As I am not sure to have stopped the postgres server *before* making the original copy to the backup dir, is there any chance for me to: 1. ascertain that the backup was made while postgres was running and therefore it's completely useless; 2. make sure that failure to recover has nothing to do with the version of postgresql-client. AAMOF, I've lost access to original database tables after removing postgresql-client-9.1 in the believe it was redundant: I had previously downgraded to version 8.4 after having the problem as exposed in my post of Oct 17 "WARNING: psql version 8.4, server version 9.1" unluckily unanswered and not getting any further warning I was convinced to be runnning everithing on 8.4; 3. make sure there is no possibility to recover old data this way and use an older db.dump (which, of course, would be the easiest way, but would leave me with so many doubts pending....) Thanks for your attention, Ennio -- [Perche' usare Win$ozz (dico io) se ..."anche uno sciocco sa farlo. \\?// Fa' qualche cosa di cui non sei capace!" (diceva Henry Miller) ] (°|°) [Why use Win$ozz (I say) if ... "even a fool can do that. )=( Do something you aren't good at!" (as Henry Miller used to say) ]
В списке pgsql-novice по дате отправления: