does pg_rman restore physical datafiles

15 views
Skip to first unread message

Austen Birchall

unread,
Dec 12, 2013, 10:43:36 AM12/12/13
to pg_...@googlegroups.com

If I create a tablespace called test then I get the following

[postgres@train03:~/datafiles/test]$ pwd

/var/lib/pgsql/datafiles/test

[postgres@train03:~/datafiles/test]$ ls -lt

total 4

drwx------. 2 postgres postgres 4096 Dec 12 15:27 PG_9.2_201204301

[postgres@train03:~/datafiles/test]$

 

However if I then do:

rm –rf /var/lib/pgsql/data/*

rm –rf /var/lib/pgsql/datafiles/test/*

 

i.e. delete the physical datafile and then do a restore from a previous back I get the below:

 

[postgres@train03:~/datafiles/test]$ ls -lt

total 0

[postgres@train03:~/datafiles/test]$

 

[postgres@train03:~/data/pg_tblspc]$ pwd

/var/lib/pgsql/data/pg_tblspc

[postgres@train03:~/data/pg_tblspc]$ ls -lt

total 0

lrwxrwxrwx. 1 postgres postgres 54 Dec 12 15:28 16410 -> /var/lib/pgsql/datafiles/test

[postgres@train03:~/data/pg_tblspc]$ ls -lt /var/lib/pgsql/datafiles/test

total 0

[postgres@train03:~/data/pg_tblspc]$

 

Is this expected behaviour?

Does pg_rman restore physical datafiles?

 

Thanks

Austen

 

Reply all
Reply to author
Forward
0 new messages