Re: pg_basebackup recovery failure

For example

standby_mode = 'on'

primary_conninfo = 'host=primaryserver port=5432 user=replication
password=******* '

restore_command = 'rsync -a -e "ssh -o strictHostKeyChecking=no"
server_with_archive_wal_files:/path/to/wal/files/%f %p'

On Tue, Mar 7, 2017 at 12:36 PM, Magnus Hagander <magnus(at)hagander(dot)net>
wrote:

> On Tue, Mar 7, 2017 at 12:31 PM, Ray Stell <stellr(at)vt(dot)edu> wrote:
>
>> On this doc page are some command examples for pg_basebackup:
>>
>> https://www.postgresql.org/docs/current/static/app-pgbasebac
>> kup.html
>>
>> such as:
>>
>> pg_basebackup -h mydbserver -D /usr/local/pgsql/data
>>
>> I've never gotten this to work. When I bring up the copy on an intended standby system I always get the classic:
>> PANIC: could not locate a valid checkpoint record
>>
>> Failing that, I backed up with pg_start_backup/tar/pg_stop_backup as an alternative, but I was always curious what I was doing wrong.
>> The wiki page on setting up replication:
>>
>> https://wiki.postgresql.org/wiki/Streaming_Replication
>>
>> says use the command with this options:
>>
>> pg_basebackup -h 192.168.0.10 -D /srv/pgsql/standby -P -U replication --xlog-method=stream
>>
>> and I stumbled into option:
>>
>> --checkpoint=fast
>>
>> The standby was able to recover when I used one of these, I don't remember which, maybe both.
>>
>> Should the doc be updated or am I missing something?
>>
>>
>>
> If you are using pg_basebackup without a log archive, then yes, you need
> --xlog-method=stream (or fetch). The checkpoint method only affects how
> quickly the checkpoint runs, it will always run.
>
> If you do have a log archive, it should work fine without --xlog=stream,
> but you need to put your restore_command into recovery.conf manually.
>
> --
> Magnus Hagander
> Me: http://www.hagander.net/
> Work: http://www.redpill-linpro.com/
>

--
Thanks,

Jorge Torralba
----------------------------

Note: This communication may contain privileged or other confidential
information. If you are not the intended recipient, please do not print,
copy, retransmit, disseminate or otherwise use the information. Please
indicate to the sender that you have received this email in error and
delete the copy you received. Thank You.