Re: psql 8 warm standby strong start, weak finish - Mailing list pgsql-general

From Charlton Galvarino
Subject Re: psql 8 warm standby strong start, weak finish
Date
Msg-id BY2PR0101MB1494057D5A9FEA5A4B688A85FCD60@BY2PR0101MB1494.prod.exchangelabs.com
Whole thread Raw
In response to Re: psql 8 warm standby strong start, weak finish  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: psql 8 warm standby strong start, weak finish
List pgsql-general
>So where does the rsync you mentioned previously fit into this?

A cron runs on warm_standby to pull (and delete) the WAL's from the master.

rsync -avz --progress --remove-sent-files master:/var/lib/pgsql/archives/ /var/lib/pgsql/archives/

>I do not see an -l option in the 8.4.x version of pg_standby, I do see it in the
>8.3 version.

I agree.  pg_standby --help says exactly that.

-l                 does nothing; use of link is now deprecated

>Where are you getting pg_standby from?

-bash-3.2$ which pg_standby
/usr/bin/pg_standby

-bash-3.2$ pg_standby --version
pg_standby (PostgreSQL) 8.4.17


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: psql 8 warm standby strong start, weak finish
Next
From: Adrian Klaver
Date:
Subject: Re: psql 8 warm standby strong start, weak finish