Re: [GENERAL] BAKUP ISSUE

2014-07-10 Thread Marc Watson
De : pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] De la part de hubert depesz lubaczewski Envoyé : July-09-14 9:55 AM On Wed, Jul 9, 2014 at 3:28 PM, Ramesh T mailto:rameshparnandit...@gmail.com>> wrote: Yes,not an error it is a warning and archive is wo

Re: [GENERAL] BAKUP ISSUE

2014-07-09 Thread Michael Paquier
On Wed, Jul 9, 2014 at 10:54 PM, hubert depesz lubaczewski wrote: > I have 0 knowledge about windows, but I would guess you need to use \\ and > not \ in the path. Also - does the destination path exist? > Confirmed. -- Michael

Re: [GENERAL] BAKUP ISSUE

2014-07-09 Thread Ramesh T
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

Re: [GENERAL] BAKUP ISSUE

2014-07-09 Thread hubert depesz lubaczewski
On Wed, Jul 9, 2014 at 3:28 PM, Ramesh T wrote: > Yes,not an error it is a warning and archive is working. > How can you say that archive is working when in logs you have? > 2014-07-09 18:53:33 IST LOG: archive command failed with exit code 1 > 2014-07-09 18:53:33 IST DETAIL: The fail

Re: [GENERAL] BAKUP ISSUE

2014-07-09 Thread dinesh kumar
Hi, On Wed, Jul 9, 2014 at 2:43 PM, Ramesh T > 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* >> *

Re: [GENERAL] BAKUP ISSUE

2014-07-09 Thread hubert depesz lubaczewski
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 wrote: > i rune problem is when i run the pg_stop_backup() its return error in

Re: [GENERAL] BAKUP ISSUE

2014-07-09 Thread hubert depesz lubaczewski
On Wed, Jul 9, 2014 at 12:45 PM, Ramesh T wrote: > HI, > I have a problem when i take backup using pg_basebackup and > pg_start_backup('base'); > following , > What is the problem? You didn't write it. Just some outputs and config, but you never mentioned what is the problem itself.