From: | Charlton Galvarino <charlton(at)2creek(dot)com> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(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-04-30 14:03:59 |
Message-ID: | BY2PR0101MB1494BDA90FD672C2A023BFEEFCD60@BY2PR0101MB1494.prod.exchangelabs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
>So what is your archive_command?
archive_mode = on
archive_command = 'cp -v %p /var/lib/pgsql/archives/%f'
archive_timeout = 300
>Where is the listing below from?:
The below listing was warm_standby: /var/lib/pgsql/archives/
>> -rw------- 1 postgres postgres 16777216 Apr 29 05:07
>00000001000010E5000000EA
>> -rw------- 1 postgres postgres 16777216 Apr 29 05:11
>00000001000010E5000000EB
>> -rw------- 1 postgres postgres 16777216 Apr 29 05:15
>00000001000010E5000000EC
>> -rw------- 1 postgres postgres 16777216 Apr 29 05:15
>00000001000010E5000000ED
>> -rw------- 1 postgres postgres 16777216 Apr 29 05:15
>00000001000010E5000000EE
>> -rw------- 1 postgres postgres 12337152 Apr 29 05:20
>00000001000010E5000000EF
>> -rw------- 1 postgres postgres 16777216 Apr 29 05:25
>00000001000010E5000000F0
>> -rw------- 1 postgres postgres 16777216 Apr 29 05:30
>00000001000010E5000000F1
# warm_standby:/var/lib/pgsql/data/recovery.conf
restore_command = 'pg_standby -l -d -s 2 -t /tmp/pgsql.trigger /var/lib/pgsql/archives %f %p %r 2>>standby.log'
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2015-04-30 14:16:09 | Re: psql 8 warm standby strong start, weak finish |
Previous Message | Adrian Klaver | 2015-04-30 13:50:16 | Re: psql 8 warm standby strong start, weak finish |