From: | Ramesh T <rameshparnanditech(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org, Hubert Lubaczewski <depesz(at)gmail(dot)com> |
Subject: | BAKUP ISSUE |
Date: | 2014-07-09 10:45:01 |
Message-ID: | CAK8Zd=vA=FQ+qZ98YsFLEOho7YM_mDGtptbCktmOBpWtYUXXDQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | basti | 2014-07-09 11:04:19 | php password authentication failed for user ... |
Previous Message | M Tarkeshwar Rao | 2014-07-09 10:34:27 | Re: Insert query hangs |