Re: BAKUP ISSUE - Mailing list pgsql-general

From hubert depesz lubaczewski
Subject Re: BAKUP ISSUE
Date
Msg-id CAKrjmhcmu6B_CscCSXC2B_LHd8wZGu70mqFQ7y41-rOg9QuNsw@mail.gmail.com
Whole thread Raw
In response to Re: BAKUP ISSUE  (hubert depesz lubaczewski <depesz@gmail.com>)
Responses Re: BAKUP ISSUE  (dinesh kumar <dineshkumar02@gmail.com>)
Re: BAKUP ISSUE  (Ramesh T <rameshparnanditech@gmail.com>)
List pgsql-general
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@gmail.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

pgsql-general by date:

Previous
From: M Tarkeshwar Rao
Date:
Subject: Re: Insert query hangs
Next
From: Adrian Klaver
Date:
Subject: Re: Insert query hangs