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

[akp geek <akpgeek@xxxxxxxxx>]

What I noticed is...

our streaming stopped on march 5th.   I restarted the process today.  However the new data is syncing correctly. But the data for these  dates between 5th and today is not syncing.  Is there some thing wrong that I did.

here is what I did.

1.. created base backup 

2.  Took the data directory on to the slave

3.  stopped the base backup on master

4. started the db on slave

Appreciate your help.

Regards

On Sat, Mar 9, 2013 at 12:52 AM, akp geek <akpgeek@xxxxxxxxx> wrote:

Thanks a lot. I started the replication. It became very slow. It is taking long time to sync the masters data onto slave. Is there a way to find what's causing the issue?

Regards

On Fri, Mar 8, 2013 at 12:06 PM, John Laing <john.laing@xxxxxxxxx> wrote:

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@xxxxxxxxx> 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@xxxxxxxxx> wrote:

On Thu, Mar 7, 2013 at 5:28 PM, akp geek <akpgeek@xxxxxxxxx> 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?