|
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@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@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 |
