Search Postgresql Archives

BAKUP ISSUE

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



HI,
          I have a problem when i take backup using pg_basebackup and pg_start_backup('base');

following ,

1)
select pg_start_backup('base');
pg_start_backup
--------------------
0/16000028

2)
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.



postgresql.conf in my  postgres
..........................


listen_addresses = '*'


wal_level =hot_standby

# - Archiving -

archive_mode = on
archive_command = 'copy "%p" "C:\\Program Files\\PostgreSQL\\9.3\\data\\pg_xlog\\%f"'

max_wal_senders =5
wal_keep_segments = 10
auto_vaccum is on


please let me know what i should i do...?

Thanks in advance,
ramesh

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux