Home > mailing lists

BAKUP ISSUE - Mailing list pgsql-general

From	Ramesh T
Subject	BAKUP ISSUE
Date	July 10, 2014 04:37:58
Msg-id	CAK8Zd=vA=FQ+qZ98YsFLEOho7YM_mDGtptbCktmOBpWtYUXXDQ@mail.gmail.com Whole thread Raw
List	pgsql-general

HI,

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

following ,

select pg_start_backup('base');

pg_start_backup

--------------------

0/16000028

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: Sergey Konoplev
Date: 10 July 2014, 02:58:45
Subject: Synonym/thesaurus dictionaries for FTS

From: basti
Date: 10 July 2014, 04:38:10
Subject: Re: php password authentication failed for user ...