I'm trying to pg_basebackup my database. I followed instructions in PG Mauals and set it up properly (check on other server and database), but my backup isn't ending - on end of progress it's displaying error:
could not get WAL end position from server
I've found few Q&A about this issue but all resolution was to check owners of files. In my case all files owner is user postgres, chown also OK
What could be the trouble
Server Ubuntu 13.10 Postgresql 9.1, database is having 2 tablespaces.
EDIT
Exact version is: PostgreSQL 9.1.13 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu/Linaro 4.8.1-10ubuntu8) 4.8.1, 64-bit
Exact command is:
pg_basebackup -D /home/osm/bkp_binary/ -Ft -P -v -x -z
select version()
and the exactpg_basebackup
command run?archive_command
andrestore_command
? They must work correctly unless you usepg_basebackup -X stream
which is only available on PostgreSQL 9.3+pg_basebackup
without the-X stream
option or manual copying of WAL files. You should probably take a more detailed look at the docs. I know it's weird and complicated, which is why the whole thing was simplified in 9.3 with the-X stream
option. Basically, the master must be archiving WAL forpg_basebackup
to work, or you must manually copy the extrapg_xlog
over afterwards. Seepg_basebackup
docs for 9.1.