Re: pg_standby stuck on a wal file size <16MB

Поиск
Список
Период
Сортировка
От Vlad Kosilov
Тема Re: pg_standby stuck on a wal file size <16MB
Дата
Msg-id 482F7429.80503@contigo.com
обсуждение исходный текст
Ответ на Re: pg_standby stuck on a wal file size <16MB  ("Gurjeet Singh" <singh.gurjeet@gmail.com>)
Список pgsql-general
Gurjeet Singh wrote:
>> archive_command = 'test ! -f /usr/local/wal_archive_local/%f && cp %p
>> /usr/local/wal_archive_local/%f'
>>
>> archive files are then moved  on master to standby every other minute:
>>
>> rsync -aq --remove-sent-files /usr/local/wal_archive_local/
>> slave::wal_archive/
>>
>> slave's recovery.conf:
>> restore_command = '/usr/local/pgsql/bin/pg_standby -d -k 255 -r 7 -s 10 -w
>> 0 -t /usr/local/recovery_control/quit_recovery /usr/local/wal_archive %f %p
>> 2>> /u
>> sr/local/pgsql/data/standby.log'
>>
>> both servers are identical Dell PE1950 servers with 4 sas hd w/hardware
>> RAID 1+0 running:
>> 2.6.18-8.1.8.el5 #1 SMP Tue Jul 10 06:39:17 EDT 2007 x86_64 x86_64 x86_64
>> GNU/Linux
>>
>> Thanks much in advance
>> V.
>>
>
>
> Any reason why you are not using rsync command in the archive_command in the
> first place?
>
> gurjeet[.singh]@EnterpriseDB.com
> singh.gurjeet@{ gmail | hotmail | indiatimes | yahoo }.com
>
> EnterpriseDB http://www.enterprisedb.com
>
> Mail sent from my BlackLaptop device
>
>
I wanted to remove dependency on networking between the nodes and
standby availability at what seems to be a very critical moment -
getting a good archive of a wal file. we tried coping to nfs mounts
before with mixed results on a writes busy db and linux/nfs

Thanks,
V.

--
________________________________________
Vladimir (Vlad) Kosilov
Senior Systems Administrator
Contigo Systems Inc.
604.683.3106 (phone)
604.648.9886 (fax)
vkosilov@contigo.com
www.contigo.com
________________________________________


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

Предыдущее
От: Ioannis Tambouras
Дата:
Сообщение: Re: pg_standby stuck on a wal file size <16MB
Следующее
От: Vlad Kosilov
Дата:
Сообщение: Re: pg_standby stuck on a wal file size <16MB