BUG #10726: database gets to an older backup out of nowhere!!!
От | wildfox81@hotmail.com |
---|---|
Тема | BUG #10726: database gets to an older backup out of nowhere!!! |
Дата | |
Msg-id | 20140622123758.2634.78393@wrigleys.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #10726: database gets to an older backup out of
nowhere!!!
|
Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 10726 Logged by: Walid Email address: wildfox81@hotmail.com PostgreSQL version: 9.1.12 Operating system: Win 7 Description: Dear All, I have a PostgreSQL 9.1 server working with a java 6 application on windows 7. Sometimes I found that the db travels in time and many records are missing. It's like the DB had been restored to an older backup. Because some of these fields are according to its cascading structure is un-delete-able. Even the auto IDs goes back as if some one truncated the table and restore just that amount of data. Even I turned off the auto vacuum, I do vacuum the db on regular bases. The problem used to appear more often when I used the auto vacuum. Please also note that: - Once the data came back to the DB after around 20 hours, interesting, ha! - Once the PostgreSQL log recorded a restore commands outs of no where. I saw in the log when the DB was dropped, recreated, then data started to be imported. Any ideas, suggestions, similar accidents!!!
В списке pgsql-bugs по дате отправления: