I'm running PostgreSQL 9.4, trying to get the replication going.
SELECT pg_start_backup('clone', true);
rsyncof the database to the would-be replica
pg_xlogfolder to the would-be replica
I start replica and it says:
LOG: fetching timeline history file for timeline 3 from primary server FATAL: could not receive timeline history file from the primary server: ERROR: could not open file "pg_xlog/00000003.history": No such file or directory
Naturally I'm looking for the
.history file in
pg_xlog/ on both servers, but there's none.
I'm skimming through the docs to find out that
To make use of the backup, you will need to keep all the WAL segment files generated during and after the file system backup. To aid you in doing this, the pg_stop_backup function creates a backup history file that is immediately stored into the WAL archive area. This file is named after the first WAL segment file that you need for the file system backup. For example, if the starting WAL file is 0000000100001234000055CD the backup history file will be named something like 0000000100001234000055CD.007C9330.backup.
However it just so happens that after I do
pg_stop_backup() there's still nothing like this in
pg_xlog/, nor anywhere.
So where do I get this "timeline history file"?