Thread: BAKUP ISSUE
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