Re: WAL FILES
От | Ashish Karalkar |
---|---|
Тема | Re: WAL FILES |
Дата | |
Msg-id | 002a01c79908$b2ce4880$170211ac@LIONKING.COM обсуждение исходный текст |
Ответ на | WAL FILES ("Khan, Mahmood Ahram" <Mahmood.Khan@in.unisys.com>) |
Список | pgsql-admin |
The archive command should generally be designed to refuse to overwrite any pre-existing archive file. This is an important safety feature to preserve the integrity of your archive in case of administrator error (such as sending the output of two different servers to the same archive directory). It is advisable to test your proposed archive command to ensure that it indeed does not overwrite an existing file, and that it returns nonzero status in this case. We have found that cp -i
does this correctly on some platforms but not others. If the chosen command does not itself handle this case correctly, you should add a command to test for pre-existence of the archive file. "
----- Original Message -----From: Khan, Mahmood AhramTo: Ashish KaralkarSent: Friday, May 18, 2007 9:07 AMSubject: RE: [ADMIN] WAL FILESThanks Ashish,
Its working fine now. And I set the archive timeout parameter to 25. (i,e 25 seconds).
So Thanks once again.
Thanks & Best Regards
M.AHRAM KHAN
From: Ashish Karalkar [mailto:ashish.karalkar@info-spectrum.com]
Sent: Thursday, May 17, 2007 6:26 PM
To: Khan, Mahmood Ahram
Subject: Re: [ADMIN] WAL FILES
I think u should try
archive_command = ' copy %p d:\archive\%f '
I hope this should work.
I am not windows user but still i think.
Please let me know if it works.
set the archive timeout para to lower value to see it works or nt immediately.
With regards
Ashish...
----- Original Message -----
From: Khan, Mahmood Ahram
Sent: Thursday, May 17, 2007 4:42 PM
Subject: [ADMIN] WAL FILES
Hi All,
I am archiving PostgreSQL Database. I want to copy all my WAL files from pg_xlogs folder to d:\archive
I am using PostgreSQL 8.2 on Windows XP.
And my archive_command looks like this ( archive_command copy c:\Program Files\PostgreSQL\8.2\data\pg_xlog d:\archive\ )
But it is loading the files in pg_xlogs folder itself. So Can anybody have idea about this.
Thanks & Regards
M.AHRAM KHAN
В списке pgsql-admin по дате отправления: