[ADMIN] WAL Backup Error

2012-11-27 Thread Krawetzky, Peter J
Running 8.4.7 on Linux Starting yesterday we began seeing a read error on the archive_status files. Here is an example: zip warning: could not open for reading: postgresql/data/crppgsq1/pg_xlog/archive_status/000100050045.done Not sure why all of a sudden we are

[ADMIN] WAL backup

2009-07-28 Thread Albert Shih
Hi all I'm not sure I understand http://www.postgresql.org/docs/8.3/interactive/continuous-archiving.html My problem: I've huge database ~ 1To (soon 2 To) and I need backup. I can use pgdump because it's too long to do the backup. So I like to use

Re: [ADMIN] WAL backup

2009-07-28 Thread Greg Spiegelberg
On Tue, Jul 28, 2009 at 1:46 AM, Albert Shih albert.s...@obspm.fr wrote: Hi all I'm not sure I understand http://www.postgresql.org/docs/8.3/interactive/continuous-archiving.html My problem: I've huge database ~ 1To (soon 2 To) and I need backup. I can use pgdump because

Re: [ADMIN] WAL backup

2009-07-28 Thread Albert Shih
Le 28/07/2009 à 06:05:07-0600, Greg Spiegelberg a écrit On Tue, Jul 28, 2009 at 1:46 AM, Albert Shih albert.s...@obspm.fr wrote: Hi all I'm not sure I understand        http://www.postgresql.org/docs/8.3/interactive/ continuous-archiving.html My problem: