To: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
From: Ray Stell <stellr@vt.edu>
Subject: pg_basebackup recovery failure
Message-ID: <fc535806-9e03-a649-e825-59a296f09cd8@vt.edu>
Date: Tue, 7 Mar 2017 15:31:16 -0500
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:45.0)
 Gecko/20100101 Thunderbird/45.7.1
MIME-Version: 1.0
Content-Type: multipart/alternative;
 boundary="------------A5BC4039A3968F10CC3FF65C"
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

This is a multi-part message in MIME format.
--------------A5BC4039A3968F10CC3FF65C
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit

On this doc page are some command examples for pg_basebackup:

https://www.postgresql.org/docs/current/static/app-pgbasebackup.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?
      

--------------A5BC4039A3968F10CC3FF65C
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 8bit

<html>
  <head>

    <meta http-equiv="content-type" content="text/html; charset=utf-8">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <p>On this doc page are some command examples for pg_basebackup:</p>
    <p>       
      <a class="moz-txt-link-freetext" href="https://www.postgresql.org/docs/current/static/app-pgbasebackup.html">https://www.postgresql.org/docs/current/static/app-pgbasebackup.html</a></p>
    <p>such as:  <br>
    </p>
    <p>
      <meta http-equiv="content-type" content="text/html; charset=utf-8">
      <kbd class="USERINPUT">    pg_basebackup -h mydbserver -D
        /usr/local/pgsql/data</kbd><br>
      <kbd class="USERINPUT"></kbd><br>
    </p>
    <pre class="SCREEN"><kbd class="USERINPUT">I've never gotten this to work.  When I bring up the copy on an intended standby system I always get the classic:
</kbd>
	PANIC:  could not locate a valid checkpoint record
</pre>
    <pre class="SCREEN">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:
 
     <a class="moz-txt-link-freetext" href="https://wiki.postgresql.org/wiki/Streaming_Replication">https://wiki.postgresql.org/wiki/Streaming_Replication</a>

says use the command with this options:
   
     <meta http-equiv="content-type" content="text/html; charset=utf-8">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?
     
<pre></pre></pre></body></html>
--------------A5BC4039A3968F10CC3FF65C--