BAKUP ISSUE

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

Responses

Browse pgsql-general by date

  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