Thank you for the details David and Stephen..
I am unable to recover the database which associated with user table space .
Please see the below test case and suggest me,if any one has the issues while recovering single database.
Test case:
1) created tablespace tblsp1 .
2) created database db1 with tablespace tblsp1;
3) created another database db2 ( with out tablespace , it means it is going to be created under pg_default table space)
4) Taken full backup.
5) create table t1 on both db1 and db2 databases .
6) Taken Incremental backup
7) a) We have tried to restore the db1 on different location by mapping table-space and without table-space .
However we got the below Error
pgbackrest --stanza=online_backups --db-include=db1 --tablespace-map-all=/u02/pgdata02/report2 restore
ERROR [080]: : database to include 'db1' does not exist
b) We have tried to restore the db1 on different location and we got the below Error
pgbackrest --stanza=online_backups --delta --db-include=db1 restore
ERROR [080]: : database to include 'db1' does not exist
Please help me can we restore single database ,if it is assigned with tables space? .
And also let me know if anything missing in my test case ?
Note : if I restore the db2, whicich is associated with pg_default tablespace it is working.
pgbackrest --stanza=online_backups --delta --db-include=db2 restore
Thanks,
Chiru
