Re: psql 8 warm standby strong start, weak finish

On 04/30/2015 07:03 AM, Charlton Galvarino wrote:
>> So what is your archive_command?
>
> archive_mode = on
> archive_command = 'cp -v %p /var/lib/pgsql/archives/%f'
> archive_timeout = 300
>

So where does the rsync you mentioned previously fit into this?

>> 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'

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.

Where are you getting pg_standby from?

>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com