Re: [ADMIN] Standby wal issue

Поиск
Список
Период
Сортировка
От chris kim
Тема Re: [ADMIN] Standby wal issue
Дата
Msg-id 8e33df50-415d-6336-e26f-59d213a5ea9e@propaas.com
обсуждение исходный текст
Ответ на Re: [ADMIN] Standby wal issue  ("Joshua D. Drake" <jd@commandprompt.com>)
Список pgsql-admin
Thanks for helping. Here's the recovery.conf file:

standby_mode= 'on'
trigger_file = '/tmp/standby.trg'
archive_cleanup_command = '/usr/pgsql-9.2/bin/pg_archivecleanup 
/ComplianceDB/data/pg_xlog/ %r'



On 11/06/2017 02:22 PM, Joshua D. Drake wrote:
> On 11/06/2017 11:34 AM, chris kim wrote:
>> Hi Community,
>>
>> I have a standby server that is in replication mode only, and is 
>> storing an insane amount of wal files and it's only on the standby 
>> not the master. I have over 50,000 wal files right now. I only have a 
>> few processes running on the background and they all seem to not be 
>> the problem. This is running on postgres 9.2. Any help would be 
>> greatly appreciated.
>
> What does your recovery.conf file say?
>
> JD
>
>>
>>
>> Thanks,
>>
>> Chris
>>
>>
>>
>



-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: [ADMIN] Standby wal issue
Следующее
От: PropAAS DBA
Дата:
Сообщение: [ADMIN] ERROR: invalid byte sequence for encoding "UTF8": 0x00