WG: postgres pg_basebackup

Hello

I have a database with the following tablespaces:

pgwb=# \db

List of tablespaces

Name | Owner | Location

------------+-------+-------------------------------------

bspace | pgwb | /data1/tablespaces/TS_B_SPACE/tests

meta | pgwb | /data1/tablespaces/metadata/tests

mspace | pgwb | /data1/tablespaces/TS_M_SPACE/tests

nspace | pgwb | /data1/tablespaces/TS_N_SPACE/tests

pg_default | pgwb |

pg_global | pgwb |

uspace | pgwb | /data1/tablespaces/TS_U_SPACE/tests

(7 rows)

They are referenced in as symbolic links in:

pgwb(at)BLIXSQL0:/data1/pgwb/pg_tblspc> ls -l /data1/pgwb/pg_tblspc

total 0

lrwxrwxrwx 1 pgwb users 35 May 9 09:17 16536 -> /data1/tablespaces/TS_U_SPACE/tests

lrwxrwxrwx 1 pgwb users 35 May 9 09:17 16537 -> /data1/tablespaces/TS_B_SPACE/tests

lrwxrwxrwx 1 pgwb users 35 May 9 09:17 16538 -> /data1/tablespaces/TS_N_SPACE/tests

lrwxrwxrwx 1 pgwb users 35 May 9 09:17 16539 -> /data1/tablespaces/TS_M_SPACE/tests

lrwxrwxrwx 1 pgwb users 33 May 9 09:17 16540 -> /data1/tablespaces/metadata/tests

I have setup the database for PIT recovery.

To make a base backup I use pg_basbackup like:

pg_basebackup --xlog --format=t -D /data1/backup/`date +%Y%m%d`

In the backup folder I have the following files:

pgwb(at)BLIXSQL0:/data1/backup/20170510> ls -l

total 62772

-rw-r--r-- 1 pgwb users 289792 May 10 13:51 16536.tar

-rw-r--r-- 1 pgwb users 2821120 May 10 13:51 16537.tar

-rw-r--r-- 1 pgwb users 2821120 May 10 13:51 16538.tar

-rw-r--r-- 1 pgwb users 371712 May 10 13:51 16539.tar

-rw-r--r-- 1 pgwb users 716800 May 10 13:51 16540.tar

-rw-r--r-- 1 pgwb users 57170432 May 10 13:51 base.tar

Now a crash happens I have to restore from this tar files, but I don't know the symbolic link destination.

How can I solve this?

Do I need a pg_dump from the tablespaces?

Regards

Wolfgang

Telefon: +43 1 711 23 - 883332