Re: streaming replication question

Поиск
Список
Период
Сортировка
От wd
Тема Re: streaming replication question
Дата
Msg-id CABexzmiZE=Z+d5Xwd4OVZxe7hhXsn6JwMs=BSN_C7kXt4pGOJQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: streaming replication question  (Roberto Scattini <roberto.scattini@gmail.com>)
Список pgsql-general
Дерево обсуждения



On Fri, Mar 22, 2013 at 11:27 AM, Roberto Scattini <roberto.scattini@gmail.com> wrote:


On Thursday, March 21, 2013, wd <wd@wdicc.com> wrote:
> You can combine warm standby and streaming, we do this in our product database.
> When the standby is to far from the master, the slave will try to use restore_command to restore the database(warm standby), when the standby catch up the master, the steaming will working again.
>
> BTW: we use ominipitr.
>

ok. tomorrow i will check that again. i think that when restore_command was enabled in the slave, the wal receiver proccess didnt appear (and i didnt see the changes inmediately happening in the slave).


I think you should use an other restore_command, in warm standby, the resotre_command will not exit and continue check xlog files and restore them, the streaming won't start when in restore. Try use cp instead of it.

 
can you post your recovery.conf?

primary_conninfo = ''
restore_command = '/opt/omnipitr/bin/omnipitr-restore -l /export/omnipitr/log/omnipitr-^Y^m^d.log -s gzip=/export/vacation_wal_archive -f /export/omnipitr/finish.recovery -r -sr -v -t /export/omnipitr/tmp/ %f %p'                        
archive_cleanup_command = '/opt/omnipitr/bin/omnipitr-cleanup -l /export/omnipitr/log/cleanup.log -a gzip=/export/vacation_wal_archive %r' 
 

thanks for the reply!


--
Roberto Scattini


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

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: [pgeu-general] Alphanumeric natural order sorting
Следующее
От: Juraj Fabo
Дата:
Сообщение: Why is pg_xlog/archive_status of HotStandby synced with master?