I configured a basebackup on a Postgres 9.5 server, specifying that the xlogs should be fetched, and that the file will be a compressed tar archive. I configured this basebackup to run on my standby server filesystem (which was setup with postgres internal streaming asynchronous replication).
Details as follows:
archive_mode = off
max_wal_senders = 5
pg_basebackup -U postgres -D - -Ft -Xf -z > mycompressed.tar.gz
When I unpacked my tar file, the pg_xlog
directory (which is setup as a physical directory, not a link) is empty, though the backup completion was clean. I can get the DB to come up, but I get OID not found errors when I select some objects, indicating an inconsistent state. Am I missing something?
Note: When I run this procedure on the master, there are no issues at all, and all of the WAL files are captured in the tar file.
tar -tvf mycompressed.tar.gz |tail
pg_resetxlog
. Are you sure that pg_basebackup is the correct version?