Online backups are failing
От | Bhella Paramjeet-PFCW67 |
---|---|
Тема | Online backups are failing |
Дата | |
Msg-id | C84662912D280D4AB5C50100A100F0C503F4BB87@ct11exm61.ds.mot.com обсуждение исходный текст |
Ответы |
Re: Online backups are failing
Re: Online backups are failing Re: Online backups are failing |
Список | pgsql-admin |
Hi, We are running into a problem where our online backups are failing randomly. We are using postgres 8.2.7 and we are seeing this problem in both Solaris and Linux platforms. Our online backup script copies the PGDATA dir with the command "cp -r -P". First we saw this problem on our postgres 8.2.7 database where we had the "stats_block_level" parameter turned on in postgresql.conf file. After I turned off stats_block_level parameter, our backups did not fail. Now we are seeing the problem of our online backups failing on our other databases which are on postgres 8.2.7 and 8.1.13 and on these DB's the stats_block_level parameter is turned off. Has anyone else run into this problem? Any suggestions on how to resolve this problem will be highly appreciated. Thanks Paramjeet Bhella
В списке pgsql-admin по дате отправления: