From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Charlton Galvarino <charlton(at)2creek(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: psql 8 warm standby strong start, weak finish |
Date: | 2015-05-01 00:36:59 |
Message-ID: | 5542CAAB.204@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 04/30/2015 05:22 PM, Charlton Galvarino wrote:
> MASTER
> * archive_command = 'cp -v %p /var/lib/pgsql/archives/%f'
> * rsync files in [MASTER:/var/lib/pgsql/archives that are +10m and delete on them once sent] to [STANDBY:/var/lib/pgsql/archives]
>
> STANDBY
> * restore_command = 'pg_standby -d -s 2 -t /tmp/pgsql.trigger /var/lib/pgsql/archives %f %p %r 2>>standby.log'
> * no cleanup to do since pg_standby cleans up old WAL's
>
> MASTER and STANDBY are completely separate servers that do not have any common disk space.
> ________________________________________
From here:
https://wiki.postgresql.org/wiki/Warm_Standby
"Set archive_command in the master's postgresql.conf. rysnc is a popular
choice or you can just use one of the examples from the docs. I use:
rsync -a %p postgres(at)standbyhost:/path/to/wal_archive/%f
"
Simplifies the process.
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Fabio Ugo Venchiarutti | 2015-05-01 01:03:03 | Re: PostgreSQL HA config recommendations |
Previous Message | Charlton Galvarino | 2015-05-01 00:22:21 | Re: psql 8 warm standby strong start, weak finish |