Re: psql 8 warm standby strong start, weak finish

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'

In response to

Responses

Browse pgsql-general by date

  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