Postgres Pro
Downloads
Home   >   mailing lists

pg9.6: no backup history file (*.backup) created on hot standby - Mailing list pgsql-general

From magodo
Subject pg9.6: no backup history file (*.backup) created on hot standby
Date
Msg-id 6ac35bd51a0a4faad011fab162a2888a09ab2dd7.camel@sina.com
Whole thread Raw
Responses Re: pg9.6: no backup history file (*.backup) created on hot standby  (Michael Paquier <michael@paquier.xyz>)
List pgsql-general
Tree view 
Hello,

I am using PostgreSQL-9.6, trying to do basebackup on a hot standby
with archive mode set to always. However, I found there is no backup
history file (*.backup) generated in the archive destination directory
after `pg_basebackup`, which is not the case if I do the same thing on
the primary.

Is this as expected? If so, in which case should I do backup on primary
and in which case should I do it on standby?

Thank you in advance!

Magodo

pgsql-general by date:

Previous
From: Rajni Baliyan
Date:
Subject: Re: pg_controldata: could not read file "/opt/postgres/9.2/data//global/pg_control":Success
Next
From: Jean-Paul Argudo
Date:
Subject: Re: Why the index is not used ?