Re: BAKUP ISSUE

hi,
Yes,not an error it is a warning and archive is working.
when i archivelog is on in postgresql.conf .

when try to run below statement its return warning and HINT: Check that
your archive_command is executing properly

like below ..
postgres=# select pg_stop_backup();

it is going on 60 seconds,120 seconds 240 seconds,480 seconds ....and so
when it is going stop and gets completed.

it is taking too much of time but not completing,what i should i do..

*NOTICE: pg_stop_backup cleanup done, waiting for required WAL segments to
be ar*
*chived*
*WARNING: pg_stop_backup still waiting for all required WAL segments to be
archi*
*ved (60 seconds elapsed)*
*HINT: Check that your archive_command is executing properly.
pg_stop_backup ca*
*n be canceled safely, but the database backup will not be usable without
all the*
* WAL segments.*

*WARNING: pg_stop_backup still waiting for all required WAL segments to
be archi*
*ved (120 seconds elapsed)*
*HINT: Check that your archive_command is executing properly.
pg_stop_backup ca*
*n be canceled safely, but the database backup will not be usable without
all the*
* WAL segments.*

*i changed path *c:\program files\postgresql\9.3\data\pg_xlog TO c:\program
files\postgresql\ramesh
no files in c:\program files\postgresql\ramesh

in pg log it say

2014-07-09 18:53:33 IST LOG: archive command failed with exit code 1
2014-07-09 18:53:33 IST DETAIL: The failed archive command was: copy
"pg_xlog\000000010000000000000001" "C:Program FilesPostgreSQL
amesh 000000010000000000000001"
2014-07-09 18:53:34 IST LOG: archive command failed with exit code 1
2014-07-09 18:53:34 IST DETAIL: The failed archive command was: copy
"pg_xlog\000000010000000000000001" "C:Program FilesPostgreSQL
amesh 000000010000000000000001"
2014-07-09 18:53:34 IST WARNING: archiving transaction log file
"000000010000000000000001" failed too many times, will try again later

please let me know what should i do,how to set the archive command in
windows.

thanks in advance
ramesh

On Wed, Jul 9, 2014 at 6:23 PM, hubert depesz lubaczewski <depesz(at)gmail(dot)com>
wrote:

> Hi,
>
> First - do not take the messages off list. Someone else might be able to
> help you if you'll mail to the list, I'm not always there, and others might
> have better ideas.
>
>
> On Wed, Jul 9, 2014 at 2:43 PM, Ramesh T <rameshparnanditech(at)gmail(dot)com>
> wrote:
>
>> i rune problem is when i run the pg_stop_backup() its return error in
>> this way
>>
>> postgres=# select pg_stop_backup();
>>
>>
>> *NOTICE: pg_stop_backup cleanup done, waiting for required WAL segments
>> to be ar*
>> *chived*
>> *WARNING: pg_stop_backup still waiting for all required WAL segments to
>> be archi*
>> *ved (60 seconds elapsed)*
>> *HINT: Check that your archive_command is executing properly.
>> pg_stop_backup ca*
>> *n be canceled safely, but the database backup will not be usable without
>> all the*
>> * WAL segments.*
>>
>
> But there is no ERROR?! What error are you talking about?
>
> This is just notice and a warning.
>
>
>> i changed in postgresql.conf to archive_command = 'copy "%p" "C:\Program
>> Files\PostgreSQL\ramesh %f"' still working same error return..
>>
>
> What error? So far you didn't show any.
>
> Is the archiving working? Are there files in c:\program
> files\postgresql\ramesh ?
> If not, what does pg logs say about archiving? Any errors there?
>
> depesz
>