| From: | "Bhella Paramjeet-PFCW67" <PBhella(at)Motorola(dot)com> |
|---|---|
| To: | <pgsql-admin(at)postgresql(dot)org> |
| Cc: | "Subbiah Stalin-XCGF84" <SSubbiah(at)Motorola(dot)com> |
| Subject: | Online backups are failing |
| Date: | 2009-01-20 19:21:45 |
| Message-ID: | C84662912D280D4AB5C50100A100F0C503F4BB87@ct11exm61.ds.mot.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bhella Paramjeet-PFCW67 | 2009-01-20 19:43:34 | Re: Online backups are failing |
| Previous Message | Marcelo Martins | 2009-01-20 18:34:03 | Re: PostgreSQL monitoring |