Re: Replication stopped on 9.0.2 after making change to conf file

Поиск
Список
Период
Сортировка
От John Laing
Тема Re: Replication stopped on 9.0.2 after making change to conf file
Дата
Msg-id CAA3Wa=tuqopsnMcMzUFxrUa32htAOtK_HS08e=UOFtePiXDHcA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Replication stopped on 9.0.2 after making change to conf file  (akp geek <akpgeek@gmail.com>)
Ответы Re: Replication stopped on 9.0.2 after making change to conf file
Список pgsql-general
Дерево обсуждения
I'm not sure about the existence of any standard scripts, but we have a pair of checks running periodically on the backup server.

This shouldn't return anything:
tail -3 /var/log/postgresql/postgresql-9.1-main.log | grep FATAL

And this should return something:
ps -u postgres -o cmd | grep "postgres: wal receiver process   streaming"

These have worked very reliably for many months.

-John


On Fri, Mar 8, 2013 at 11:53 AM, akp geek <akpgeek@gmail.com> wrote:
I got it fixed. 

What I did was 

$ psql -c "SELECT pg_start_backup('label', true)"
$ rsync -a ${PGDATA}/ standby:/srv/pgsql/standby/ --exclude postmaster.pid
$ psql -c "SELECT pg_stop_backup()"
It took a while a to catch up the data.

One question I have , are there any scripts to monitor the status of the replciation. so that I can be little proactive

Regards


On Thu, Mar 7, 2013 at 9:25 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
On Thu, Mar 7, 2013 at 5:28 PM, akp geek <akpgeek@gmail.com> wrote:
> Hi all -
>
>                Recently made change on our primary database
>
>               default_text_search_config = 'pg_catalog.simple' . After that
> the replication is stopped. Can you please help me ? how to fix the issue. I
> am sure I made the change on the slave also.
>
> How can I start the replication and catch up the data. Thanks for your time.

What are you seeing in your slony and / or postgresql logs, if anything?


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

Предыдущее
От: Bradley Russell
Дата:
Сообщение: Re: stored procedure slower when called through c client than pgadmin
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: stored procedure slower when called through c client than pgadmin